Exercise: Answer Key

Aggregating Data Exercise Answer Key

listings = pd.read_parquet('clean_listings.parquet', engine='pyarrow')
value_by_make = listings.groupby(['make'])['price'].sum()
avg_mileage_by_vehicle = listings.groupby(['year', 'make', 'model'], as_index=False)['mileage'].mean()
city_mpg_ranges = listings.groupby(['transmission', 'drivetrain'], as_index=False)['city_mpg'].agg(['min', 'max'])
median_hwy_mpg_by_fuel = listings.groupby(['fuel_type'], as_index=False)['hwy_mpg'].agg(['median', 'std'])