How to select rows based on column value string checking?

Question

df.loc[df['name'] == 'Mary']

The above get rows if the 'name' is Mary. What about if I want rows that contains 'Mary', not exactly equal 'Mary'?

use `df.loc[df['name'].str.contains('Mary')]` – rhug123 Nov 05 '21 at 19:42 — rhug123, Nov 05 '21 at 19:42

score 1 · Accepted Answer · edited Nov 05 '21 at 20:02

1

You can use pd.Series.str.contains() method to achieve this.

df[df['name'].str.contains('Mary')]

edited Nov 05 '21 at 20:02

Tobias P. G.

answered Nov 05 '21 at 19:46

Is '|' is a special character that doesn't work with the contains function? I used df[df['name'].str.contains('|')] and it selected all rows. – marlon Nov 05 '21 at 19:58
1

try to escape the symbol by writing df[df['name'].str.contains('\|')] – Nov 05 '21 at 20:04

1 Answers1