pandas dataframe进行数据筛选

content = '出货时间'
data = getOracleData(sql.format(content))

name = data[data['VALUE']==content]
print(name['NAME'].values[0])
print(type(name))

e = time.time()

单条件筛选

due_days=10
last_loan_df=last_loan_df[last_loan_df['max_due_days']<=due_days]

多条件筛选

或

last_loan_df=last_loan_df[(last_loan_df['max_due_days']<=due_days )|(last_loan_df['score']>100) ]

且

last_loan_df=last_loan_df[(last_loan_df['max_due_days']<=due_days )&(last_loan_df['score']>100) ]

参考
https://www.cnblogs.com/wqbin/p/12967326.html