题解 | 多报名表的运动项目人数统计
多报名表的运动项目人数统计
https://www.nowcoder.com/practice/423da9d9768243c89e3c724ba7e2ff4d
import pandas as pd
df_items = pd.read_csv('items.csv')
df_signup = pd.read_csv('signup.csv')
df_signup1 = pd.read_csv('signup1.csv')
merged_signup = pd.concat([df_signup,df_signup1],ignore_index=True)
merged_df = pd.merge(df_items,merged_signup,on = 'item_id',how = 'left')
result = merged_df.groupby(['item_name'])['employee_id'].count()
print(result[result > 0])
#不考虑薪资和职业，你最想做什么工作呢？#
查看16道真题和解析
投递智联招聘等公司6个岗位
