题解 | 运动会各项目报名透视表
运动会各项目报名透视表
https://www.nowcoder.com/practice/dc8ea5c6572243d1a38c907d115cfb47
import pandas as pd
items = pd.read_csv('items.csv')
singup = pd.read_csv('signup.csv')
df = pd.merge(items,singup,on='item_id',how='left')
print(
pd.pivot_table(
df,
index=["sex", "department"],
columns=["item_name"],
values=["employee_id"],
aggfunc="count",
fill_value=0,
)
)
拼多多集团-PDD一面327人在聊
查看2道真题和解析
