How to delete a certain row if it contains a particular string in it using python?

Question

I have to create a clean list wherein names with 'Trust' or 'Trustee' in rows get deleted.

I'm using the following code but i'm not getting the desired result ?

df_clean = df[~df['Row Labels'].str.contains('trusteeship')]

eg : if the 'Row Labels' contains a row with ABC Trust or XYTrusteeshipZ, then the whole row should get deleted.

Use df_clean = df[~df['Row Labels'].str.contains('Trust')] — jezrael
– jezrael, Commented Feb 22, 2021 at 7:48
@jezrael thanks but i have already tried it.. didn't help.. i'l add the screenshot for the same — techwreck
– techwreck, Commented Feb 22, 2021 at 7:55
df_clean = df[~df['Row Labels'].str.lower().str.contains('trust')] — anon01
– anon01, Commented Feb 22, 2021 at 7:57

jezrael · Accepted Answer · 2021-02-22 08:01:10Z

1

You can match with case=False parameter for ignore lower/uppercase characters:

df_clean = df[~df['Row Labels'].str.contains('trust', case=False)]

Or first convert values to lowercase like mentioned @anon01 in comments:

df_clean = df[~df['Row Labels'].str.lower().str.contains('trust')]

answered Feb 22, 2021 at 7:59

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

2 Comments

i tried this .. provided a snippet for the same as well

df_clean = df[~df['Row Labels'].str.contains('trust', case=False)] this worked.. thanks buddy @jezrael