How to identify the string where it contains multiple words

Question

Data frame column text with datatype string contains sentences, I am looking to extract the rows which contains certain words irrespective of place in which they occur.

For ex:

Column
Cat and mouse are the born enemies
Cat is a furry pet


df = df[df['cleantext'].str.contains('cat' & 'mouse')].reset_index()
df.shape

The above is throwing an error.

I know that for or condition we can write -

df = df[df['cleantext'].str.contains('cat | mouse')].reset_index()

But I want to extract the rows where both cat and mouse are present

Expected Output -

Column
Cat and mouse are the born enemies

If regex, you'd use `(?=.*cat)(?=.*mouse)` – May 06 '19 at 15:44 — , May 06 '19 at 15:44
Thank you, will try this way too. – Dr.Chuck May 06 '19 at 15:57 — Dr.Chuck, May 06 '19 at 15:57

score 0 · Accepted Answer · answered May 06 '19 at 15:46

0

Here's one approach, which also works for multiple words:

words = ['cat', 'mouse']
m = pd.concat([df.Column.str.lower().str.contains(w) for w in words], axis=1).all(1)
df.loc[m,:]

      Column
0  Cat and mouse are the born enemies

answered May 06 '19 at 15:46

yatu

86,083
12
84
139

Thank you, this is what I needed, it works. – Dr.Chuck May 06 '19 at 15:58
Thank you for the information :) – Dr.Chuck May 06 '19 at 17:08

How to identify the string where it contains multiple words

1 Answers1