题解 | #牛客的资深员工#

import pandas as pd

# # 字典，数据分析
# Nowcoder = {
#     'ID':[4701936033,7294120824,7204609405,2212484340,7992664026],
#     'working_years':[10,2,1,0,3],
#     'level':[15,4,4,2,3],
#     'language':['C','C','C','Java','Python'],
#     'salary':[80000,28000,24000,23000,23000]
# }

# df = pd.DataFrame(Nowcoder)
# result= df[(df['working_years'] >= 8) & (df['language']=='C')]
# print(result)

# 通过读取csv文件，将文件内容转换成字典型数据
dtype = {
    'ID':str,
    'working_years':int,
    'level':int,
    'language':str,
    'salary':int
}
Nowcoder = pd.read_csv('Nowcoder.csv',sep=',',dtype=dtype)
# 对获取到的字典数据，进行解析，提取需要的内容
result = Nowcoder[(Nowcoder['working_years'] >= 8) & (Nowcoder['language']=='C')]
print(result)