How to search words (in a list) in pandas data frame' column?

Question

I have a list of words like this: list1 = ["I","have","a","headache"]

and a pandas data frame like this:

I want to search word by word in the "list1" with the words in "keyWord" column and get the "id".

I would appreciate help and/or any pointers

I want to search the words in the list with the data frame. not to search the data frame with the list.

output must be like:

keyword id

headache 1

What's your expected output ? – rafaelc Nov 03 '18 at 23:54 — rafaelc, Nov 03 '18 at 23:54

score 1 · Answer 1 · answered Nov 03 '18 at 22:59

df[df['keyWord'].isin(list1)]
    keyWord  id
0  headache   1

df.set_index('keyWord').reindex(list1).dropna()
           id
keyWord      
headache  1.0

Note that python and pandas are case sensitive, so headache is different from Headache.

1 Answers1