substrings in python dataframe

Question

I have this following piece of code, which returns an error: "Keyerror: False".

train["Name"]["Ms." in train["Name"]]

Basically, the column "Name" contains a long string with a full name of an individual, including their title (Mr, Mrs, Ms, etc). I want to subselect only the rows which contain a certain title, in this example "Ms.", but I get that error.

Vaziri-Mahmoud · Accepted Answer · 2020-09-20 11:08:53Z

2

You can do:

df=pd.DataFrame([['Aaa','bBB'],['Xxx','yYY']],columns=['f','l'])
index=df['f'].str.contains('Aa', regex=False)
df['f'][index]

answered Sep 20, 2020 at 11:08

Vaziri-Mahmoud

1501 silver badge11 bronze badges

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

Collectives™ on Stack Overflow

substrings in python dataframe

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related