对Pandas DataFrame缺失值的查找与填充示例讲解

temp = data.isnull().any() #列中是否存在空值
print(type(temp))
print(temp)

<class \'pandas.core.series.Series\'>
eventid        False
iyear         False
imonth        False
iday         False
approxdate       True
extended       False
resolution       True
...
Length: 135, dtype: bool

colnull=pd.Data (data={\'colname\': temp.index,\'isnulls\':temp.values})
#print(colnull.head())
#不存在空值的列名
print(colnull.loc[colnull.isnulls==False,\'colname\'])

0       eventid
1        iyear
2        imonth
3         iday
...
Name: colname, dtype:  

data[data.nkill.isnull()]

data[\'doubtterr\'].fillna(0, inplace=True)
data[\'propvalue\'].fillna(data[\'propvalue\'].median(),inplace=True)