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