Replacement of strings in a column excluding some words in python

Asked Sep 08 '17 at 14:10

Active Sep 08 '17 at 14:37

Viewed 477 times

I have been trying to change the words in one of the columns of my data frame such that it will replace all the words except some keywords which I want to leave as it is. I tried doing this:

df['col]=df['col].where(lambda x: x == ('A'or'B'or'C'),'others')

My plan is to replace every word that isn't A or B or C with others. The code worked for A but B and C were replaced. How do I go about this please?

NB: I am trying to improve my python skill and have searched the entire stack-overflow before asking this question. Thank you for your help.

edited Sep 08 '17 at 14:33

ayhan

64,199
17
170
189

asked Sep 08 '17 at 14:10

RichAd

4

`x in ('A', 'B', 'C')` instead of `x == ('A'or'B'or'C')` – Cory Kramer Sep 08 '17 at 14:11
you havent found: https://stackoverflow.com/questions/15112125/how-do-i-test-one-variable-against-multiple-values – Jean-François Fabre Sep 08 '17 at 14:13
Hi Jean, thank you for your fast response. I tried your suggestion and got a 'ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all().' response. – RichAd Sep 08 '17 at 14:19
@RichAd Vectorized version of that is `df['col'].where(lambda x: x.isin(('A', 'B', 'C')), 'others')`. – ayhan Sep 08 '17 at 14:35
@ayhan It worked! Thank you so much. – RichAd Sep 08 '17 at 15:16

Replacement of strings in a column excluding some words in python

0 Answers0