JosephZYU
11/8/2019 - 4:14 PM

drill

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)

table.xs('Debra Henley', level=0)
table.xs(('Debra Henley','Craig Booker'), level=0)