题解 | #多报名表的运动项目人数统计#
多报名表的运动项目人数统计
https://www.nowcoder.com/practice/423da9d9768243c89e3c724ba7e2ff4d
import sys
for line in sys.stdin:
a = line.split()
print(int(a[0]) + int(a[1]))
import pandas as pd
items = pd.read_csv('items.csv',sep = ',')
signup = pd.read_csv('signup.csv',sep = ',')
signup1 = 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)
df1 = pd.merge(signup,signup1, how = 'outer')
df2 = pd.merge(items,df1, how = 'inner', on = 'item_id')
df3 = df2.groupby(['item_name'])['employee_id'].count()
# df3 = df3[df3['employee_id'] != 0]
# print(df3.info())
print(df3)
