Check df nulls

check_nulls.py

def check_nulls(df):
    df_cols = df.columns
    col_counts = [df[col].count() for col in df_cols]
    col_lens = [len(df[col]) for col in df_cols]
    cdf = pd.DataFrame(index = df_cols,
                       data = {'Values':col_counts, 
                               'Total': col_lens})
    cdf['% N/A'] = 1-(cdf['Values']/cdf.Total)
    cdf['% N/A'] = cdf['% N/A'].map('{:.1%}'.format)  # formats as percentages  
    return cdf