Delete row if found specific string Python

Question

df:

Column1  Column2
1        Balneolaeota;
2        Caldiserica;
3        Calditrichaeota;
4        Candidatus Abawacabacteria;
5        candidatus Adlerbacteria;

I want to delete all rows that contain the string "Candidatus" and "candidatus" in the second column.

Any advice?

rrcal · Accepted Answer · 2020-02-02 19:43:59Z

3

You can use str.contains:

df = df[~df['Column2'].str.contains('candidatus', case=False)]

Out[1]: 
   Column1          Column2
0        1     Balneolaeota
1        2      Caldiserica
2        3  Calditrichaeota

answered Feb 2, 2020 at 19:43

rrcal

3,7906 gold badges27 silver badges35 bronze badges

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

1 Comment

Georgina Skibinski Over a year ago

df = df.loc[~df['Column2'].str.contains('candidatus', case=False)] ;)

Collectives™ on Stack Overflow

Delete row if found specific string Python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related