题解 | #统计职能部分运动会某项目的报名信息#
统计职能部分运动会某项目的报名信息
https://www.nowcoder.com/practice/607359f8e09f4128bb90bb28a08d42ca
import pandas as pd
signup = pd.read_csv('signup.csv')
items = pd.read_csv('items.csv')
#先将两个表连接在一起
df=items.set_index('item_id').join(signup.set_index('item_id'),on='item_id',how='left')
a=df[df['department']=='functional']
b=a[a['item_name']=='javelin']
c=b[['employee_id','name','sex']]
c=c.reset_index(drop=True)
print(c)
signup = pd.read_csv('signup.csv')
items = pd.read_csv('items.csv')
#先将两个表连接在一起
df=items.set_index('item_id').join(signup.set_index('item_id'),on='item_id',how='left')
a=df[df['department']=='functional']
b=a[a['item_name']=='javelin']
c=b[['employee_id','name','sex']]
c=c.reset_index(drop=True)
print(c)
