Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Load the data set hmeq _ small.csv ( Nicapotato . Vallala, Ajay. HMEQ _ Data. Kaggle, 2 5 Mar. 2 0 1 8 , www
Load the data set hmeqsmall.csv Nicapotato "Vallala, Ajay. "HMEQData." Kaggle, Mar. wwwkaggle.comajayhmeqdata. as a data frame.
Create a new data frame with all the rows with missing data deleted.
Create a second data frame with all missing data filled in with the mean value of the column.
Find the means of the columns for both new data frames.
Ex: Using only the first hundred rows, found in hmeqsample.csv the output is:
Means for df are LOAN
MORTDUE
VALUE
YOJ
CLAGE
CLNO
DEBTINC
dtype: float
Means for df are LOAN
MORTDUE
VALUE
YOJ
CLAGE
CLNO
DEBTINC
dtype: floatLoad the data set hmeqsmall.csv Nicapotato "Vallala, Ajay. "HMEQData." Kaggle, Mar. wwwkaggle.comajayhmeqdata. as a data frame.
Create a new data frame with all the rows with missing data deleted.
Create a second data frame with all missing data filled in with the mean value of the column.
Find the means of the columns for both new data frames.
Ex: Using only the first hundred rows, found in hmeqsample.csv the output is:
Means for df are LOAN
MORTDUE
VALUE
YOJ
CLAGE
CLNO
DEBTINC
dtype: float
Means for df are LOAN
MORTDUE
VALUE
YOJ
CLAGE
CLNO
DEBTINC
dtype: float
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started