题解 | 统计职能部分运动会某项目的报名信息

import pandas as pd
items = pd.read_csv('items.csv')
signup = pd.read_csv('signup.csv')

table = pd.merge(signup,items,on='item_id')
table2 = table[table['department'] == 'functional']
table3 = table2[table2['item_name'] == 'javelin'].reset_index(drop=True)

print(table3[['employee_id','name','sex']])