# 识别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'])))
结果: