题解 | #运动会各项目报名透视表#
运动会各项目报名透视表
https://www.nowcoder.com/practice/dc8ea5c6572243d1a38c907d115cfb47
import pandas as pd
items = pd.read_csv('items.csv', sep = ',')
signup = pd.read_csv('signup.csv', sep = ',')
df = pd.merge(signup, items, how="left", left_on=signup["item_id"], right_on = items["item_id"])
result = pd.pivot_table(df,index=["sex","department"],columns=["item_name"],
values = ["employee_id"], aggfunc="count"
)
print(result)
