python - Excluding columns from a dataframe based on their mean without using a loop

Question

I have a pandas dataframe df and I would like to drop columns which have a mean greater than 10 and less than 2. How can I do it without a loop?

I tried this without a loop

df=df.drop(df.mean(axis=1)>10 and df.mean(axis=1)<2)

Answer 1

You can't use drop, but you can index... You also need to use & rather than and:

m = df.mean(axis=1)  # calculate once
df = df.loc[:, (m>10) & (m<2)]