I have a data set called df with the information of the name of the Drugs that has been administered. The column "drug_name" consists of all the various drug names. I would like to extract entries that only contain a specific name of the drugs.

I have tried the .str.contain method

df_adr= df[df["drug_name"].str.contains("epinephrine")==True]

This works but the problem is it returns entries that has the drug name "Norepinephrine" too because the word contains my key word "epinephrine". How do I get extract the entries that is an exact string match and not contain the string?

CodePudding user response：

You may want to use a regular expression with word boundaries '\b'.

df.loc[df["drug_name"].str.contains(r"\bepinephrine\b", case=False)]