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

import pandas as pd
items = pd.read_csv('items.csv')
signup = pd.read_csv('signup.csv')
# 两表合并
merge1 = items.merge(signup, how='inner', on='item_id')
# 筛选数据，题目里标枪英文javenlin多写了一个n（正确为javelin）
merge2 = merge1[(merge1['department'] == 'functional') & (merge1['item_name'] == 'javelin')].loc[:,['employee_id', 'name', 'sex']]
print(merge2.reset_index(drop=True)) # 重置行索引，并删除多余行索引