load_commodities¶

In [ ]:

load_commodities( 
                 schema: str = 'public',
                 name: str = 'commodities')

Ingests the Commodities dataset into the Vertica database. This dataset is ideal for time series and regrettion function. 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 Commodities vDataFrame.

Example¶

In [6]:

from verticapy.datasets import load_commodities
load_commodities()

Out[6]:

	📅 date Date	123 Gold Float	123 Oil Float	123 Spread Float	123 Vix Float	123 Dol_Eur Float	123 SP500 Float
1	1986-01-01	345.561363636364	22.9254545454545	1.05142857142857	18.1213636363636	1.12159999999858	211.779999
2	1986-02-01	339.0525	15.4547368421053	0.736842105263158	20.6242105263158	1.07880000000296	226.919998
3	1986-03-01	346.094736842105	12.6125	0.564	23.564	1.04850000000442	238.899994
4	1986-04-01	340.715909090909	12.8436363636364	0.604090909090909	23.0154545454545	1.05259999999544	235.520004
5	1986-05-01	342.325	15.377619047619	0.642380952380952	18.8875	1.03720000000612	247.350006
6	1986-06-01	342.797619047619	13.4257142857143	0.614761904761905	18.5980952380952	1.0399999999936	250.839996
7	1986-07-01	348.554347826087	11.5845454545455	0.636818181818182	19.6390909090909	1.01029999999446	236.119995
8	1986-08-01	376.29	15.0966666666667	0.83952380952381	18.6380952380952	0.979300000000876	252.929993
9	1986-09-01	418.152272727273	14.8666666666667	1.10142857142857	22.7052380952381	0.973200000000361	231.320007
10	1986-10-01	423.863043478261	14.8968181818182	1.14727272727273	22.5239130434783	0.961600000000544	243.979996
11	1986-11-01	396.9825	15.2215789473684	0.973888888888889	18.6315789473684	0.967399999999543	249.220001
12	1986-12-01	391.595238095238	16.107619047619	0.840909090909091	19.7586363636364	0.957399999999325	242.169998
13	1987-01-01	408.52380952381	18.6514285714286	0.8585	20.7666666666667	0.900400000000445	274.079987
14	1987-02-01	401.045	17.7489473684211	0.852631578947368	23.4463157894737	0.882600000000821	284.200012
15	1987-03-01	408.847727272727	18.3028571428571	0.824090909090909	21.8372727272727	0.883599999999206	291.700012
16	1987-04-01	439.665	18.6771428571429	0.998571428571429	26.8814285714286	0.872100000000501	288.359985
17	1987-05-01	461.65	19.4375	0.8515	25.4115	0.861100000000079	290.100006
18	1987-06-01	449.277272727273	20.0731818181818	0.829090909090909	21.6245454545455	0.876500000000306	304.0
19	1987-07-01	450.330434782609	21.3421739130435	1.00454545454545	17.8009090909091	0.888600000000224	318.660004
20	1987-08-01	460.9875	20.3109523809524	1.00761904761905	20.8490476190476	0.89600000000064	329.799988
21	1987-09-01	460.120454545455	19.53	1.07809523809524	22.8938095238095	0.873499999999694	321.829987
22	1987-10-01	465.763636363636	19.8590909090909	1.12238095238095	58.2195454545455	0.868599999999788	251.789993
23	1987-11-01	468.140476190476	18.854	1.16789473684211	49.4365	0.814700000000812	230.300003
24	1987-12-01	487.078571428571	17.2745454545455	1.13	41.7640909090909	0.791400000000067	247.080002
25	1988-01-01	477.7575	17.1295	1.03578947368421	38.3365	0.800100000000384	257.070007
26	1988-02-01	442.12380952381	16.7957142857143	1.0315	33.674	0.822000000000116	267.820007
27	1988-03-01	443.491304347826	16.1973913043478	1.10304347826087	29.3569565217391	0.810900000000402	258.890015
28	1988-04-01	451.557894736842	17.8625	1.129	27.405	0.805700000000798	261.329987
29	1988-05-01	451.32	17.4236363636364	1.09333333333333	25.7166666666667	0.813099999999395	262.160004
30	1988-06-01	451.656818181818	16.5277272727273	0.895454545454546	25.2709090909091	0.842500000000655	273.5
31	1988-07-01	437.452380952381	15.4975	0.777	23.644	0.886300000000119	272.019989
32	1988-08-01	431.063636363636	15.5234782608696	0.631739130434783	23.7073913043478	0.905899999999747	261.519989
33	1988-09-01	413.438636363636	14.5354545454545	0.513809523809524	19.5242857142857	0.900299999999334	271.910004
34	1988-10-01	406.390476190476	13.7704761904762	0.4415	20.4819047619048	0.87960000000021	278.970001
35	1988-11-01	419.965909090909	14.1413636363636	0.2965	21.6590476190476	0.844499999999243	273.700012
36	1988-12-01	419.2475	16.382380952381	0.0171428571428571	17.7542857142857	0.843999999999141	277.720001
37	1989-01-01	404.445238095238	18.0242857142857	-0.084	17.7580952380952	0.880499999999302	297.470001
38	1989-02-01	387.9725	17.9365	-0.202631578947368	18.3126315789474	0.888899999999921	288.859985
39	1989-03-01	390.27380952381	19.4840909090909	-0.321818181818182	17.4754545454545	0.896699999999328	294.869995
40	1989-04-01	384.72	21.069	-0.276	16.8875	0.899199999999837	309.640015
41	1989-05-01	371.35	20.1234782608696	-0.158636363636364	17.435	0.9375	320.519989
42	1989-06-01	367.727272727273	20.0504545454545	-0.129090909090909	16.7322727272727	0.955400000000736	317.980011
43	1989-07-01	375.209523809524	19.7814285714286	0.199	18.0565	0.914000000000669	346.079987
44	1989-08-01	365.547727272727	18.5778260869565	-0.0321739130434783	19.3234782608696	0.927799999999479	351.450012
45	1989-09-01	361.797619047619	19.5914285714286	-0.094	16.7465	0.941100000000006	349.149994
46	1989-10-01	366.8	20.0977272727273	0.0285714285714286	21.9509090909091	0.907199999999648	340.359985
47	1989-11-01	394.361363636364	19.8559090909091	0.0785714285714286	20.932380952381	0.893899999999121	345.98999
48	1989-12-01	409.655263157895	21.1	0.059	18.235	0.856499999999869	353.399994
49	1990-01-01	410.118181818182	22.8631818181818	0.121428571428571	23.4990909090909	0.831899999999223	329.079987
50	1990-02-01	416.5425	22.113	0.102631578947368	23.3268421052632	0.820799999999508	331.890015
51	1990-03-01	393.661363636364	20.3877272727273	-0.0381818181818182	18.8313636363636	0.835100000000239	339.940002
52	1990-04-01	374.928947368421	18.4255	0.0615	20.4575	0.82510000000002	330.799988
53	1990-05-01	368.854761904762	18.1995454545455	0.115909090909091	18.1518181818182	0.811400000000504	361.230011
54	1990-06-01	352.657142857143	16.6952380952381	0.129047619047619	17.5828571428571	0.817699999999604	358.019989
55	1990-07-01	361.820454545455	18.4540909090909	0.314285714285714	18.9328571428571	0.792699999999968	356.149994
56	1990-08-01	394.861363636364	27.3073913043478	0.691304347826087	27.7752173913043	0.759899999999106	322.559998
57	1990-09-01	389.56	33.5075	0.813684210526316	28.8189473684211	0.761699999999109	306.049988
58	1990-10-01	381.332608695652	36.0395652173913	0.841818181818182	30.1304347826087	0.739799999999377	304.0
59	1990-11-01	381.865909090909	32.3322727272727	0.7935	25.1066666666667	0.72400000000016	322.220001
60	1990-12-01	378.160526315789	27.281	0.761	22.5845	0.731999999999971	330.220001
61	1991-01-01	384.590909090909	25.2340909090909	0.967619047619048	26.9318181818182	0.736699999999473	343.929993
62	1991-02-01	363.7475	20.4775	0.987894736842105	22.1126315789474	0.722599999999147	367.070007
63	1991-03-01	363.39	19.9015	1.007	19.0410526315789	0.781800000000658	375.220001
64	1991-04-01	358.054761904762	20.83	1.09090909090909	18.9272727272727	0.826699999999619	375.339996
65	1991-05-01	357.116666666667	21.2322727272727	1.28409090909091	17.1804545454545	0.83389999999963	389.829987
66	1991-06-01	366.36	20.189	1.328	17.575	0.868700000000899	371.160004
67	1991-07-01	368.013043478261	21.4030434782609	1.355	17.6695454545455	0.870699999999488	387.809998
68	1991-08-01	356.721428571429	21.6936363636364	1.46681818181818	15.9327272727273	0.850300000000061	395.429993
69	1991-09-01	348.459523809524	21.8865	1.4685	17.029	0.828100000000632	387.859985
70	1991-10-01	358.826086956522	23.2308695652174	1.615	16.8463636363636	0.82550000000083	392.450012
71	1991-11-01	359.959523809524	22.4609523809524	1.85842105263158	17.6815	0.795000000000073	375.220001
72	1991-12-01	361.875	19.4980952380952	2.06285714285714	18.0185714285714	0.768099999999322	417.089996
73	1992-01-01	354.436363636364	18.7854545454545	2.07428571428571	17.4995454545455	0.770599999999831	408.779999
74	1992-02-01	353.8525	19.0125	2.12578947368421	17.0505263157895	0.791999999999462	412.700012
75	1992-03-01	344.640909090909	18.9218181818182	1.85727272727273	16.2227272727273	0.812700000000404	403.690002
76	1992-04-01	338.7275	20.23	2.13619047619048	16.1885714285714	0.804899999999179	414.950012
77	1992-05-01	337.039473684211	20.9755	2.1665	14.728	0.78859999999986	415.350006
78	1992-06-01	340.784090909091	22.3845454545455	2.21363636363636	14.7531818181818	0.767900000000736	408.140015
79	1992-07-01	352.452173913043	21.7752173913043	2.48909090909091	13.3036363636364	0.729799999999159	424.209991
80	1992-08-01	343.6025	21.3390476190476	2.39285714285714	14.422380952381	0.71349999999984	414.029999
81	1992-09-01	345.3	21.8813636363636	2.52095238095238	14.2585714285714	0.721999999999753	417.799988
82	1992-10-01	344.277272727273	21.6859090909091	2.50619047619048	17.4786363636364	0.755199999999604	418.679993
83	1992-11-01	334.923809523809	20.3385	2.29368421052632	14.594	0.807199999999284	431.350006
84	1992-12-01	334.657142857143	19.4140909090909	2.09636363636364	12.7813636363636	0.807199999999284	435.709991
85	1993-01-01	328.9925	19.032	2.21	12.584	0.825000000000728	438.779999
86	1993-02-01	329.31	20.0861111111111	2.16052631578947	13.6247368421053	0.845300000000861	443.380005
87	1993-03-01	329.973913043478	20.3221739130435	2.02565217391304	13.6930434782609	0.848400000000766	451.670013
88	1993-04-01	341.9475	20.2525	2.13190476190476	13.4566666666667	0.820100000000821	440.190002
89	1993-05-01	367.044736842105	19.9495	2.0585	13.4855	0.821200000000317	450.190002
90	1993-06-01	371.913636363636	19.0940909090909	1.79909090909091	12.9731818181818	0.844300000000658	450.529999
91	1993-07-01	392.034090909091	17.89	1.73333333333333	11.8695	0.878399999999601	448.130005
92	1993-08-01	379.795238095238	18.0109090909091	1.67636363636364	11.9531818181818	0.882400000000416	463.559998
93	1993-09-01	355.561363636364	17.5042857142857	1.51285714285714	12.649	0.848200000000361	458.929993
94	1993-10-01	364.004761904762	18.1533333333333	1.4595	11.3752380952381	0.859300000000076	467.829987
95	1993-11-01	373.938636363636	16.6090476190476	1.5685	13.3709523809524	0.885800000000018	461.790009
96	1993-12-01	383.242857142857	14.5147619047619	1.56181818181818	10.8645454545455	0.885800000000018	466.450012
97	1994-01-01	387.11	15.0266666666667	1.6105	10.6052380952381	0.897499999999127	481.609985
98	1994-02-01	381.6575	14.7810526315789	1.49894736842105	12.8852631578947	0.894800000000032	467.140015
99	1994-03-01	384.0	14.6808695652174	1.48739130434783	14.2408695652174	0.876000000000204	445.769989
100	1994-04-01	377.907894736842	16.42	1.42263157894737	15.3347368421053	0.877300000000105	450.910004

Rows: 1-100 | Columns: 7