Search code examples
pythonpandasdataframerownan

Calculate Number of Rows containg NaN values

I Have a Data Frame df which is given below and I have to calculate the number of rows containing NaN values.

    Name  Age       City    Country
0   jack  NaN     Sydeny  Australia
1   Riti  NaN      Delhi      India
2  Vikas   31        NaN      India
3  Neelu   32  Bangalore      India
4  Steve   16   New York         US
5   John   11        NaN        NaN
6    NaN  NaN        NaN        NaN

To get the answer I tried 

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

And it gives me output 9 by calculating all NaN value, but the is answer is 5 by calculating Rows which contain NaN value. I do not know how to calculate this.

Solution

  • You need df.any() over axis=1 after you check isnull():

    df.isnull().any(axis=1).sum()
#5