find which columns have nan sql code example

Example 1: find nan values in a column pandas

df.isnull().values.any()

Example 2: find nan values in a column pandas

df['your column name'].isnull().sum()