Display only the Specific Rows containing multiple words (with Logical operator-AND) in Python

Question

I have a dataset(Dataframe) with multiple sentences/words in a Row. I want to extract those row data which consists of the given Specific Keyword. The Dataset is Stated below

My query is to Extract those rows which contain Multiple input words(Multiple Strings) that are entered by the user.

PFB, example for a Single String

I used the below code for Multiple Strings with LOGICAL "OR" operator using '|'.

My Main Query is to Find the words with "AND" Operator. I want to search for rows containing ["Product", "Jumbo", "Peanut"] and only the 6th row satisfies it, So is there any logic like the above to show the rows containing the search inputs.

Thanks for your time!

Possible duplicate of [pandas dataframe str.contains() AND operation](https://stackoverflow.com/questions/37011734/pandas-dataframe-str-contains-and-operation) — Alexandre B., Jan 23 '20 at 09:18

score 2 · Accepted Answer · answered Jan 23 '20 at 09:19

2

Try using this regex expression:

print(df[df['Text'].str.contains(r'(?=.*Product)(?=.*Jumbo)(?=.*Peanut)')])

answered Jan 23 '20 at 09:19

U13-Forward

69,221
14
89
114

Display only the Specific Rows containing multiple words (with Logical operator-AND) in Python

1 Answers1