PyPath
Start learning

Unit 7 · Grouping and Aggregating

Split the table, work on each part, and put the answers back together.

  1. 1Split, Apply, CombineThe shape of every group-by, named once so the rest makes sense.
  2. 2Counting GroupsHow many of each, and the difference between size and count.
  3. 3agg with Several SummariesMore than one answer per group, named as you want them.
  4. 4Grouping by Several KeysTwo keys give a row per combination, and an index with two levels.
  5. 5transform versus aggregateOne answer per group, or one answer per row.
  6. 6Pivot TablesA grouped summary laid out as a grid.