My pandas dataframe looks like [this](https://i.stack.imgur.com/Eq8zX.png) . For each row I want to replace values in Q2 to "positive" if the term "xxpos" occurs within the "SNIPPET" column and if the value in Q2 == 1. Also I want to replace values in Q2 to "negative" if the term "xxneg" occurs within the "SNIPPET" column and the value in Q2 == 1 etc.

I tried a few things, including the following but without success:
`df['Q2'] = np.where(("xxpos" in df["SNIPPET"]) & (df['Q2'] == 1) ,"Positive", df['Q2'])`

What would be the easiest solution to deal with the multiple conditions?