题解 | #多报名表的运动项目人数统计#

import pandas as pd
import datetime as dt

item = pd.read_csv("items.csv", sep=",")
sign = pd.read_csv("signup.csv", sep=",")
sign1 = pd.read_csv("signup1.csv", sep=",")


pd.set_option("display.width", 300)  # 设置字符显示宽度
pd.set_option("display.max_rows", None)  # 设置显示最大行
pd.set_option("display.max_columns", None)


sign_total=pd.concat([sign,sign1],axis=0,ignore_index=True)

itemcnt = sign_total.groupby("item_id").employee_id.count()
total = pd.merge(item, itemcnt, how="inner", on="item_id")
total.rename({"employee_id":"count"}, axis=1, inplace=True)
total.set_index('item_name',inplace=True)
print(total[total['count']>0]['count'])