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