1.对原数据redbook,做查询缺失值
redbook.isnull().sum()
运行结果:
revenue 0
gender 11729
age 28205
engaged_last_30 11729
lifecycle 0
days_since_last_order 0
previous_order_amount 0
3rd_party_stores 0
dtype: int64
2.用均值填充age年龄一列的缺失值
redbook=redbook.fillna(redbook.age.mean())
3.检查填充效果
redbook.isnull().sum()
运行结果:
revenue 0
gender 0
age 0
engaged_last_30 0
lifecycle 0
days_since_last_order 0
previous_order_amount 0
3rd_party_stores 0
dtype: int64
Q:对age这个特定列做均值的缺失值填充,为什么每一列的缺失值都被填充了