Python中识别DataFrame中的nan

# 识别python中DataFrame中的nan
for i in pfsj.index:
  if type(pfsj.loc[i]['WZML']) == float:
    print('float value is ${}'.format(pfsj.loc[i]['WZML']))
  elif type(pfsj.loc[i]['WZML']) == str:
    print('str value is ${}'.format(pfsj.loc[i]['WZML']))

结果:

# 根据结果可知在DataFrame中,nan的类型为float
# 使用math中的isnan函数识别数据是否是nan类型的
for i in pfsj.index:
  if type(pfsj.loc[i]['WZML']) == float:
    if isnan(pfsj.loc[i]['WZML']):
      print('float type is ${}'.format(type(pfsj.loc[i]['WZML'])))

结果:

 

posted @ 2018-06-24 10:44  云山之巅  阅读(20352)  评论(0编辑  收藏  举报