Pandas: Number of rows with missing data

Question

How do I find out the total number of rows that have missing data in a Pandas DataFrame? I have tried this:

df.isnull().sum().sum()

But this is for the total missing fields. I need to know how many rows are affected.

Answer 1

You can use .any. This will return True if any element is True and False otherwise.

df = pd.DataFrame({'a': [0, np.nan, 1], 'b': [np.nan, np.nan, 'c']})
print(df)

outputs

     a    b
0  0.0  NaN
1  NaN  NaN
2  1.0    c

and

df.isnull().any(axis=1).sum()  # returns 2