Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Case Study: You are asked to help a real estate agent predict prices for home in the USA. It would be great if you could

Case Study: You are asked to help a real estate agent predict prices for home in the USA. It would be great if you could somehow create a model that allows them to put in a few features of a house and return an estimate of what the house would sell for. You are given information about US homes in the dataset: assignment1_usa_housing.csv (note that this is fabricated dataset). The data contains the following columns: 'Avg. Area Income': Avg. Income of residents of the city house is located in. 'Avg. Area House Age': Avg Age of Houses in same city 'Avg. Area Number of Rooms': Avg Number of Rooms for Houses in same city 'Avg. Area Number of Bedrooms': Avg Number of Bedrooms for Houses in same city 'Area Population': Population of city house is located in 'Price': Price that the house sold at 'Address': Address for the house Assignment Tasks: The goal is to build a predictive model using housing dataset and evaluate your models. NEED TO USE PANDAS AND SCIKIT-LEARN LIBRARIES!! 1. Using Python, Perform Exploratory Data Analysis to understand the dataset and capture your observations in the assignment report 20 points 2. Using various python libraries develop machine learning model(s) to predict Price. You can use any ML algorithm of your choice from sklearn. 30 points

please use assignment1_usa_housing.csv as a input directory no real data is currenlty needed just need the python code.

Avg. Area Income Avg. Area House Age Avg. Area Number of Rooms Avg. Area Number of Bedrooms Area Population Price Address
79545.45857 5.682861322 7.009188143 4.09 23086.8005 1059033.558 208 Michael Ferry Apt. 674 Laurabury, NE 37010-5101
79248.64245 6.002899808 6.730821019 3.09 40173.07217 1505890.915 188 Johnson Views Suite 079 Lake Kathleen, CA 48958
61287.06718 5.86588984 8.51272743 5.13 36882.1594 1058987.988 9127 Elizabeth Stravenue Danieltown, WI 06482-3489
63345.24005 7.188236095 5.586728665 3.26 34310.24283 1260616.807 USS Barnett FPO AP 44820
59982.19723 5.040554523 7.839387785 4.23 26354.10947 630943.4893 USNS Raymond FPO AE 09386
80175.75416 4.988407758 6.104512439 4.04 26748.42842 1068138.074 06039 Jennifer Islands Apt. 443 Tracyport, KS 16077
64698.46343 6.025335907 8.147759585 3.41 60828.24909 1502055.817 4759 Daniel Shoals Suite 442 Nguyenburgh, CO 20247

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

Database Systems Design Implementation And Management

Authors: Peter Rob, Carlos Coronel

6th International Edition

061921323X, 978-0619213237

More Books

Students also viewed these Databases questions

Question

2. Describe who gets hurt in a recession and how they are hurt.

Answered: 1 week ago