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

import pandas as pd
items = pd.read_csv('items.csv')
signup = pd.read_csv('signup.csv')

merge1 = items.merge(signup, on='item_id')

# 行索引键为sex、department，列索引键为item_name。数值为报名对应项目的人数
pivot_ = pd.pivot_table(
    merge1,
    index = ["sex", "department"],
    columns = ["item_name"],
    values = ["employee_id"],
    aggfunc="count",
    fill_value=0
)

print(pivot_)