temp=data_train.isnull().any(); print(temp)#返回每列是否有空值
[8000 rows x 42 columns]
id False
happiness False
survey_type False
province False
city False
county False
survey_time False
gender False
birth False
nationality False
religion False
religion_freq False
edu False
income False
political False
floor_area False
height_cm False
weight_jin False
health False
health_problem False
depression False
hukou False
socialize False
relax False
learn False
equity False
class False
work_exper False
work_status True
work_yr True
work_type True
work_manage True
family_income True
family_m False
family_status False
house False
car False
marital False
status_peer False
status_3_before False
view False
inc_ability False
colnull=pd.DataFrame(data={'colname': temp.index,'isnulls':temp.values}) print(colnull.loc[colnull.isnulls==True,'colname'])
#输出有空值的列
28 work_status
29 work_yr
30 work_type
31 work_manage
32 family_income