Grouping and summing: the beginner's pivot table

Python for Spreadsheet Users

Chris Cardillo

Data Scientist

Fruit stores

bigger fruit df.png

Fruit stores

bigger fruit store column.png

Fruit stores

bigger fruit product column.png

Fruit stores

bigger fruit quantity column.png

Fruit stores

bigger fruit revenue column.png

Pivoting in spreadsheets

Raw Data

bigger fruit df.png

Pivot Table

bigger fruit value pivot.png

Pivot Table Editor

bigger fruit value pivot table editor.png

Pivoting in spreadsheets

Raw Data

bigger fruit df.png

Pivot Table

bigger fruit value pivot.png

Pivot Table Editor

bigger fruit value pivot table editor values focus.png

.sum()

fruit_sales.head()

fruit sales head.png

fruit_sales.sum(numeric_only=True)

fruit sales sum.png

Pure summary with .sum()

In spreadsheets

bigger fruit value pivot.png

In Python

fruit_sales.sum(numeric_only=True)

fruit sales sum.png

Using pivot table rows in spreadsheets

Pivot Table

fruit sales store pivot table.png

Pivot Table Editor

bigger fruit pivot table editor with stores highlighted.png

A simple pivot table in Python - .groupby().sum()

In Python

fruit_sales.groupby('store', as_index=False).sum()

fruit sales store summary.png

In spreadsheets

fruit sales store pivot table.png

A simple pivot table in Python - .groupby().sum()

In Python

fruit_sales.groupby('store', as_index=False).sum()

In spreadsheets pivot table editor

Rows and Values Only.png

A simple pivot table in Python - .groupby().sum()

In Python

fruit_sales.groupby('store', as_index=False).sum()

fruit sales store summary.png

In spreadsheets

fruit sales store pivot table.png

Your turn!

Python for Spreadsheet Users