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

import pandas as pd  

#1-导入数据
items = pd.read_csv('items.csv')
signup = pd.read_csv('signup.csv')

#2-左连接
data = pd.merge(signup, items, on = 'item_id', how = 'left')

#3-筛选出“职能部门”数据
data = data[data['department'] == 'functional']
#4-筛选出报名“标枪”的数据
data = data[data['item_name'] == 'javelin']
print(data[['employee_id', 'name', 'sex']])