Pivot Tables

This lesson will focus on how to create pivot tables in Python using pandas.

Pivot Tables

Pivot tables are a summary of the whole data that give us useful information. These tables reorganize the desired data in a different format. These tables can transform data from columns to rows or rows to columns, or group data by any attribute. Because of the reorganization and transformation of the data, these tables were given the name pivot. These tables can include statistics such as sum, mean, maximum, minimum, and many more.

Use cases

Pivot Tables are used to:

  • Group data for business problems such as calculating sales by region or products
  • Compare different classes of a data field such as comparing data for males and females
  • Easily find out unique values in a field such as finding out different types of products for which we have data.
  • Summarize complex tables

Get hands-on with 1200+ tech skills courses.