Pandas Notes

These are the commands I use a lot using Pandas -

Get rows with NaNs in any column

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

---

Get dataframe excluding all NaNs in a particular Column

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

---

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)