how to replace a dataframe row with NaN if it doesn't contain a specific string

Question

I am working with the data frame shown in the link above. I want to make all rows that do not contain the words 'Yes' or 'No' be replaced with NaN.

please post the output of `dataframe_name.head()` as text, so we can cut and paste it to help — sacuL, Jul 26 '18 at 17:22

Ashish Acharya · Accepted Answer · 2018-07-26T17:24:49.007

0

df.Met = np.where(~df.Met.isin(['Yes', 'No']), np.nan, df.Met)

Try this.

edited Jul 26 '18 at 17:24

answered Jul 26 '18 at 17:22

Ashish Acharya

1 Answers1