Pandas Pivot Table: Create a Pivot table and find the total sale amount region wise, manager wise

Pandas: Pivot Table Exercise-2 with Solution

Write a Pandas program to create a Pivot table and find the total sale amount region wise, manager wise. Go to Excel data

Sample Solution:

Python Code :

import pandas as pd
import numpy as np
df = pd.read_excel('E:\SaleData.xlsx')
print(pd.pivot_table(df,index = ["Region","Manager"], values = ["Sale_amt"],aggfunc=np.sum))

Sample Output:

                 Sale_amt
Region  Manager          
Central Douglas  124016.0
        Hermann  365108.5
        Martha   199690.0
        Timothy  140955.0
East    Douglas   48204.0
        Martha   272803.0
West    Douglas   66836.0
        Timothy   88063.0                                     

Pivot Table:

Salesdata.xlsx:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a Pandas program to create a Pivot table with multiple indexes from a given excel sheet (Salesdata.xlsx).
Next: Write a Pandas program to create a Pivot table and find the total sale amount region wise, manager wise, sales man wise.