Get rows with NaNs in any column

df[df.isna().any(axis=1)]

TailDF


Get dataframe excluding all NaNs in a particular Column

df[df['<col_name>'].notnull()]

TailDF


Get counts of number of Nulls per column

df.isnull().sum()


Increase width of columns displayed in Jupyter Notebooks

  • This is possibly one of my most used commands for every notebook that involves dataframes.

pd.set_option('display.max_colwidth',400)