两种不同形式的透视表
原表:
形式一:(推介)
orders = pd.read_excel('C:/Temp/Orders.xlsx', dtype={'Date': date})
orders['Year'] = pd.DatetimeIndex(orders.Date).year #搞出year这一列
groups = orders.groupby(['Category', 'Year'])
s = groups['Total'].sum()
c = groups['ID'].count()
pt1 = pd.DataFrame({'Sum': s, 'Count': c})
print(pt1)
形式二:
orders = pd.read_excel('C:/Temp/Orders.xlsx', dtype={'Date': date})
orders['Year'] = pd.DatetimeIndex(orders.Date).year #搞出year这一列
pt2 = orders.pivot_table(index='Category', columns='Year', values='Total', aggfunc=np.sum) #聚合函数aggfunc=np.sum
print(pt2)