pandas find rows with nan in column code example

Example 1: dataframe find nan rows

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

Example 2: show all rows with nan for a column value pandas

df[df['col'].isnull()]

Example 3: pandas if nan, then the row above

df.fillna(method='ffill')