2021-03-11 python保留和删除

#删除指定条件的行 
df = df.drop(df[(df['4'] < 100) | (df['4'] > 200)].index)
df = df.drop(index = (df[(df['4'] < 100) | (df['4'] > 200)].index))

#保留符合条件的行
df=df[(df['4'] < 100) | (df['4'] > 200)]
df = df.loc[df['CDLKICKINGBYLENGTH_count'] >0]

#删除指定的列
df = df.drop(['有无水流','热水器编号','节能模式'],axis=1)

#保留指定的列
df = df[['有误flag','热度']]