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

import pandas as pd

items = pd.read_csv("items.csv")
signup = pd.read_csv("signup.csv")
data = pd.merge(items, signup, how="left", on="item_id")
# result=pd.crosstab([data['sex'],data['department']],data['item_name'])
# result=data.groupby(['sex','department','item_name'])['employee_id'].count().unstack()
# result=pd.pivot_table(data,index=['sex','department'],columns=['item_name'],values=['employee_id'],aggfunc='count',fill_value=0)
result = data.pivot_table(
    index=["sex", "department"],
    columns=["item_name"],
    values=["employee_id"],
    aggfunc="count",
    fill_value=0,
)
# values后面要加方括号，否则不显示
print(result)