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

import pandas as pd
from numpy.core.defchararray import count
运动会项目=pd.read_csv('items.csv')
报名情况=pd.read_csv('signup.csv')
表=pd.merge(运动会项目,报名情况,on='item_id',how='left')
数据透视表=表.pivot_table(index=['sex','department']
                        ,values=['employee_id']     
                        ,columns='item_name'
                        ,aggfunc='count'
                        ,fill_value=0)

print(数据透视表)