count nan vs empty cells 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: pandas replace empty string with nan

df = df.replace(r'^\s*$', np.NaN, regex=True)