Answers for "show columns with nan pandas"

find nan values in a column pandas

df.isnull().values.any()

represent NaN with pandas in python

import pandas as pd

if pd.isnull(float("Nan")):
  print("Null Value.")

show columns with nan pandas

In [71]: df
Out[71]:
     a    b  c
0  NaN  7.0  0
1  0.0  NaN  4
2  2.0  NaN  4
3  1.0  7.0  0
4  1.0  3.0  9
5  7.0  4.0  9
6  2.0  6.0  9
7  9.0  6.0  4
8  3.0  0.0  9
9  9.0  0.0  1

In [72]: df.isna().any()
Out[72]:
a     True
b     True
c    False
dtype: bool

pandas take entries from other column if column is nan

df.Temp_Rating.fillna(df.Farheit, inplace=True)
del df['Farheit']
df.columns = 'File heat Observations'.split()