find rows with null values pandas code example

Example 1: dataframe find nan rows

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

Example 2: show rows with a null value pandas

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

Example 3: python count null values in dataframe

# Count total missing values in a dataframe

df.isnull().sum().sum()

# Gives a integer value

Example 4: select rows with nan pandas

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