check if one string contains another substring in python

Question

I have a data set which looks something like this.

**name**       **url**               **title**
Microsoft  asdfgaethgaetgh   Microsoft Is a big company
Apple      aeiurghp          iphone is a Apple product
Google     iailsu            Yahoo, Bing Profit Rises

I would like to use a flag where 'True' would be if the cell value of 'name' is present in the cell value of 'title'. Otherwise, 'False'

I am using something like this

df['flag'] = (df.name).isin(df.title)

But this gives all the flags as 'False', whereaas the first two flags should be 'True'

How can i take care of this?

What is isin? Just use the in operator: 'Microsoft' in 'Microsoft is a big company' — poke
– poke, Commented Mar 22, 2016 at 7:27

Kaustav Datta · Accepted Answer · 2016-03-22 07:41:24Z

3

This can also be used :

criteria = lambda row : row['name'] in row['title']
df['flag'] = df.apply(criteria, axis =1)

answered Mar 22, 2016 at 7:41

Kaustav Datta

4032 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Shahzeb Qureshi · Accepted Answer · 2016-03-22 07:37:55Z

0

You can use df['flag'] = True if df.name in df.title else False The code uses single line if else condition

answered Mar 22, 2016 at 7:37

Shahzeb Qureshi

6226 silver badges12 bronze badges

3 Comments

TigerhawkT3 Over a year ago

As denis's answer shows, there's no need to specify values (True and False in this case) for something that already resolves to those values.

Shahzeb Qureshi Over a year ago

I thought this was more representative :)

TigerhawkT3 Over a year ago

It's as representative as print('alice' if usr_name=='alice' else 'bob' if usr_name=='bob' else 'charlie' if usr_name=='charlie' else...). In other words, no.

Adnan Umer · Accepted Answer · 2016-03-22 07:38:26Z

0

isin will work only if you want to search name within list of names. To search for substring use str.contains instead

df.title.str.contains(df.name)

answered Mar 22, 2016 at 7:38

Adnan Umer

3,6892 gold badges20 silver badges38 bronze badges

Comments

alican akyol · Accepted Answer · 2016-03-22 07:38:52Z

0

Sample like this;

if df[name] in df[title]:
                        return true

answered Mar 22, 2016 at 7:38

alican akyol

2883 silver badges14 bronze badges

Comments

Denis · Accepted Answer · 2016-03-22 07:39:06Z

0

Your code should be like this

df['flag'] = (df.name in df.title)

answered Mar 22, 2016 at 7:39

Denis

1,2271 gold badge10 silver badges15 bronze badges

Collectives™ on Stack Overflow

check if one string contains another substring in python

5 Answers 5

Comments

3 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

3 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related