PyInns - Home

Pivot Tables in Pandas – Powerful Data Reshaping with pivot_table() in Python 2026

The pivot_table() function is one of Pandas’ most powerful tools for data manipulation and reporting. It allows you to reshape data, create cross-tabulations, and generate summary tables similar to Excel pivot tables — but with much more flexibility and speed.

TL;DR — Key Parameters of pivot_table()

values – column(s) to aggregate
index – rows (grouping keys)
columns – columns (grouping keys)
aggfunc – aggregation function(s) to apply
margins=True – add grand totals

1. Basic Pivot Table

import pandas as pd

df = pd.read_csv("sales_data.csv", parse_dates=["order_date"])

# Simple pivot table: Sales by Region and Category
pivot = pd.pivot_table(
    df,
    values="amount",
    index="region",
    columns="category",
    aggfunc="sum",
    margins=True,           # add grand total
    margins_name="Total"
).round(2)

print(pivot)

2. Advanced Pivot Table with Multiple Aggregations

report = pd.pivot_table(
    df,
    values=["amount", "quantity"],
    index=["region", df["order_date"].dt.to_period("M").rename("month")],
    columns="category",
    aggfunc={
        "amount": ["sum", "mean"],
        "quantity": "sum"
    },
    margins=True
).round(2)

print(report)

3. Real-World Example: Sales Dashboard Style Pivot

dashboard = pd.pivot_table(
    df,
    values="amount",
    index="region",
    columns=df["order_date"].dt.year.rename("year"),
    aggfunc=["sum", "mean", "count"],
    margins=True
).round(2)

# Flatten multi-level columns
dashboard.columns = [f"{agg}_{year}" for agg, year in dashboard.columns]
print(dashboard)

4. Best Practices in 2026

Use pivot_table() instead of manual groupby() + unstack() when you need a classic pivot layout
Specify aggfunc as a dictionary when using multiple aggregation functions
Include margins=True for quick grand totals
Combine with date components (year, month, quarter) extracted via .dt
Use fill_value=0 to replace NaNs with zeros for cleaner reports

Conclusion

Pivot tables in Pandas are incredibly powerful for reshaping and summarizing data. In 2026, mastering pd.pivot_table() allows you to create professional-looking cross-tabulations, dashboards, and management reports with just a few lines of code. It is often the fastest way to turn raw transactional data into actionable business insights.

Next steps: