Check if pandas column contains all zeros

Question

I'm doing a complex calculation on a data frame that is bound to throw exceptions if all the values in a column are zeros. How to do a quick check whether a column is full of zero? i.e. return True if the column has values other than 0 else False.

score 46 · Accepted Answer · edited Nov 29 '19 at 09:02

46

you can do something like this:

(df['col'] == 0).all()

This will return True if all values are 0 otherwise it will return false

edited Nov 29 '19 at 09:02

EMKAY

355
5
14

answered Feb 01 '18 at 20:09

PraveenB

1,270
10
11

1

Since you asked for the reverse you can use any() (df[col] != 0).any() – PraveenB Feb 01 '18 at 20:13
Perfect! thank you. – DevEx Feb 01 '18 at 20:23
How to retrieve other columns value /id in case it satisfy `df[col]=0.any()` – user1586957 Aug 04 '20 at 01:19
Sorry could not understand your question. Could you please elaborate ? – PraveenB Aug 04 '20 at 07:32

Check if pandas column contains all zeros

1 Answers1