How to match string from another column

Question

I have to check title column contains color value from color column.

dataframe1['title'].str.contains(dataframe1['color'])

I am getting an error as

TypeError: 'Series' objects are mutable, thus they cannot be hashed

try `dataframe1.apply(lambda x: x['title'].str.contains(x['color'])` — Rakesh, May 21 '18 at 06:33
@Rakesh Please don't propose solutions that use apply here. There are better alternatives. — cs95, May 21 '18 at 06:45
@coldspeed. Sorry I did not know. Still in the beginning stages of Pandas and numpy — Rakesh, May 21 '18 at 06:53

score 1 · Accepted Answer · answered May 21 '18 at 06:37

1

Try using apply with lambda.

Ex:

dataframe1.apply(lambda x: x['title'].str.contains(x['color'])

answered May 21 '18 at 06:37

Rakesh

1

`dataframe1.apply(lambda x: " ".join([dataframe1['brand'], dataframe1['title']]) if not x['title'].str.contains(x['brand']))` ? – Rakesh May 21 '18 at 06:45

1 Answers1