方法一:
import pandas as pd
pd.options.display.max_columns = 999
orders = pd.read_excel('Orders.xlsx')
orders['Year'] = pd.DatetimeIndex(orders['Date']).year
pt1 = orders.pivot_table(index = 'Category',columns='Year',values= 'Total',aggfunc = np.sum)
方法二:
import pandas as pd
pd.options.display.max_columns = 999
orders = pd.read_excel('Orders.xlsx')
orders['Year'] = pd.DatetimeIndex(orders['Date']).year
groups = orders.groupby(['Category','Year'])
s= groups['Total'].sum()
c= groups['ID'].count()
课时23