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