题解 | #统计职能部分运动会某项目的报名信息#
统计职能部分运动会某项目的报名信息
https://www.nowcoder.com/practice/607359f8e09f4128bb90bb28a08d42ca
import pandas as pd
a=pd.read_csv('items.csv')
a1=pd.read_csv('signup.csv')
b=pd.merge(a,a1,how='inner',on='item_id')
b1=b[(b['department']=='functional') & (b['item_name']=='javelin')]
c=b1[['employee_id','name','sex']].reset_index(drop=True)
print(c)
