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
1	Afghanistan	1952	8425333	Asia	28.801	779.4453145
2	Afghanistan	1957	9240934	Asia	30.332	820.8530296
3	Afghanistan	1962	10267083	Asia	31.997	853.10071
4	Afghanistan	1967	11537966	Asia	34.02	836.1971382
5	Afghanistan	1972	13079460	Asia	36.088	739.9811058
6	Afghanistan	1977	14880372	Asia	38.438	786.11336
7	Afghanistan	1982	12881816	Asia	39.854	978.0114388
8	Afghanistan	1987	13867957	Asia	40.822	852.3959448
9	Afghanistan	1992	16317921	Asia	41.674	649.3413952
10	Afghanistan	1997	22227415	Asia	41.763	635.341351
11	Afghanistan	2002	25268405	Asia	42.129	726.7340548
12	Afghanistan	2007	31889923	Asia	43.828	974.5803384
13	Albania	1952	1282697	Europe	55.23	1601.056136
14	Albania	1957	1476505	Europe	59.28	1942.284244
15	Albania	1962	1728137	Europe	64.82	2312.888958
16	Albania	1967	1984060	Europe	66.22	2760.196931
17	Albania	1972	2263554	Europe	67.69	3313.422188
18	Albania	1977	2509048	Europe	68.93	3533.00391
19	Albania	1982	2780097	Europe	70.42	3630.880722
20	Albania	1987	3075321	Europe	72.0	3738.932735
21	Albania	1992	3326498	Europe	71.581	2497.437901
22	Albania	1997	3428038	Europe	72.95	3193.054604
23	Albania	2002	3508512	Europe	75.651	4604.211737
24	Albania	2007	3600523	Europe	76.423	5937.029526
25	Algeria	1952	9279525	Africa	43.077	2449.008185
26	Algeria	1957	10270856	Africa	45.685	3013.976023
27	Algeria	1962	11000948	Africa	48.303	2550.81688
28	Algeria	1967	12760499	Africa	51.407	3246.991771
29	Algeria	1972	14760787	Africa	54.518	4182.663766
30	Algeria	1977	17152804	Africa	58.014	4910.416756
31	Algeria	1982	20033753	Africa	61.368	5745.160213
32	Algeria	1987	23254956	Africa	65.799	5681.358539
33	Algeria	1992	26298373	Africa	67.744	5023.216647
34	Algeria	1997	29072015	Africa	69.152	4797.295051
35	Algeria	2002	31287142	Africa	70.994	5288.040382
36	Algeria	2007	33333216	Africa	72.301	6223.367465
37	Angola	1952	4232095	Africa	30.015	3520.610273
38	Angola	1957	4561361	Africa	31.999	3827.940465
39	Angola	1962	4826015	Africa	34.0	4269.276742
40	Angola	1967	5247469	Africa	35.985	5522.776375
41	Angola	1972	5894858	Africa	37.928	5473.288005
42	Angola	1977	6162675	Africa	39.483	3008.647355
43	Angola	1982	7016384	Africa	39.942	2756.953672
44	Angola	1987	7874230	Africa	39.906	2430.208311
45	Angola	1992	8735988	Africa	40.647	2627.845685
46	Angola	1997	9875024	Africa	40.963	2277.140884
47	Angola	2002	10866106	Africa	41.003	2773.287312
48	Angola	2007	12420476	Africa	42.731	4797.231267
49	Argentina	1952	17876956	Americas	62.485	5911.315053
50	Argentina	1957	19610538	Americas	64.399	6856.856212
51	Argentina	1962	21283783	Americas	65.142	7133.166023
52	Argentina	1967	22934225	Americas	65.634	8052.953021
53	Argentina	1972	24779799	Americas	67.065	9443.038526
54	Argentina	1977	26983828	Americas	68.481	10079.02674
55	Argentina	1982	29341374	Americas	69.942	8997.897412
56	Argentina	1987	31620918	Americas	70.774	9139.671389
57	Argentina	1992	33958947	Americas	71.868	9308.41871
58	Argentina	1997	36203463	Americas	73.275	10967.28195
59	Argentina	2002	38331121	Americas	74.34	8797.640716
60	Argentina	2007	40301927	Americas	75.32	12779.37964
61	Australia	1952	8691212	Oceania	69.12	10039.59564
62	Australia	1957	9712569	Oceania	70.33	10949.64959
63	Australia	1962	10794968	Oceania	70.93	12217.22686
64	Australia	1967	11872264	Oceania	71.1	14526.12465
65	Australia	1972	13177000	Oceania	71.93	16788.62948
66	Australia	1977	14074100	Oceania	73.49	18334.19751
67	Australia	1982	15184200	Oceania	74.74	19477.00928
68	Australia	1987	16257249	Oceania	76.32	21888.88903
69	Australia	1992	17481977	Oceania	77.56	23424.76683
70	Australia	1997	18565243	Oceania	78.83	26997.93657
71	Australia	2002	19546792	Oceania	80.37	30687.75473
72	Australia	2007	20434176	Oceania	81.235	34435.36744
73	Austria	1952	6927772	Europe	66.8	6137.076492
74	Austria	1957	6965860	Europe	67.48	8842.59803
75	Austria	1962	7129864	Europe	69.54	10750.72111
76	Austria	1967	7376998	Europe	70.14	12834.6024
77	Austria	1972	7544201	Europe	70.63	16661.6256
78	Austria	1977	7568430	Europe	72.17	19749.4223
79	Austria	1982	7574613	Europe	73.18	21597.08362
80	Austria	1987	7578903	Europe	74.94	23687.82607
81	Austria	1992	7914969	Europe	76.04	27042.01868
82	Austria	1997	8069876	Europe	77.51	29095.92066
83	Austria	2002	8148312	Europe	78.98	32417.60769
84	Austria	2007	8199783	Europe	79.829	36126.4927
85	Bahrain	1952	120447	Asia	50.939	9867.084765
86	Bahrain	1957	138655	Asia	53.832	11635.79945
87	Bahrain	1962	171863	Asia	56.923	12753.27514
88	Bahrain	1967	202182	Asia	59.923	14804.6727
89	Bahrain	1972	230800	Asia	63.3	18268.65839
90	Bahrain	1977	297410	Asia	65.593	19340.10196
91	Bahrain	1982	377967	Asia	69.052	19211.14731
92	Bahrain	1987	454612	Asia	70.75	18524.02406
93	Bahrain	1992	529491	Asia	72.601	19035.57917
94	Bahrain	1997	598561	Asia	73.925	20292.01679
95	Bahrain	2002	656397	Asia	74.795	23403.55927
96	Bahrain	2007	708573	Asia	75.635	29796.04834
97	Bangladesh	1952	46886859	Asia	37.484	684.2441716
98	Bangladesh	1957	51365468	Asia	39.348	661.6374577
99	Bangladesh	1962	56839289	Asia	41.216	686.3415538
100	Bangladesh	1967	62821884	Asia	43.453	721.1860862

Rows: 1-100 | Columns: 6