listings = pd.read_pickle('unclean_listings.pkl')
listings.rename(columns={'header':'listing_title', 'transmission':'transmission_type'}, inplace=True)
listings[['vin', 'price', 'listing_title', 'trim', 'engine', 'mileage', 'transmission_type', 'drivetrain', 'fuel_type', 'mpg', 'exterior_color', 'interior_color', 'location']]
listings.drop(df.columns[[13]], axis=1)
listings.drop(['mpg'], axis=1, inplace=True)