1. 选出多列
# 方法1
df = pd.DataFrame(df,columns=['body','predict'])
# 方法2
df = df[['predict', 'body']]
# 方法3
df = df.loc[:, ['predict', 'body']]
# 方法4
df = df.iloc[:, [1,3]]
# 方法5
df = pd.read_excel(filename, header=0, usecols=['predict','body'])
t_month
t_month[['01', '04', '07', '10']] = 1
2, 通过AND,OR,NOT多个条件提取(选择)行的
or:
position = position1[(position1['asset_class'] == '股票') | (position1['asset_class'] == '融券')]
and
position = position1[(position1['asset_class'] == '股票') & (position1['asset_class'] == '融券')]
Not
position = position1[~(position1['asset_class'] == '股票')]