题解 | #运动会各项目报名透视表#
运动会各项目报名透视表
https://www.nowcoder.com/practice/dc8ea5c6572243d1a38c907d115cfb47
# Tips: pandas数据透视表 https://blog.csdn.net/junhongzhang/article/details/125139188
import pandas as pd
items=pd.read_csv("./items.csv",sep=",") # 运动会项目
signup=pd.read_csv("./signup.csv",sep=",") # 员工报名情况
all_data=pd.merge(items,signup,on=["item_id"],how="inner")
res=pd.pivot_table(all_data,values=["employee_id"],index=["sex","department"],columns="item_name",aggfunc="count",fill_value=0)
print(res)
查看4道真题和解析
华为HUAWEI工作强度 1372人发布