Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help with python coding!! Working with a Dataframe In this problem, you will be working with the data set calif _ housing _ data.csv

Please help with python coding!!
Working with a Dataframe
In this problem, you will be working with the data set calif_housing_data.csv. This data is a modified
columns in the data, which include the median age (in years) of houses on the block, the total number
of bedrooms on the block, the total number of households on the block, the median income on the
block, and the median house value on the block. Now, suppose you are building a model to predict
the median house value. Use Python code to answer the following questions
(a) How many rows does this data set have?
(b) What is the target vector for your model?
(c) Create a new feature by taking the total bedrooms divided by the number of households. What
does this new feature represent?
(d) Now, create a new data frame that has three features: the median age, median income, and the
new feature created in part (c).
(e) Take the data frame created in part (d) and apply data standardization to the features.
I cannot provide the data sheet here as it is over 100,000 inputs of data but I just need the python codes to see !!HOW!! to get the answers to the questions. Thank you
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Hands On Database

Authors: Steve Conger

1st Edition

013610827X, 978-0136108276

More Books

Students also viewed these Databases questions

Question

Identify five strategies to prevent workplace bullying.

Answered: 1 week ago