pandas loc search by part of a string not using regexp [duplicate]

Question

import pandas as pd


data = {'name': ['HelloWorld', 'ByeWorld'],
        'physics': [22, 33],
        'chemistry': [44, 55]}

a = pd.DataFrame(data)

b = a.loc[a['name'] == 'Hello']

print(b)

This code would not return any rows, but I would like to achieve it would return the first row, because it includes "Hello". Is there any elegant solution to solve this with the loc command?

Kenan · Accepted Answer · 2021-02-23 21:30:23Z

1

You want

b = a.loc[a['name'].str.contains('Hello')]

also if your only looking at the start of a string you can use

b = a.loc[a['name'].str.startswith('Hello')]

Not

b = a.loc[a['name'] == 'Hello']

this line of code will only return True for a row containing ONLY Hello

edited Feb 23, 2021 at 21:30

answered Feb 23, 2021 at 21:17

Kenan

14.2k9 gold badges47 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

pandas loc search by part of a string not using regexp [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related