check if any column is null pandas 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()

Example 3: python if column is null then

df['real_lastName'] = np.where(df['LastName'].isnull(), df['Middle'], df['LastName'] )

print (df)
  FirstName Middle LastName real_lastName
0       Tom     Ju      NaN            Ju
1      Kity    NaN      Rob           Rob