题解 | #多报名表的运动项目人数统计#
多报名表的运动项目人数统计
https://www.nowcoder.com/practice/423da9d9768243c89e3c724ba7e2ff4d
import pandas as pd
df1 = pd.read_csv('items.csv')
df2 = pd.read_csv('signup.csv')
df3 = pd.read_csv('signup1.csv')
df23 = pd.concat([df2,df3]) # df23 = df2.append(df3)
df = pd.merge(df1,df23,on='item_id')
a = df.groupby(['item_name']).count()['employee_id']
print(a)
查看20道真题和解析