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

import pandas as pd
import datetime as dt

item = pd.read_csv("items.csv", sep=",")
sign = pd.read_csv("signup.csv", sep=",")

pd.set_option("display.width", 300)  # 设置字符显示宽度
pd.set_option("display.max_rows", None)  # 设置显示最大行
pd.set_option("display.max_columns", None)

item.set_index('item_name',inplace=True)

print(sign[(sign.department=='functional')&(sign.item_id==item.loc['javelin','item_id'])].iloc[:,0:3])