midPandas
What is pivot_table in Pandas?
Updated May 17, 2026
Short answer
pivot_table aggregates data across rows and columns.
Deep explanation
It creates a spreadsheet-like summary table using aggregation functions like sum, mean, etc., similar to Excel pivot tables.
Real-world example
Sales analysis by region and year.
Common mistakes
- Confusing pivot_table with pivot (which doesn't aggregate).
Follow-up questions
- What is aggfunc?
- Can pivot_table handle duplicates?