我有一个数据集,其中包含一些分类变量,这些变量有一些缺失值(NA/Null)。我想用该列的众数来填充这些NA/Null值。我尝试了以下方法,但没有奏效:
MD=Data['Gender'].mode()Data['Gender'].fillna(value=MD,inplace=True)MD=Data['Married'].mode()Data['Married'].fillna(value=MD,inplace=True)MD=Data['Dependents'].mode()Data['Dependents'].fillna(value=MD,inplace=True)MD=Data['Self_Employed'].mode()Data['Self_Employed'].fillna(value=MD,inplace=True)MD=Data['Credit_History'].mode()Data['Credit_History'].fillna(value=MD,inplace=True)Gender 26Married 6Dependents 30Education 0Self_Employed 64ApplicantIncome 0CoapplicantIncome 0LoanAmount 0Loan_Amount_Term 0Credit_History 100Property_Area 0Loan_Status 0
仍然显示有缺失值。
回答:
尝试这样做:
Data['Married'].fillna(Data['Married'].mode(), inplace=True)
或者尝试这样做:
Data['Married'].fillna(Data['Married'].value_counts().index[0], inplace=True)
确保你的分类变量的数据类型是object或category。