Wine Quality

Wine quality for red and white wine

@kaggle.brendan45774_wine_quality

Table List

2 tables(108.22 KB)

Winequality Red

@kaggle.brendan45774_wine_quality.winequality_red

33.41 KB
1599 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	alcohol Alcohol	quality Quality
7.4	0.7		1.9	0.076	11	34	0.9978	3.51	0.56	9.4	5
7.8	0.88		2.6	0.098	25	67	0.9968	3.2	0.68	9.8	5
7.8	0.76	0.04	2.3	0.092	15	54	0.997	3.26	0.65	9.8	5
11.2	0.28	0.56	1.9	0.075	17	60	0.998	3.16	0.58	9.8	6
7.4	0.7		1.9	0.076	11	34	0.9978	3.51	0.56	9.4	5
7.4	0.66		1.8	0.075	13	40	0.9978	3.51	0.56	9.4	5
7.9	0.6	0.06	1.6	0.069	15	59	0.9964	3.3	0.46	9.4	5
7.3	0.65		1.2	0.065	15	21	0.9946	3.39	0.47	10	7
7.8	0.58	0.02	2	0.073	9	18	0.9968	3.36	0.57	9.5	7
7.5	0.5	0.36	6.1	0.071	17	102	0.9978	3.35	0.8	10.5	5


CREATE TABLE winequality_red (
  "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,
  "alcohol" DOUBLE,
  "quality" BIGINT
);