Python Pandas: Conditionally delete rows

Question

Hi, I want to delete rows whose values in columns col1 and col2 are both 0.

Right now, I have:

df = df[df['col1'] != 0 and df['col2'] != 0]

But I get an error message: TypeError: cannot compare a dtyped [float64] array with a scalar of type [bool]

can anyone please explain how to implement this plz?

jezrael · Accepted Answer · 2017-07-17 18:57:12Z

3

You need bitwise & and add brackets for priority operators:

df = df[(df['col1'] != 0) & (df['col2'] != 0)]

Or:

df = df.query("'col1' != 0 & 'col2' != 0")

answered Jul 17, 2017 at 18:57

jezrael

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

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

1 Comment

@JunJang - Glad can help!