4 / 10 Pandas Core

Pandas GroupBy Aggregation

What does this code return?

df.groupby('department')['salary'].agg(['mean', 'max', 'count'])
A

Three separate Series for mean, max, and count

B

A Series with mean, max, count for all salaries

C

A DataFrame with one row per department and columns for mean, max, count

D

A dictionary mapping department to statistics