Python for Data · Unit 7
Unit 7: Grouping and Aggregating
Group pandas rows by category to get counts, totals and averages.
Lessons
- Split, Apply, CombineThe shape of every group-by, named once so the rest makes sense.
- Counting GroupsHow many of each, and the difference between size and count.
- agg with Several SummariesMore than one answer per group, named as you want them.
- Grouping by Several KeysTwo keys give a row per combination, and an index with two levels.
- transform versus aggregateOne answer per group, or one answer per row.
- Pivot TablesA grouped summary laid out as a grid.
-
Take the Unit 7 test
End of unit test
Ten multiple choice questions and one free response problem. You need 70 to finish the unit. Retakes are unlimited and your best score is the one that counts.