To include subtotals in a Pandas Pivot Table that has multiple indices, you can use the margins
parameter and set it to True
. This will add subtotals for each index level and a grand total at the bottom.
For example:
import pandas as pd
# Create sample data
data = {'Region': ['North', 'North', 'South', 'South'],
'Month': ['Jan', 'Feb', 'Jan', 'Feb'],
'Sales': [100, 120, 80, 90]}
df = pd.DataFrame(data)
# Create pivot table with subtotals
pivot_table = pd.pivot_table(df, index=['Region', 'Month'], values='Sales', aggfunc=sum, margins=True)
print(pivot_table)
The output will be:
Sales
Region Month
North Feb 120
Jan 100
All 220
South Feb 90
Jan 80
All 170
All 390
As you can see, subtotals are added for each index level, and a grand total is included at the bottom. The All
row and column show the sum of sales for each level.
Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss
Asked: 2023-05-19 10:18:10 +0000
Seen: 9 times
Last updated: May 19 '23
What is the method for altering the color of the input text in a TextFormField in Flutter?
What is the procedure for utilizing the node-rdpjs library?
What is the method to change a PDF file to an Excel file using C#?
What is the method to make a TextButton inactive when the text field has no text?
What is the method to alter the background image in HTML?
What is the method for saving an entity with @EmbeddedId as its primary key in Hibernate?
What is the method to superimpose two seaborn density plots?