题解 | #统计运动会项目报名人数#
统计运动会项目报名人数
https://www.nowcoder.com/practice/f992129b6da245d5bc5efb2f95289516
import pandas as pd df1 = pd.read_csv('items.csv') df2 = pd.read_csv('signup.csv') df = pd.merge(df1,df2,how='inner',on='item_id') a = df.groupby(['item_name']).count()['employee_id'] print(a)