pandas count zeros in column code example

Example 1: python count the number of zeros in each row of a pandas dataframe

# Basic syntax:
(pandas_dataframe == 0).sum(axis=1)
# Where axis 1 specifies that sum will operate on rows. Use 0 for columns

# Example usage:
# Create Pandas dataframe:
import pandas as pd
pandas_dataframe = pd.DataFrame({'a':[1,0,0,1,3], 
                                 'b':[0,0,1,0,1], 
                                 'c':[0,0,0,0,0]})
	a	b	c
0	1	0	0
1	0	0	0
2	0	1	0
3	1	0	0
4	3	1	0

(pandas_dataframe == 0).sum(axis=1)
0    2
1    3
2    2
3    2
4    1

Example 2: python count number of zeros in a column

(myDataFrame[column_name] == 0).sum()

Example 3: df count zeros

df.astype(bool).sum(axis=0)

Example 4: get number of zero is a row pandas

(pandas_dataframe == 0).sum(axis=1)