make str.contains more explicit

Question

I'm looking for a cell in a data frame that contains the word "Scan". Unfortunately, there is also a word "Scan-Steuerung" which I would like to ignore. How can I do this in python?

Is it also possible to get the index of this cell?

I'm looking for a cell in a data frame that contains the word "Scan". Unfortunately, there is also a word "Scan-Steuerung" which I would like to ignore. How can I do this in python?

Is it also possible to get the index of this cell?

edit: I think it would be sufficient when I can read these two lines separately. At the moment, I use:

line = df[df["Name:"].str.contains("Scan")]

and when I print, I receive both lines at once.

So you need `line = df.index[df["Name:"].str.contains(r"\bScan\b")]` ? — jezrael, Jun 14 '19 at 07:02

score 1 · Accepted Answer · answered Jun 14 '19 at 06:46

1

Use Regex pattern boundaries \b

Ex:

df["Col"].str.contains(r"\bScan\b")

answered Jun 14 '19 at 06:46

Rakesh

81,458
17
76
113

Thank you! What is the return of that command? – Ben Jun 14 '19 at 06:50

make str.contains more explicit

1 Answers1

Linked