Preprocessing and EDA

DATA Cleaning

Handling missing value, outliers

Feature Scaling

EDA

Dimensionality reduction (PCA)

K-Means Clustering

Correlation Heatmap + pairplot/nReading the Data from the csv

0

1

2

wine-pd.read_csv("winequality-white.csv",delimiter=';')

✓ 0.1s

3

wine.head()

fixed acidity volatile acidity citric acid residual sugar chlorides free sulfur dioxide total sulfur dioxide density pH sulphates alcohol quality

7.0

0.27

0.36

20.7

0.045

45.0

170.0 1.0010 3.00

0.45 8.8

6

6.3

0.30

0.34

1.6

0.049

14.0

132.0 0.9940 3.30

0.49

9.5

6

8.1

0.28

0.40

6.9

0.050

30.0

97.0 0.9951 3.26

0.44

6

7.2

0.23

0.32

8.5

0.058

47.0

186.0 0.9956 3.19

0.40

6

7.2

0.23

0.32

8.5

0.058

47.0

186.0 0.9956 3.19

0.40

6

10.1

9.9

9.9/nShape of the Dataset

#to know shape of the dataset

wine.shape

✓ 0.1s

(4898, 12)

It contains 4898 Entries, each having 12 columns/nNumber of Unique values for each column

#Number of unique valuesin this dataset

for col in wine.columns.values:

| print("Number of unique values of {}:{}".format(col,wine[col].nunique()))

0.0s

Number of unique values of fixed acidity:68

Number of unique values of volatile acidity:125

Number of unique values of citric acid:87

Number of unique values of residual sugar: 310

Number of unique values of chlorides: 160

Number of unique values of free sulfur dioxide: 132

Number of unique values of total sulfur dioxide:251

Number of unique values of density:890

Number of unique values of pH: 103

Number of unique values of sulphates:79

Number of unique values of alcohol: 103

Number of unique values of quality: 7/nDetails About each column and their datatype

✓ 0.0s

RangeIndex: 4898 entries, 0 to 4897

Data columns (total 12 columns):

Column

#

0

1

2

wine.info()

3

4

5

6

7

-----

fixed acidity

volatile acidity

citric acid

residual sugar

chlorides

free sulfur dioxide

total sulfur dioxide

density

pH

Non-Null Count Dtype

sulphates

4898 non-null

4898 non-null

4898 non-null

4898 non-null

4898 non-null

4898 non-null

4898 non- null

4898 non-null

4898 non-null

4898 non-null

4898 non-null

4898 non-null

8

9

10 alcohol.

11 quality

dtypes: float64(11), int64(1)

memory usage: 459.3 KB

-----

float64

float64

float64

float64

float64

float64

float64

float64

float64

float64

float64

int64