load_gapminder

In [ ]:
load_gapminder(cursor = None, 
               schema: str = 'public',
               name: str = 'gapminder')

Ingests the gapminder 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 will create a vDataFrame from the input relation.

Parameters

Name Type Optional Description
cursor
DBcursor
Vertica DB cursor.
schema
str
Schema of the new relation. The default schema is public.
name
str
Name of the new relation.

Returns

vDataFrame : the gapminder vDataFrame.

Example

In [36]:
from verticapy.datasets import load_gapminder
load_gapminder()
Out[36]:
Abc
country
Varchar(96)
123
year
Int
123
pop
Int
Abc
continent
Varchar(52)
123
lifeExp
Float
123
gdpPercap
Float
1Afghanistan19528425333Asia28.801779.4453145
2Afghanistan19579240934Asia30.332820.8530296
3Afghanistan196210267083Asia31.997853.10071
4Afghanistan196711537966Asia34.02836.1971382
5Afghanistan197213079460Asia36.088739.9811058
6Afghanistan197714880372Asia38.438786.11336
7Afghanistan198212881816Asia39.854978.0114388
8Afghanistan198713867957Asia40.822852.3959448
9Afghanistan199216317921Asia41.674649.3413952
10Afghanistan199722227415Asia41.763635.341351
11Afghanistan200225268405Asia42.129726.7340548
12Afghanistan200731889923Asia43.828974.5803384
13Albania19521282697Europe55.231601.056136
14Albania19571476505Europe59.281942.284244
15Albania19621728137Europe64.822312.888958
16Albania19671984060Europe66.222760.196931
17Albania19722263554Europe67.693313.422188
18Albania19772509048Europe68.933533.00391
19Albania19822780097Europe70.423630.880722
20Albania19873075321Europe72.03738.932735
21Albania19923326498Europe71.5812497.437901
22Albania19973428038Europe72.953193.054604
23Albania20023508512Europe75.6514604.211737
24Albania20073600523Europe76.4235937.029526
25Algeria19529279525Africa43.0772449.008185
26Algeria195710270856Africa45.6853013.976023
27Algeria196211000948Africa48.3032550.81688
28Algeria196712760499Africa51.4073246.991771
29Algeria197214760787Africa54.5184182.663766
30Algeria197717152804Africa58.0144910.416756
31Algeria198220033753Africa61.3685745.160213
32Algeria198723254956Africa65.7995681.358539
33Algeria199226298373Africa67.7445023.216647
34Algeria199729072015Africa69.1524797.295051
35Algeria200231287142Africa70.9945288.040382
36Algeria200733333216Africa72.3016223.367465
37Angola19524232095Africa30.0153520.610273
38Angola19574561361Africa31.9993827.940465
39Angola19624826015Africa34.04269.276742
40Angola19675247469Africa35.9855522.776375
41Angola19725894858Africa37.9285473.288005
42Angola19776162675Africa39.4833008.647355
43Angola19827016384Africa39.9422756.953672
44Angola19877874230Africa39.9062430.208311
45Angola19928735988Africa40.6472627.845685
46Angola19979875024Africa40.9632277.140884
47Angola200210866106Africa41.0032773.287312
48Angola200712420476Africa42.7314797.231267
49Argentina195217876956Americas62.4855911.315053
50Argentina195719610538Americas64.3996856.856212
51Argentina196221283783Americas65.1427133.166023
52Argentina196722934225Americas65.6348052.953021
53Argentina197224779799Americas67.0659443.038526
54Argentina197726983828Americas68.48110079.02674
55Argentina198229341374Americas69.9428997.897412
56Argentina198731620918Americas70.7749139.671389
57Argentina199233958947Americas71.8689308.41871
58Argentina199736203463Americas73.27510967.28195
59Argentina200238331121Americas74.348797.640716
60Argentina200740301927Americas75.3212779.37964
61Australia19528691212Oceania69.1210039.59564
62Australia19579712569Oceania70.3310949.64959
63Australia196210794968Oceania70.9312217.22686
64Australia196711872264Oceania71.114526.12465
65Australia197213177000Oceania71.9316788.62948
66Australia197714074100Oceania73.4918334.19751
67Australia198215184200Oceania74.7419477.00928
68Australia198716257249Oceania76.3221888.88903
69Australia199217481977Oceania77.5623424.76683
70Australia199718565243Oceania78.8326997.93657
71Australia200219546792Oceania80.3730687.75473
72Australia200720434176Oceania81.23534435.36744
73Austria19526927772Europe66.86137.076492
74Austria19576965860Europe67.488842.59803
75Austria19627129864Europe69.5410750.72111
76Austria19677376998Europe70.1412834.6024
77Austria19727544201Europe70.6316661.6256
78Austria19777568430Europe72.1719749.4223
79Austria19827574613Europe73.1821597.08362
80Austria19877578903Europe74.9423687.82607
81Austria19927914969Europe76.0427042.01868
82Austria19978069876Europe77.5129095.92066
83Austria20028148312Europe78.9832417.60769
84Austria20078199783Europe79.82936126.4927
85Bahrain1952120447Asia50.9399867.084765
86Bahrain1957138655Asia53.83211635.79945
87Bahrain1962171863Asia56.92312753.27514
88Bahrain1967202182Asia59.92314804.6727
89Bahrain1972230800Asia63.318268.65839
90Bahrain1977297410Asia65.59319340.10196
91Bahrain1982377967Asia69.05219211.14731
92Bahrain1987454612Asia70.7518524.02406
93Bahrain1992529491Asia72.60119035.57917
94Bahrain1997598561Asia73.92520292.01679
95Bahrain2002656397Asia74.79523403.55927
96Bahrain2007708573Asia75.63529796.04834
97Bangladesh195246886859Asia37.484684.2441716
98Bangladesh195751365468Asia39.348661.6374577
99Bangladesh196256839289Asia41.216686.3415538
100Bangladesh196762821884Asia43.453721.1860862
Rows: 1-100 | Columns: 6