locate nans in a dataframe code example
Example 1: dataframe find nan rows
df[df.isnull().any(axis=1)]
Example 2: find nan value in dataframe python
df['your column name'].isnull()
Example 3: find all nan columns pandas
nan_cols = [i for i in df.columns if df[i].isnull().any()]
print("No. of columns containing null values")
print(len(df.columns[df.isna().any()]))
print("No. of columns not containing null values")
print(len(df.columns[df.notna().all()]))
print("Total no. of columns in the dataframe")
print(len(df.columns))