LernerPython+data

Grouping and pivot tables in Pandas

In the real world, data is messy and incomplete. That’s why it’s so important to know how to clean your data. In this class, I introduce a number of techniques you can use to turn bad data into better, cleaner data.

What you should know

Course Content

Course length

2 hours

Number of lessons

1

Training materials

1 Jupyter notebook

Coding exercises

3

LEARN MORE

Grouping is an essential part of data analysis, and Pandas provides us with multiple ways to group our data. In this course, we’ll dive into grouping, understanding how it works and how to use it. We’ll also explore pivot tables, a form of 2D grouping.

  • What grouping is
  • How to use the “groupby” method
  • Grouping on multiple columns
  • Calculating on multiple columns
  • Using multiple aggregation methods
  • Pivot tables vs. groupby
  • Why pivot tables?

This course, like all others on LernerPython.com, is taught by Reuven Lerner.