how take only those rows which column has no nan value pandas code example

Example 1: python select columns with no na

df = df[df.columns[~df.isnull().all()]]

Example 2: fetch row where column is missing pandas

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