Lesson 2.3

groupby and aggregation

Split, apply, combine is the pattern behind nearly every summary table you will ever produce.

11mBeginner23.3k students

Overview

What this lesson covers

  • Group rows and aggregate each group
  • Apply several aggregations at once
  • Pivot and reshape a summary for presentation

This lesson sits in pandas Essentials, part of Python for Data Work. It assumes what came before it and leads directly into the next lesson in the module.


In this lesson you will:

  • Group rows and aggregate each group
  • Apply several aggregations at once
  • Pivot and reshape a summary for presentation
Pro Tip

Think split-apply-combine. Almost every reporting question is a groupby wearing a disguise.