题解 | #多报名表的运动项目人数统计#
多报名表的运动项目人数统计
https://www.nowcoder.com/practice/423da9d9768243c89e3c724ba7e2ff4d
import pandas as pd
signup1=pd.read_csv('signup1.csv')
signup0=pd.read_csv('signup.csv')
item=pd.read_csv('items.csv')
signup=pd.concat([signup0,signup1],axis=0)
data=pd.merge(item,signup,how='left',on='item_id')
result=data.groupby('item_name')['employee_id'].agg('count')
print(result[result>0])
