题解 | #统计职能部分运动会某项目的报名信息#
统计职能部分运动会某项目的报名信息
https://www.nowcoder.com/practice/607359f8e09f4128bb90bb28a08d42ca
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)) # 重置行索引,并删除多余行索引