题解 | #统计运动会项目报名人数(二)#
统计运动会项目报名人数(二)
https://www.nowcoder.com/practice/737d224c9cce482fb56ff812d04e79ab
import pandas as pd items = pd.read_csv('items.csv') signup = pd.read_csv('signup.csv') # 进行两表连接 merge1 = items.merge(signup, how='inner',on='item_id') # 先进行分组,再进行统计 print(merge1.groupby('item_name')['item_name'].count())