题解 | #统计职能部分运动会某项目的报名信息#
统计职能部分运动会某项目的报名信息
https://www.nowcoder.com/practice/607359f8e09f4128bb90bb28a08d42ca
import pandas as pd
items = pd.read_csv('items.csv', sep = ',')
signup = pd.read_csv('signup.csv', sep = ',')
item_name = items[items['item_name'] == 'javelin']
department = signup[signup['department'] == 'functional']
result = pd.merge(department, item_name, on = "item_id")
result1 = result[["employee_id","name","sex"]]
print(result1)
思路：
读取文件 -> 根据题目需求过滤文件 -> 合并为一个数据集 -> 过滤所需的列 - > 输出结果
百度HR面16人在聊
投递滴滴等公司10个岗位