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!

user_7701866 · Answer

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)

user_8662198 · Answer

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

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

user_13537359 · Answer

You could use this as well!

df = df[df.Int != 0]