count na in pandas code example

Example 1: count nan pandas

#Python, pandas
#Count missing values for each column of the dataframe df

df.isnull().sum()

Example 2: python count null values in dataframe

# Count total missing values in a dataframe

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

# Gives a integer value

Example 3: count na pandas

>>> df = pd.DataFrame({"Person":
...                    ["John", "Myla", "Lewis", "John", "Myla"],
...                    "Age": [24., np.nan, 21., 33, 26],
...                    "Single": [False, True, True, True, False]})
>>> df
   Person   Age  Single
0    John  24.0   False
1    Myla   NaN    True
2   Lewis  21.0    True
3    John  33.0    True
4    Myla  26.0   False

df.count()
Person    5
Age       4
Single    5
dtype: int64