The Pivot Table Function

What is a pivot table?

A pivot table is a summary table obtained by grouping and aggregating values of a more extensive table. Suppose we have an orders table that contains the day, order amount, and customer code for each order. A pivot table can be created to show the daily total order amounts. We need to group the rows by day and then aggregate by taking the sum.

Creating pivot tables with Pandas

A pivot table is a great tool to summarize, sort, group, and aggregate tabular data. Thanks to the pivot_table function, we can easily create pivot tables with Pandas. It has several parameters that provide flexibility comparable to Excel.

Let’s create a pivot table to see the weekly total sales quantities of the product groups in the grocery.