Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

As Jay s wealth grows he has taken interest in the more finer things in life. Wine is one of them. He enjoys drinking wine

As Jays wealth grows he has taken interest in the more finer things in life. Wine is one of them. He enjoys drinking wine so much that he has decided to buy a vineyard. He currently is looking at different vineyards that are for sale and will decide to purchase one.
To decide which vineyard to purchase we need to know the price, size and quality of the wine that it produces. The size and price are easy to figure out. Quality is another story. Figuring out the quality of wine is not easy.
Here is what we are going to do. We have a wine data set. In the data set we know 11 attributes about almost 5,000 wines. These are easy to measure, like pH level. There is a simple test for that. The people that made the data set hired experience wine judges to judge each wine. Their quality score (from 0 to 10) is in column 12.
1. Fixed acidity
2. Volatile acidity
3. Citric acid
4. Residual sugar
5. Chlorides
6. Free sulfur dioxide
7. Total sulfur dioxide
8. Density
9. pH
10. Sulphates
11. Alcohol
12. Quality this is the value that we are trying to predict.
Before we try to create a wine classification solution, we see a problem with the data. The values are very different ranges and scales. For example Chlorides is normally less than 0.05, while Total sulfur dioxide is normally over 100.
You and Bill decided that you need some pre-processing of the data. For each column you would like the minimum value to scale to 0 and the maximum value scale to 1. For example, lets say that the values in a column of data are [0,2,3,4,5,10].0 is the smallest, that stays 0.10 is the largest, that becomes 1. Your scaled data would be [0,.2,.3,.4,.5,1.0].
Instructions
Create a Python program to load the wine quality data file. Scale all of the columns to be scaled values between 0 and 1. Then print a few lines of the original data, followed by the scaled data. You must use Scikit Learn; you cannot just hand write a bunch of Python code to do it.

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

Transact SQL Cookbook Help For Database Programmers

Authors: Ales Spetic, Jonathan Gennick

1st Edition

1565927567, 978-1565927568

More Books

Students also viewed these Databases questions