题解 | 运动会各项目报名透视表

import pandas as pd
items = pd.read_csv('items.csv')
signup = pd.read_csv('signup.csv')
data = pd.merge(signup, items, on='item_id', how='inner')
# 方法一：运用crosstab绘制交叉表
# tab = pd.crosstab([data['sex'], data['department']],data['item_name'])
# print(tab)
# 方法二：运用pivot_table()绘制透视表
tab = pd.pivot_table(data, index=['sex' ,'department'], columns=['item_name'], values=['employee_id'], aggfunc='count', fill_value=0)
print(tab)