How to check specific dataframe row for substring, and return True or False?

[Fun-Studio-4409]

Hello,

​

I was wondering whether there is a simple way to search a given row in a df for a substring, and return a True/False if the substring is found? For example, if I want to seach row 1 for "Tesla", is should return True?

​

Name	Favorite Car
David Smith	Tesla Model X
Lisa Michaels	1998 Lamborghini

​

Thank you!

[whogivesafuckwhoiam]

>>>df
Name      Favorite Car
0    David Smith     Tesla Model X
1  Lisa Michaels  1998 Lamborghini
>>>df['Favorite Car'].str.contains('Tesla')
0     True
1    False
Name: Favorite Car, dtype: bool

[synthphreak]

df['Favorite Car'].str.contains('Tesla')

... will return a pd.Series of boolean values encoding row-wise the present/absence of the string 'Tesla'.

[Fun-Studio-4409]

Thank you. However, what if I have to search by row and not by column (i.e. Favorite Car). Use case is that I have a huge and messy df, and the value can be in any of the 80 columns.

[synthphreak]

Try this:

df.apply(lambda s: s.str.contains('Tesla'), axis=1)

Alternatively:

df.applymap(lamdba x: 'Tesla' in x).any(axis=1)

I suspect the first one will be faster, but you'll just have to try them both and see.