load_winequality¶

In [ ]:

load_winequality( 
                 schema: str = 'public',
                 name: str = 'winequality')

Ingests the winequality dataset into the Vertica database. This dataset is ideal for regression and classification. If a table with the same name and schema already exists, this function will create a vDataFrame from the input relation.

Parameters¶

Name	Type	Optional	Description
schema	str	✓	Schema of the new relation. The default schema is public.
name	str	✓	Name of the new relation.

Returns¶

vDataFrame : the winequality vDataFrame.

Example¶

In [65]:

from verticapy.datasets import load_winequality
load_winequality()

	123 free_sulfur_dioxide Numeric(7,2)	123 pH Numeric(6,3)	123 density Float	123 good Int	123 citric_acid Numeric(6,3)	123 quality Int	123 chlorides Float	123 alcohol Float	123 volatile_acidity Numeric(7,4)	Abc color Varchar(20)	123 fixed_acidity Numeric(6,3)	123 total_sulfur_dioxide Numeric(7,2)	123 sulphates Numeric(6,3)	123 residual_sugar Numeric(7,3)
1	20.00	3.750	0.99248	0	0.020	6	0.036	12.4	0.3100	white	3.800	114.00	0.440	11.100
2	29.00	3.570	0.989	1	0.400	8	0.03	12.8	0.2250	white	3.900	118.00	0.360	4.200
3	93.00	3.650	0.98999	1	0.360	7	0.029	12.0	0.1700	white	4.200	161.00	0.890	1.800
4	64.00	3.420	0.99688	0	0.230	3	0.041	8.0	0.2150	white	4.200	157.00	0.440	5.100
5	31.00	3.460	0.98904	1	0.390	8	0.03	12.8	0.3200	white	4.400	127.00	0.360	4.300
6	31.00	3.480	0.98816	0	0.100	6	0.024	13.1	0.4600	white	4.400	111.00	0.340	2.800
7	52.00	3.410	0.99022	1	0.090	7	0.038	12.2	0.5400	white	4.400	97.00	0.400	5.100
8	89.00	3.340	0.99332	0	0.210	5	0.033	8.0	0.1900	white	4.500	159.00	0.420	0.950
9	11.00	3.790	0.99426	0	0.000	5	0.053	10.2	0.4450	white	4.600	178.00	0.550	1.400
10	8.00	3.900	0.9934	0	0.150	4	0.054	13.1	0.5200	red	4.600	65.00	0.560	2.100
11	35.00	3.760	0.9908	0	0.290	6	0.042	11.3	0.1450	white	4.700	90.00	0.490	1.000
12	69.00	3.470	0.99212	0	0.140	5	0.036	10.5	0.3350	white	4.700	168.00	0.460	1.300
13	33.00	3.210	0.98746	1	0.180	7	0.036	14.0	0.4550	white	4.700	106.00	0.830	1.900
14	17.00	3.850	0.9932	0	0.170	6	0.058	12.9	0.6000	red	4.700	106.00	0.600	2.300
15	5.00	3.300	0.98722	0	0.090	5	0.02	13.6	0.6700	white	4.700	9.00	0.340	1.000
16	23.00	3.530	0.98981	0	0.000	6	0.036	13.8	0.7850	white	4.700	134.00	0.920	3.400
17	40.00	3.420	0.9898	1	0.320	7	0.042	11.8	0.1300	white	4.800	98.00	0.640	1.200
18	22.00	3.380	0.9902	1	0.280	7	0.03	11.3	0.1700	white	4.800	111.00	0.340	2.900
19	17.00	3.660	0.99324	1	0.210	7	0.037	12.2	0.2100	white	4.800	112.00	0.480	10.200
20	47.00	3.310	0.99132	0	0.380	6	0.074	10.3	0.2250	white	4.800	130.00	0.400	1.200
21	23.00	3.460	0.99274	1	0.230	7	0.034	11.5	0.2600	white	4.800	111.00	0.280	10.600
22	38.00	3.280	0.98924	0	0.230	6	0.044	11.9	0.2900	white	4.800	180.00	0.340	1.100
23	34.00	3.350	0.9937	0	0.000	5	0.028	9.9	0.3300	white	4.800	163.00	0.610	6.500
24	33.00	3.360	0.9939	0	0.000	6	0.028	9.9	0.3400	white	4.800	163.00	0.610	6.500
25	4.00	3.320	0.99246	0	0.120	4	0.013	13.5	0.6500	white	4.800	10.00	0.360	1.100
26	34.00	3.070	0.9954	0	0.270	6	0.03	9.4	0.2350	white	4.900	118.00	0.500	11.750
27	39.00	3.330	0.98713	1	0.310	8	0.016	14.0	0.3300	white	4.900	150.00	0.590	1.200
28	69.00	3.470	0.99212	0	0.140	5	0.036	10.4666666666667	0.3350	white	4.900	168.00	0.460	1.300
29	69.00	3.470	0.99212	0	0.140	5	0.036	10.4666666666667	0.3350	white	4.900	168.00	0.460	1.300
30	32.00	3.240	0.99138	0	0.340	5	0.068	10.1	0.3450	white	4.900	143.00	0.400	1.000
31	32.00	3.240	0.99138	0	0.340	5	0.068	10.1	0.3450	white	4.900	143.00	0.400	1.000
32	16.00	3.710	0.99154	1	0.000	7	0.048	14.0	0.4200	red	4.900	42.00	0.740	2.100
33	60.00	3.270	0.98964	0	0.170	6	0.035	11.5	0.4700	white	4.900	148.00	0.350	1.900
34	24.00	3.480	0.9906	1	0.560	7	0.026	10.8	0.1700	white	5.000	115.00	0.390	1.500
35	20.00	3.370	0.9897	0	0.400	6	0.015	12.05	0.2000	white	5.000	98.00	0.550	1.900
36	34.00	3.070	0.9954	0	0.270	6	0.03	9.4	0.2350	white	5.000	118.00	0.500	11.750
37	17.00	3.670	0.99438	0	0.190	5	0.043	10.0	0.2400	white	5.000	101.00	0.570	5.000
38	31.00	3.690	0.99098	0	0.210	6	0.039	11.7	0.2400	white	5.000	100.00	0.620	2.200
39	49.00	3.320	0.98774	1	0.340	7	0.034	13.1	0.2400	white	5.000	158.00	0.320	1.100
40	46.00	3.750	0.99238	0	0.220	6	0.043	11.3	0.2550	white	5.000	153.00	0.760	2.700
41	58.00	3.450	0.98956	1	0.320	7	0.032	12.6	0.2700	white	5.000	178.00	0.310	4.500
42	58.00	3.450	0.98956	1	0.320	7	0.032	12.6	0.2700	white	5.000	178.00	0.310	4.500
43	42.00	3.320	0.99204	0	0.400	6	0.076	10.1	0.2700	white	5.000	124.00	0.470	1.200
44	54.00	3.270	0.98976	1	0.540	8	0.035	12.9	0.2900	white	5.000	155.00	0.340	5.700
45	54.00	3.360	0.9887	1	0.330	7	0.03	13.0	0.3000	white	5.000	173.00	0.300	3.700
46	43.00	3.300	0.994	0	0.000	6	0.046	9.9	0.3100	white	5.000	166.00	0.630	6.400
47	10.00	3.480	0.9917	0	0.160	6	0.049	10.7	0.3300	white	5.000	97.00	0.440	1.500
48	10.00	3.480	0.9917	0	0.160	6	0.049	10.7	0.3300	white	5.000	97.00	0.440	1.500
49	10.00	3.480	0.9917	0	0.160	6	0.049	10.7	0.3300	white	5.000	97.00	0.440	1.500
50	40.00	3.180	0.99114	0	0.180	6	0.032	11.0	0.3300	white	5.000	124.00	0.400	4.600
51	23.00	3.410	0.99322	0	0.230	6	0.03	11.8	0.3300	white	5.000	158.00	0.640	11.800
52	24.00	3.390	0.99241	0	0.250	6	0.031	11.3	0.3500	white	5.000	116.00	0.400	7.800
53	24.00	3.390	0.99241	0	0.250	6	0.031	11.3	0.3500	white	5.000	116.00	0.400	7.800
54	26.00	3.700	0.99084	0	0.010	6	0.048	14.0	0.3800	red	5.000	60.00	0.750	1.600
55	29.00	3.490	0.9902	0	0.500	6	0.046	13.6	0.4000	red	5.000	80.00	0.660	4.300
56	19.00	3.720	0.9917	1	0.240	8	0.06	14.0	0.4200	red	5.000	50.00	0.740	2.000
57	38.00	3.370	0.9985	0	0.040	6	0.039	10.2	0.4400	white	5.000	128.00	0.570	18.600
58	33.00	3.210	0.98746	1	0.180	7	0.036	14.0	0.4550	white	5.000	106.00	0.830	1.900
59	35.00	3.530	0.9918	1	0.140	8	0.032	12.5	0.5500	white	5.000	164.00	0.510	8.300
60	65.00	3.260	0.9874	0	0.120	5	0.009	13.5	0.6100	white	5.000	100.00	0.370	1.300
61	16.00	4.010	0.99258	0	0.000	6	0.041	12.5	0.7400	red	5.000	46.00	0.590	1.200
62	41.00	3.750	0.9938	0	0.040	4	0.045	10.5	1.0200	red	5.000	85.00	0.480	1.400
63	32.00	3.740	0.9934	0	0.240	5	0.05	11.5	1.0400	red	5.000	96.00	0.620	1.600
64	12.00	3.570	0.99008	0	0.320	6	0.028	12.2	0.1100	white	5.100	90.00	0.520	1.600
65	15.00	3.220	0.9919	0	0.250	6	0.039	9.2	0.1400	white	5.100	89.00	0.430	0.700
66	42.00	3.180	0.9934	0	0.220	6	0.047	9.9	0.1650	white	5.100	146.00	0.550	5.700
67	48.00	3.500	0.99168	0	0.280	5	0.047	10.4	0.2100	white	5.100	148.00	0.490	1.400
68	13.00	3.220	0.98956	0	0.180	5	0.053	11.5	0.2300	white	5.100	99.00	0.390	1.000
69	40.00	3.230	0.9891	1	0.360	7	0.035	12.1	0.2500	white	5.100	78.00	0.640	1.300
70	46.00	3.350	0.98946	1	0.330	7	0.027	11.4	0.2600	white	5.100	113.00	0.430	1.100
71	26.00	3.230	0.99449	0	0.340	6	0.034	9.2	0.2600	white	5.100	99.00	0.410	6.400
72	27.00	3.360	0.99308	0	0.280	6	0.026	11.0	0.2900	white	5.100	107.00	0.370	8.300
73	27.00	3.360	0.99308	0	0.280	6	0.026	11.0	0.2900	white	5.100	107.00	0.370	8.300
74	40.00	3.290	0.98944	0	0.300	6	0.048	12.2	0.3000	white	5.100	150.00	0.460	2.300
75	17.00	3.400	0.99	0	0.130	5	0.036	12.3333333333333	0.3050	white	5.100	73.00	0.510	1.750
76	28.00	3.540	0.992	0	0.300	6	0.037	10.1	0.3100	white	5.100	152.00	0.560	0.900
77	18.00	3.510	0.9893	1	0.220	7	0.027	12.5	0.3300	white	5.100	89.00	0.380	1.600
78	18.00	3.510	0.9893	1	0.220	7	0.027	12.5	0.3300	white	5.100	89.00	0.380	1.600
79	18.00	3.510	0.9893	1	0.220	7	0.027	12.5	0.3300	white	5.100	89.00	0.380	1.600
80	44.00	3.360	0.99221	1	0.270	7	0.022	11.0	0.3300	white	5.100	129.00	0.390	6.700
81	36.00	3.380	0.99188	0	0.260	6	0.034	11.5	0.3500	white	5.100	120.00	0.400	6.800
82	36.00	3.380	0.99188	0	0.260	6	0.034	11.5	0.3500	white	5.100	120.00	0.400	6.800
83	36.00	3.380	0.99188	0	0.260	6	0.034	11.5	0.3500	white	5.100	120.00	0.400	6.800
84	15.00	3.500	0.9894	0	0.210	6	0.027	12.5	0.3900	white	5.100	72.00	0.450	1.700
85	18.00	3.680	0.99157	1	0.000	7	0.044	13.6	0.4200	red	5.100	88.00	0.730	1.800
86	25.00	3.380	0.9894	1	0.010	7	0.017	12.3	0.4200	white	5.100	102.00	0.360	1.500
87	18.00	3.900	0.9921	0	0.020	6	0.034	12.8	0.4700	red	5.100	44.00	0.620	1.300
88	16.00	3.460	0.9924	1	0.180	7	0.042	12.9	0.5100	red	5.100	101.00	0.870	2.100
89	30.00	3.320	0.9932	0	0.060	5	0.052	9.3	0.5200	white	5.100	79.00	0.430	2.700
90	14.00	3.560	0.99264	1	0.000	7	0.044	12.9	0.5850	red	5.100	86.00	0.940	1.700
91	13.00	3.300	0.98975	1	0.330	8	0.028	11.9	0.1550	white	5.200	59.00	0.840	1.600
92	13.00	3.300	0.98975	1	0.330	8	0.028	11.9	0.1550	white	5.200	59.00	0.840	1.600
93	26.00	3.250	0.99155	0	0.340	6	0.029	10.1	0.1600	white	5.200	77.00	0.510	0.800
94	11.00	3.300	0.99218	0	0.270	5	0.03	9.8	0.1700	white	5.200	68.00	0.410	0.700
95	47.00	3.550	0.99218	0	0.220	6	0.03	10.15	0.1850	white	5.200	123.00	0.440	1.000
96	16.00	3.440	0.99235	1	0.270	7	0.047	10.1	0.2000	white	5.200	93.00	0.530	3.200
97	17.00	3.240	0.98953	1	0.310	7	0.048	12.0	0.2100	white	5.200	61.00	0.370	1.700
98	41.00	3.190	0.99362	0	0.460	5	0.066	9.73333333333333	0.2200	white	5.200	187.00	0.420	6.200
99	32.00	3.240	0.99378	0	0.150	6	0.043	9.9	0.2400	white	5.200	134.00	0.480	7.100
100	21.00	3.550	0.992	1	0.450	8	0.027	11.2	0.2400	white	5.200	128.00	0.490	3.800

Out[65]:

Rows: 1-100 of 6497 | Columns: 14