Cacher is the code snippet organizer for pro developers

import pandas as pd
import numpy as np

df = pd.read_excel("../data/sales-funnel.xlsx")
table = pd.pivot_table(df,index=["Manager","Rep","Product"],
               values=["Price","Quantity"],
               aggfunc=[np.sum,np.mean],fill_value=0)

for manager in table.index.get_level_values(0).unique():
    print(table.xs(manager, level=0))
    
# writer = pd.ExcelWriter('../output/B-015 - output.xlsx')

for manager in table.index.get_level_values(0).unique():
    temp_df = table.xs(manager, level=0)
    temp_df.to_excel(writer,manager)
writer.save()