Pandas groupby: Multiple columns and multiple aggregation methods

Pandas groupby: Multiple columns and multiple aggregation methods

Does Python Pandas allow multiple categorical columns and multiple methods?

Yes!

df.groupby(['passenger_count', 'VendorID'])['trip_distance'].agg(['mean', 'std'])

The above returns:

– A 2-column data frame (mean + std)
– A 2-level index (passenger_count + VendorID)