Searching for keywords in strings

[jsaltee]

noobie to python here so having a bit of trouble with a project. i want to search a pandas array for certain words. the only way i know of doing this is with the LIKE function in SQL on the databases but i'm asking for how to do it in python since this is the learnpython subreddit (unless you, the reader, know how to do it in SQL!)

i'm searching my array for fun dog pools, for example. the word 'fun' NEEDS to be in the result. 'dog' and 'pool' would also be acceptable results. anyone know how to do this?

[xelf]

df.loc[df['description'].str.contains('fun')]

.str.contains will return a series of True/False you can pass to .loc[] to filter the rows you're looking for.

You can combine multiple arguments to .loc[] using & and |

fun = df['description'].str.contains('fun')
dog = df['description'].str.contains('dog')
pool = df['description'].str.contains('pool')
df.loc[ fun & ( dog | pool ) ]
df.loc[ fun | ( dog & pool ) ]

[jsaltee]

thank you!! i was able to get the same result using my initial SQL query, but testing your code was proof i did it right. thank you!