find missing values in all columns dataframe python code example

Example 1: count missing values by column in pandas

df.isna().sum()

Example 2: number of columns with no missing values

df = df[df.columns[~df.isnull().all()]]