Modeling Wine

We propose a data mining approach to predict human wine.

@kaggle.willianoliveiragibin_modeling_wine

Table List

1 table(72.19 KB)

Winequality White New

@kaggle.willianoliveiragibin_modeling_wine.winequality_white_new

72.19 KB
4898 rows
12 columns

fixed_acidity Fixed Acidity	volatile_acidity Volatile Acidity	citric_acid Citric Acid	residual_sugar Residual Sugar	chlorides Chlorides	free_sulfur_dioxide Free Sulfur Dioxide	total_sulfur_dioxide Total Sulfur Dioxide	density Density	ph PH	sulphates Sulphates	quality Quality	alcohol Alcohol
7	0.27	0.36	20.7	45	45	170	1.001	3	0.45	6	R$ 45.512,00
6.3	0.3	0.34	1.6	49	14	132	994	3.3	0.49	6	R$ 45.421,00
8.1	0.28	0.4	6.9	0.05	30	97	9.951	3.26	0.44	6	R$ 45.301,00
7.2	0.23	0.32	8.5	58	47	186	9.956	3.19	0.4	6	R$ 45.544,00
7.2	0.23	0.32	8.5	58	47	186	9.956	3.19	0.4	6	R$ 45.544,00
8.1	0.28	0.4	6.9	0.05	30	97	9.951	3.26	0.44	6	R$ 45.301,00
6.2	0.32	0.16	7	45	30	136	9.949	3.18	0.47	6	R$ 45.452,00
7	0.27	0.36	20.7	45	45	170	1.001	3	0.45	6	R$ 45.512,00
6.3	0.3	0.34	1.6	49	14	132	994	3.3	0.49	6	R$ 45.421,00
8.1	0.22	0.43	1.5	44	28	129	9.938	3.22	0.45	6	R$ 11,00


CREATE TABLE winequality_white_new (
  "fixed_acidity" DOUBLE,
  "volatile_acidity" DOUBLE,
  "citric_acid" DOUBLE,
  "residual_sugar" DOUBLE,
  "chlorides" DOUBLE,
  "free_sulfur_dioxide" DOUBLE,
  "total_sulfur_dioxide" DOUBLE,
  "density" DOUBLE,
  "ph" DOUBLE,
  "sulphates" DOUBLE,
  "quality" BIGINT,
  "alcohol" VARCHAR
);