panads 数据筛选 过滤
有这样一数据集:
筛选age 在18到30,score在85到100
import pandas as pd
students = pd.read_excel("C:/Users/Administrator/Desktop/Students.xlsx",index_col="ID")
students = students.loc[students.Age.apply(lambda a:18 <= a < 30)].loc[students.Score.apply(lambda s:85 <= s <= 100)]