Pandas delete a row in a dataframe based on a value

Question

I want do delete rows in a pandas dataframe where a the second column = 0

So this ...

  Code  Int
0    A    0
1    A    1
2    B    1

Would turn into this ...

  Code  Int
0    A    1
1    B    1

Any help greatly appreciated!

Hsgao · Accepted Answer · 2018-11-07 01:50:42Z

11

Find the row you want to delete, and use drop.

delete_row = df[df["Int"]==0].index
df = df.drop(delete_row)
print(df)
Code    Int
1   A   1
2   B   1

Further more. you can use iloc to find the row, if you know the position of the column

delete_row = df[df.iloc[:,1]==0].index
df = df.drop(delete_row)

edited Nov 7, 2018 at 1:50

answered Nov 7, 2018 at 1:35

Hsgao

5635 silver badges18 bronze badges

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

Comments

anthidp · Accepted Answer · 2020-05-01 19:57:20Z

1

You could use loc and drop in one line of code.

df = df.drop(df["Int"].loc[df["Int"]==0].index)

answered May 1, 2020 at 19:57

anthidp

241 silver badge3 bronze badges

1 Comment

Rafal Zajac Over a year ago

Welcome to Stack Overflow! Your answer is technically correct but the original answer is just a bit more succinct. Nevertheless, I hope you'll keep contributing here! :-)

Tyler Houssian · Accepted Answer · 2020-05-13 22:33:43Z

1

You could use this as well!

df = df[df.Int != 0]

answered May 13, 2020 at 22:33

Tyler Houssian

4656 silver badges8 bronze badges

Collectives™ on Stack Overflow

Pandas delete a row in a dataframe based on a value

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related