pythonbeginner

Pandas Pivot Table Summary

Create multi-level summary pivot tables from transactional data using pd.pivot_table.

python
import pandas as pd
import numpy as np

df = pd.DataFrame({
    'region': np.random.choice(['North','South','East','West'], 200),
    'product':np.random.choice(['A','B','C'], 200),
    'channel':np.random.choice(['online','store'], 200),
    'sales':  np.random.randint(10, 500, 200),
})

table = pd.pivot_table(
    df,
    values='sales',
    index=['region','product'],
    columns='channel',
    aggfunc={'sales': ['sum','mean']},
    fill_value=0,
    margins=True,
)
print(table)

Use Cases

  • sales reporting
  • cross-tab analysis
  • BI summaries

Tags

Related Snippets

Similar patterns you can reuse in the same workflow.