Pandas_筛选

import pandas as pd

students = pd.read_excel("../008/Students.xlsx")
students = students.loc[students.Age.apply(lambda a:18<=a<=30)].loc[students.Score.apply(lambda b :b>=85)]
print(students)

import pandas as pd

students = pd.read_excel("../008/Students.xlsx")
print(students.dtypes)

# 方法1:
def age_18_to_30(a):
#     return 18<=a<=30
    return 18<=a and a<=30

students = students.loc[students["Age"].apply(age_18_to_30)]

# 方法2:
students = students.loc[students.Age.apply(lambda a: 18<=a<=30)]

print(students)

# 方法1：
def score_85(b):
    return b>=85

students = students.loc[students.Score.apply(score_85)]

# 方法2：
students = students.loc[students.Score.apply(lambda b:b>=85)]
print(students)