题解 | #统计职能部分运动会某项目的报名信息#
统计职能部分运动会某项目的报名信息
https://www.nowcoder.com/practice/607359f8e09f4128bb90bb28a08d42ca
import pandas as pd items = pd.read_csv("items.csv") signup = pd.read_csv("signup.csv") data = pd.merge(signup, items, how="left", on="item_id") result = data[(data["department"] == "functional") & (data["item_name"] == "javelin")][ ["employee_id", "name", "sex"] ] # 题目错了,javelin多了一个n,导致一开始复制出错 print(result.reset_index(drop=True))