表格里的缺失值以及空白的处理_离散缺失值 空白-CSDN博客

ps:删掉nan，创造nan来替代空白行，然后删掉

#缺失值处理
df_dropna = df1.dropna(axis = 1)
#删掉有缺失值的行
ddff_filter = df1.dropna(subset = ['Customer Type'])
#删掉有缺失值的列
ddff_filter = df1.dropna(axis = 1)

#空白行处理
import pandas as pd
import numpy as np
df1.replace('',np.nan,inplace = True)
df1.dropna(axis = 1,inplace = True)
df1.dropna(axis = 0,inplace = True)