Question: 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 hmeq_small.csv (Nicapotato. "Vallala, Ajay. "HMEQ_Data." Kaggle, 25 Mar. 2018, www.kaggle.com/ajay1735/hmeq-data.) 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 hmeq_sample.csv, the output is:
Means for df1 are LOAN 3208.333333
MORTDUE 67495.958333
VALUE 82529.125000
YOJ 8.500000
CLAGE 144.749455
CLNO 16.583333
DEBTINC 33.052122
dtype: float64
Means for df2 are LOAN 3045.918367
MORTDUE 49386.494253
VALUE 64033.483871
YOJ 8.179775
CLAGE 140.209320
CLNO 15.586957
DEBTINC 30.947152
dtype: float64Load the data set hmeq_small.csv (Nicapotato. "Vallala, Ajay. "HMEQ_Data." Kaggle, 25 Mar. 2018, www.kaggle.com/ajay1735/hmeq-data.) 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 hmeq_sample.csv, the output is:
Means for df1 are LOAN 3208.333333
MORTDUE 67495.958333
VALUE 82529.125000
YOJ 8.500000
CLAGE 144.749455
CLNO 16.583333
DEBTINC 33.052122
dtype: float64
Means for df2 are LOAN 3045.918367
MORTDUE 49386.494253
VALUE 64033.483871
YOJ 8.179775
CLAGE 140.209320
CLNO 15.586957
DEBTINC 30.947152
dtype: float64

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!