题解 | 统计职能部分运动会某项目的报名信息
统计职能部分运动会某项目的报名信息
https://www.nowcoder.com/practice/607359f8e09f4128bb90bb28a08d42ca
from pickle import TRUE
import pandas as pd
items = pd.read_csv('items.csv',sep=',')
singup = pd.read_csv('signup.csv',sep=',')
df = pd.merge(items,singup,on='item_id',how='left')
sub_df = df[(df['department'] == 'functional') & (df['item_name'] == 'javelin')]
print(sub_df[['employee_id','name','sex']].reset_index(drop=True))
