verticapy.datasets.load_commodities¶
- verticapy.datasets.load_commodities(schema: str | None = None, name: str = 'commodities') vDataFrame¶
Ingests the commodities dataset into the Vertica database. This dataset is ideal for time series and regression models. If a table with the same name and schema already exists, this function creates a vDataFrame from the input relation.
Parameters¶
- schema: str, optional
Schema of the new relation. If empty, the temporary schema is used.
- name: str, optional
Name of the new relation.
Returns¶
- vDataFrame
the commodities vDataFrame.
Examples¶
If you call this loader without any arguments, the dataset is loaded using the default schema (public).
from verticapy.datasets import load_commodities load_commodities()
📅date123Gold123Oil123Spread123Vix123Dol_Eur123SP5001 1986-11-01 396.9825 15.2215789473684 0.973888888888889 18.6315789473684 0.967399999999543 249.220001 2 1987-02-01 401.045 17.7489473684211 0.852631578947368 23.4463157894737 0.882600000000821 284.200012 3 1987-05-01 461.65 19.4375 0.8515 25.4115 0.861100000000079 290.100006 4 1987-08-01 460.9875 20.3109523809524 1.00761904761905 20.8490476190476 0.89600000000064 329.799988 5 1987-10-01 465.763636363636 19.8590909090909 1.12238095238095 58.2195454545455 0.868599999999788 251.789993 6 1987-12-01 487.078571428571 17.2745454545455 1.13 41.7640909090909 0.791400000000067 247.080002 7 1988-02-01 442.12380952381 16.7957142857143 1.0315 33.674 0.822000000000116 267.820007 8 1988-03-01 443.491304347826 16.1973913043478 1.10304347826087 29.3569565217391 0.810900000000402 258.890015 9 1988-09-01 413.438636363636 14.5354545454545 0.513809523809524 19.5242857142857 0.900299999999334 271.910004 10 1988-11-01 419.965909090909 14.1413636363636 0.2965 21.6590476190476 0.844499999999243 273.700012 11 1989-02-01 387.9725 17.9365 -0.202631578947368 18.3126315789474 0.888899999999921 288.859985 12 1989-06-01 367.727272727273 20.0504545454545 -0.129090909090909 16.7322727272727 0.955400000000736 317.980011 13 1989-07-01 375.209523809524 19.7814285714286 0.199 18.0565 0.914000000000669 346.079987 14 1989-11-01 394.361363636364 19.8559090909091 0.0785714285714286 20.932380952381 0.893899999999121 345.98999 15 1989-12-01 409.655263157895 21.1 0.059 18.235 0.856499999999869 353.399994 16 1990-02-01 416.5425 22.113 0.102631578947368 23.3268421052632 0.820799999999508 331.890015 17 1990-10-01 381.332608695652 36.0395652173913 0.841818181818182 30.1304347826087 0.739799999999377 304.0 18 1991-01-01 384.590909090909 25.2340909090909 0.967619047619048 26.9318181818182 0.736699999999473 343.929993 19 1991-04-01 358.054761904762 20.83 1.09090909090909 18.9272727272727 0.826699999999619 375.339996 20 1991-05-01 357.116666666667 21.2322727272727 1.28409090909091 17.1804545454545 0.83389999999963 389.829987 21 1992-03-01 344.640909090909 18.9218181818182 1.85727272727273 16.2227272727273 0.812700000000404 403.690002 22 1992-05-01 337.039473684211 20.9755 2.1665 14.728 0.78859999999986 415.350006 23 1992-07-01 352.452173913043 21.7752173913043 2.48909090909091 13.3036363636364 0.729799999999159 424.209991 24 1992-10-01 344.277272727273 21.6859090909091 2.50619047619048 17.4786363636364 0.755199999999604 418.679993 25 1992-11-01 334.923809523809 20.3385 2.29368421052632 14.594 0.807199999999284 431.350006 26 1992-12-01 334.657142857143 19.4140909090909 2.09636363636364 12.7813636363636 0.807199999999284 435.709991 27 1993-03-01 329.973913043478 20.3221739130435 2.02565217391304 13.6930434782609 0.848400000000766 451.670013 28 1993-04-01 341.9475 20.2525 2.13190476190476 13.4566666666667 0.820100000000821 440.190002 29 1993-05-01 367.044736842105 19.9495 2.0585 13.4855 0.821200000000317 450.190002 30 1993-06-01 371.913636363636 19.0940909090909 1.79909090909091 12.9731818181818 0.844300000000658 450.529999 31 1993-08-01 379.795238095238 18.0109090909091 1.67636363636364 11.9531818181818 0.882400000000416 463.559998 32 1994-04-01 377.907894736842 16.42 1.42263157894737 15.3347368421053 0.877300000000105 450.910004 33 1994-06-01 385.713636363636 19.06 1.17 12.9459090909091 0.845699999999852 444.269989 34 1994-07-01 385.45 19.6545 1.168 12.1635 0.818499999999404 458.26001 35 1995-07-01 386.138095238095 17.3255 0.498 14.0765 0.743437999999514 562.059998 36 1996-03-01 396.511904761905 21.332380952381 0.607619047619048 19.0819047619048 0.780428570000368 645.5 37 1996-06-01 385.245 20.4235 0.615 17.6755 0.797715009999592 670.630005 38 1996-11-01 377.869047619048 23.705 0.502105263157895 17.164 0.78265237999949 757.02002 39 1996-12-01 369.3375 25.2285714285714 0.52047619047619 20.1135 0.799684999999954 740.73999 40 1997-01-01 355.025 25.1318181818182 0.570952380952381 21.0313636363636 0.822170909999841 786.159973 41 1998-03-01 295.870454545455 15.1154545454545 0.0859090909090909 20.5431818181818 0.922254549999707 1101.75 42 1998-04-01 308.5575 15.3538095238095 0.0733333333333333 22.5380952380952 0.916540000000168 1111.75 43 1998-08-01 284.2275 13.4719047619048 0.0733333333333333 31.4885714285714 0.90782380952381 957.280029 44 1998-10-01 296.595454545455 14.4609090909091 0.438095238095238 37.4540909090909 0.838318181818182 1098.670044 45 1999-07-01 256.197727272727 20.1033333333333 0.237142857142857 21.4866666666667 0.966225199954545 1328.719971 46 1999-08-01 256.935714285714 21.2786363636364 0.260909090909091 24.8722727272727 0.9435675375 1320.410034 47 2000-06-01 285.368181818182 31.8222727272727 -0.384545454545455 24.3177272727273 1.05298371918182 1454.599976 48 2000-09-01 273.67619047619 33.884 -0.2825 22.3365 1.14839744757143 1436.51001 49 2000-12-01 271.892105263158 28.4365 -0.1115 30.1045 1.11084724065 1320.280029 50 2001-02-01 262.0175 29.6094736842105 0.442105263157895 26.1594736842105 1.0853814393 1239.939941 51 2001-04-01 260.75 27.49 0.907 32.245 1.118874966 1249.459961 52 2001-05-01 272.057142857143 28.6290909090909 1.13136363636364 26.095 1.143491682 1255.819946 53 2001-07-01 267.706818181818 26.4247619047619 1.19761904761905 24.8590476190476 1.16093285659091 1211.22998 54 2001-09-01 282.4775 26.1994736842105 1.61294117647059 38.5513333333333 1.09583135555 1040.939941 55 2002-08-01 310.045238095238 28.385 2.12363636363636 37.2527272727273 1.02246676136364 916.070007 56 2002-10-01 316.747826086957 28.8365217391304 2.02909090909091 41.3973913043478 1.01855763682609 885.76001 57 2003-05-01 355.405 28.1085714285714 2.15380952380952 22.5485714285714 0.864283957363636 963.590027 58 2003-09-01 378.859090909091 28.3114285714286 2.56809523809524 20.682380952381 0.888519456863636 995.969971 59 2004-05-01 383.952631578947 40.275 2.182 18.076 0.832421512904762 1120.680054 60 2005-02-01 423.43 48.1489473684211 0.780526315789474 11.5626315789474 0.76765133505 1203.599976 61 2005-04-01 429.140476190476 52.9790476190476 0.687142857142857 14.0571428571429 0.772679617285714 1156.849976 62 2005-08-01 437.772727272727 64.9852173913043 0.218260869565217 11.9852173913043 0.813393210130435 1220.329956 63 2005-11-01 476.668181818182 58.3225 0.1185 11.6061904761905 0.847904099363636 1249.47998 64 2006-05-01 676.769047619048 70.8440909090909 0.141818181818182 13.4881818181818 0.782905714217391 1270.089966 65 2006-08-01 631.556818181818 73.0430434782609 -0.0269565217391304 12.5604347826087 0.780600743304348 1303.819946 66 2006-09-01 600.15 63.798 -0.05 11.397 0.785348418952381 1335.849976 67 2007-09-01 710.645 79.9147368421053 0.51 22.1821052631579 0.71884956405 1526.75 68 2007-12-01 803.618421052632 91.687 0.9805 23.0965 0.68677322555 1468.359985 69 2008-03-01 971.055263157895 105.454 1.893 29.009 0.644097590571429 1322.699951 70 2008-04-01 911.6 112.580454545455 1.62772727272727 22.5268181818182 0.635092953636364 1385.589966 71 2008-05-01 889.125 125.397619047619 1.43428571428571 18.7919047619048 0.642545454545455 1400.380005 72 2008-10-01 812.815217391304 76.6086956521739 2.20181818181818 65.4465217391304 0.753347826086956 968.75 73 2009-07-01 934.271739130435 64.1522727272727 2.54318181818182 25.9245454545455 0.709826086956522 987.47998 74 2009-11-01 1126.11904761905 77.99 2.59947368421053 22.57 0.670233333333333 1095.630005 75 2010-03-01 1115.55434782609 81.2034782608696 2.76869565217391 16.9252173913043 0.737 1169.430054 76 2010-05-01 1204.32105263158 73.7435 2.5895 30.0335 0.795428571428571 1089.410034 77 2010-06-01 1232.38181818182 75.3359090909091 2.47954545454545 28.9409090909091 0.818954545454545 1030.709961 78 2010-09-01 1271.46136363636 75.2419047619048 2.16761904761905 21.322380952381 0.763909090909091 1141.199951 79 2011-03-01 1422.84782608696 102.85652173913 2.71695652173913 19.8934782608696 0.713565217391304 1325.829956 80 2011-04-01 1474.43055555556 109.5325 2.7205 15.208 0.691714285714286 1363.609985 81 2012-04-01 1648.53947368421 103.321 1.76095238095238 17.177 0.759952380952381 1397.910034 82 2012-08-01 1625.68181818182 94.1313043478261 1.4095652173913 14.9691304347826 0.806173913043478 1406.579956 83 2012-10-01 1746.34782608696 89.4913043478261 1.46904761904762 15.4690476190476 0.770608695652174 1412.160034 84 2013-01-01 1671.88636363636 94.7566666666667 1.64952380952381 13.1219047619048 0.752 1498.109985 85 2013-02-01 1630.6875 95.3089473684211 1.71684210526316 13.5121052631579 0.74955 1514.680054 86 2013-03-01 1591.0125 92.9385 1.7015 12.3915 0.772047619047619 1569.189941 87 2013-05-01 1416.14285714286 94.5095454545455 1.67772727272727 12.9140909090909 0.770714285714286 1630.73999 88 2013-10-01 1314.40217391304 100.538260869565 2.28045454545455 14.3230434782609 0.733005652173913 1756.540039 89 2014-02-01 1298.7125 100.817368421053 2.38263157894737 14.1794736842105 0.731746 1859.449951 90 2014-04-01 1299.175 102.069047619048 2.28809523809524 13.4852380952381 0.724089090909091 1883.949951 91 2014-05-01 1288.9125 102.177142857143 2.17 11.7614285714286 0.728108181818182 1923.569946 92 2014-08-01 1297.005 96.5361904761905 1.94761904761905 12.4147619047619 0.75092 2003.369995 93 2014-10-01 1223.5652173913 84.3969565217391 1.85863636363636 16.9113043478261 0.789044347826087 2018.050049 94 2014-11-01 1176.4125 75.7894736842105 1.79833333333333 12.2436842105263 0.801368 2067.560059 95 2015-02-01 1231.1 50.5842105263158 1.35631578947368 15.3210526315789 0.880563 2104.5 96 2015-05-01 1197.68421052632 59.265 1.5885 13.6325 0.896117142857143 2107.389893 97 2015-08-01 1117.525 42.867619047619 1.46952380952381 19.5880952380952 0.898364761904762 1972.180054 98 2015-09-01 1124.90454545455 45.4795238095238 1.45952380952381 24.6042857142857 0.891428636363636 1920.030029 99 2016-04-01 1241.45238095238 40.7552380952381 1.03714285714286 14.3471428571429 0.881817619047619 2065.300049 100 2016-11-01 1240.29318181818 45.6609523809524 1.1625 15.3395238095238 0.927670454545454 2198.810059 Rows: 1-100 | Columns: 7