题解 | #统计职能部分运动会某项目的报名信息#
统计职能部分运动会某项目的报名信息
https://www.nowcoder.com/practice/607359f8e09f4128bb90bb28a08d42ca
import sys import pandas as pd items = pd.read_csv('items.csv') signup = pd.read_csv('signup.csv') df = items.merge(signup, how = 'left', on = 'item_id') df = df.query("department == 'functional' & item_name == 'javelin'").reset_index(drop = True) print(df[['employee_id', 'name', 'sex']]) for line in sys.stdin: a = line.split() print(int(a[0]) + int(a[1]))