题解 | #按照毕业年份与使用语言筛选牛客网7级用户#

使用pandas库进行筛选，一共有3中方式

1. 'data.query'
2. 'data.loc'
3. 'data[()&()&()]'

import pandas as pd

Nowcoder = pd.read_csv("Nowcoder.csv", sep=",")

pd.set_option("display.width", 300)
pd.set_option("display.max_rows", None)
pd.set_option("display.max_columns", None)

cond1 = Nowcoder["Language"] == "CPP"
cond2 = Nowcoder["Level"] == 7
cond3 = Nowcoder["Graduate_year"] != 2018
cond = cond1 & cond2 & cond3
# print(Nowcoder[cond])

print(Nowcoder.query("Language == 'CPP' & Level == 7 & Graduate_year != 2018"))

# print(
#     Nowcoder[
#         (Nowcoder["Language"] == "CPP")
#         & (Nowcoder["Level"] == 7)
#         & (Nowcoder["Graduate_year"] != 2018)
#     ]
# )

# print(
#     Nowcoder.loc[
#         (Nowcoder["Language"] == "CPP")
#         & (Nowcoder["Level"] == 7)
#         & (Nowcoder["Graduate_year"] != 2018)
#     ]
# )