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

import sys

for line in sys.stdin:
    a = line.split()
    print(int(a[0]) + int(a[1]))


import pandas as pd

df_item = pd.read_csv("items.csv", sep=",")
df_sign = pd.read_csv("signup.csv", sep=",")
df = pd.merge(df_item, df_sign, how="inner", left_on=["item_id"], right_on=["item_id"])
df = df.query("department=='functional'").query("item_name=='javelin'")#query()的作用是进行选择性输出，只保留符合条件的列值
df2 = df[["employee_id", "name", "sex"]]
df2.reset_index(inplace=True, drop=True)#重置筛选之后的列的索引
print(df2)

1）弄清楚题目的要求，这个要求怎么实现，先将两个表合并，之后筛选符合条件的列进行输出