Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the HousePrices.db. Write a script that: Will bin the prices into 3 bins Bin 1 = $100,000 to $199,000 Bin 2 = $200,000 to

image text in transcribed

  1. Use the HousePrices.db. Write a script that:
    1. Will bin the prices into 3 bins

Bin 1 = $100,000 to $199,000

Bin 2 = $200,000 to $299,000

Bin 3 = $300,000 and up

  1. Will create a 1-hot-encoding of the binned prices.

The final table should look like this

HouseID

Price

Bin

Bin1

Bin2

Bin3

1

250,000

2

0

1

0

2

310,000

3

0

0

1

Copy and paste your SQL code in this file or submit an extra file.

1 2 3 4 5 6 7 123 houselD T: 123 price Ti 1 250,000 2 310,000 3 160,000 4 310,000 5 360,000 6 500,000 7 210,000 8 155,000 9 190,000 10 230,000 8 9 10

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

Step: 3

blur-text-image

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

Data Analysis Using SQL And Excel

Authors: Gordon S Linoff

2nd Edition

111902143X, 9781119021438

More Books

Students also viewed these Databases questions

Question

Why is repatriation orientation and training needed?

Answered: 1 week ago

Question

What must a creditor do to become a secured party?

Answered: 1 week ago

Question

When should the last word in a title be capitalized?

Answered: 1 week ago

Question

=+ c. a company president deciding whether to open a new factory

Answered: 1 week ago