Python Quest

Track 14 · Lesson 8 of 12

Grouping and aggregating

Answer per-group questions with groupby, compute several statistics at once with agg, and build two-way summaries with pivot_table and crosstab.

About 50 minAdvanced4 exercises

You will be able to

  • Explain the split-apply-combine idea behind groupby
  • Aggregate one or more columns per group, with one or several functions
  • Name output columns with named aggregation in agg
  • Build a two-way table with pivot_table and count combinations with crosstab

Included with a Formula Quest membership

It has 4 graded exercises with feedback, hints and solutions. Python Quest is included in Formula Quest memberships that cover Python; membership and billing are managed on Formula Quest.

View Formula Quest memberships

Tracks 1 and 2, the first lesson of every track, the playground and the dataset library are free.