count number of zeros in a column pandas 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: df count zeros
df.astype(bool).sum(axis=0)