Wine Quality

Wine quality for red and white wine

@kaggle.brendan45774_wine_quality

Table List

2 tables(108.22 KB)

Winequality White

@kaggle.brendan45774_wine_quality.winequality_white

74.81 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	alcohol Alcohol	quality Quality
7	0.27	0.36	20.7	0.045	45	170	1.001	3	0.45	8.8	6
6.3	0.3	0.34	1.6	0.049	14	132	0.994	3.3	0.49	9.5	6
8.1	0.28	0.4	6.9	0.05	30	97	0.9951	3.26	0.44	10.1	6
7.2	0.23	0.32	8.5	0.058	47	186	0.9956	3.19	0.4	9.9	6
7.2	0.23	0.32	8.5	0.058	47	186	0.9956	3.19	0.4	9.9	6
8.1	0.28	0.4	6.9	0.05	30	97	0.9951	3.26	0.44	10.1	6
6.2	0.32	0.16	7	0.045	30	136	0.9949	3.18	0.47	9.6	6
7	0.27	0.36	20.7	0.045	45	170	1.001	3	0.45	8.8	6
6.3	0.3	0.34	1.6	0.049	14	132	0.994	3.3	0.49	9.5	6
8.1	0.22	0.43	1.5	0.044	28	129	0.9938	3.22	0.45	11	6


CREATE TABLE winequality_white (
  "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
);