Pandas Mask on multiple Conditions

Question

In my dataframe I want to substitute every value below 1 and higher than 5 with nan.

This code works

persDf = persDf.mask(persDf < 1000)

and I get every value as an nan but this one does not:

persDf = persDf.mask((persDf < 1) and (persDf > 5))

and I have no idea why this is so. I have checked the man page and different solutions on apparentely similar problems but could not find a solution. Does anyone have have an idea that could help me on this?

Answer 1

Use the | operator, because a value cant be < 1 AND > 5:

persDf = persDf.mask((persDf < 1) | (persDf > 5))

Another method would be to use np.where and call that inside pd.DataFrame:

pd.DataFrame(data=np.where((df < 1) | (df > 5), np.NaN, df), 
             columns=df.columns)