How do you filter and replace data in a given column in Pandas df?

Question

I have some temperature readings that are less than 0 that I want to replace with NaN

I tried this approach but it replaced other values like humidity also as NaN

Df[Df['Temp'] <0] = np.nan

I expect Temp values that are below 0 to be set as NaN without affecting corresponding humidity value

Question has nothing to do with `machine-learning` - kindly do not spam irrelevant tags (removed). — desertnaut, Aug 08 '19 at 14:06

score 0 · Accepted Answer · answered Aug 08 '19 at 07:49

0

df.loc[df['Temp']<0,'Temp']=np.nan

answered Aug 08 '19 at 07:49

tawab_shakeel

1 Answers1