Pandas groupby basics: Aggregating a numeric column by category

The simplest grouping in Python Pandas is groupby:

df.groupby(CATEGORICAL)[NUMERIC].AGG_METHOD()

For example:

df.groupby('passenger_count')['trip_distance'].mean()

Returns a series whose index is the unique values from passenger_count.