import pandas as pd
import os
os.chdir('路径')
#条件筛选方案一
def age_18_to_30(a):
return 18 <= a < 30
def level_a(s):
return 85 <= s <= 100
p8 = pd.read_excel('P8.xlsx',index_col='ID')
p8 = p8.loc[p8.Age.apply(age_18_to_30)].loc[p8.Score.apply(level_a)]
print(p8)
#条件筛选方案二
p8 = p8.loc[p8.Age.apply(lambda a: 18 <= a < 30)].loc[p8.Score.apply(lambda s:85 <= s <= 100)]
print(p8)
pandas 条件筛选
最新推荐文章于 2021-12-25 12:00:00 发布