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