Delete pandas dataframe row based on multiple condition

Question

I have the following df :

ABF2
ABG2
ABH2
ABJ3
ABK4
ABM5
ABN6
ABQ7

My goal is to have the following data frame :

ABH2
ABM5
ABQ7

So basically the condition would be multiple :

if third char = H, M, Q or Z

To get the third char value I do as below :

DF.Col_Name[2::2]

Fact is that I don't really know how to apply multiple condition to retrieve the wanted DF. Also, what would be the quickest way to do this ?

jezrael · Accepted Answer · 2022-08-12 08:05:27Z

1

Select third character with str and test values in Series.isin for test by membership, filter by boolean indexing:

df = DF[DF.Col_Name.str[2].isin(['H','M','Q','Z'])]

answered Aug 12, 2022 at 7:59

jezrael

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

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

Comments

sophocles · Accepted Answer · 2022-08-12 07:59:54Z

1

You can use:

df.loc[df.col.str[2].str.contains('H|M|Q|Z')]

prints:

    col
2  ABH2
5  ABM5
7  ABQ7

answered Aug 12, 2022 at 7:59

sophocles

13.9k3 gold badges18 silver badges37 bronze badges

Ynjxsjmh · Accepted Answer · 2022-08-12 08:05:08Z

1

You can try .str accessor

out = df[df['col'].str[2].isin(['H', 'M', 'Q', 'Z'])]

print(out)

    col
2  ABH2
5  ABM5
7  ABQ7

answered Aug 12, 2022 at 7:59

Ynjxsjmh

30.3k7 gold badges43 silver badges64 bronze badges