题解 | #统计运动会项目报名人数(二)#

import pandas as pd

items = pd.read_csv("items.csv")
signup = pd.read_csv("signup.csv")

df = pd.merge(items, signup, how="inner", on="item_id")
print(df.groupby("item_name")["employee_id"].count())