load_pop_growth

In [ ]:
load_pop_growth(cursor = None, 
                schema: str = 'public',
                name: str = 'pop_growth')

Ingests the population growth dataset into the Vertica database. This dataset is ideal for time series and geospatial 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 pop growth vDataFrame.

Example

In [35]:
from verticapy.datasets import load_pop_growth
load_pop_growth()
Out[35]:
123
year
Int
Abc
continent
Varchar(100)
Abc
country
Varchar(100)
Abc
city
Varchar(100)
123
population
Float
🌎
lat
Float
🌎
lon
Float
11500AsiaChinaBeijing672.039.9075116.39723
21500AsiaChinaGuangzhou150.023.11667113.25
31500AsiaChinaHangzhou250.030.25120.16
41500AsiaChinaNanjing147.032.05118.766667
51500AsiaIndiaCuttack140.020.4649785.87927
61500AsiaIndiaGauda200.024.86666788.133333
71500AsiaIndiaVijayanagar500.015.33576.462
81500EuropeFranceParis185.048.853412.3488
91500EuropeTurkeyIstanbul200.041.00527528.9497
101500Middle EastEgyptCairo400.030.0431.24
111500Middle EastIranTabriz250.038.0846.2919
121500Middle EastMoroccoFez130.034.033333-5.01
131501AsiaChinaBeijing672.3639.9075116.39723
141501AsiaChinaGuangzhou150.223.11667113.25
151501AsiaChinaHangzhou250.230.25120.16
161501AsiaChinaNanjing147.00086666666732.05118.766667
171501AsiaIndiaCuttack139.020.4649785.87927
181501AsiaIndiaGauda200.024.86666788.133333
191501AsiaIndiaVijayanagar499.615.33576.462
201501EuropeFranceParis185.548.853412.3488
211501EuropeTurkeyIstanbul205.041.00527528.9497
221501Middle EastEgyptCairo399.230.0431.24
231501Middle EastIranTabriz248.038.0846.2919
241501Middle EastMoroccoFez130.07692307692334.033333-5.01
251502AsiaChinaBeijing672.7239.9075116.39723
261502AsiaChinaGuangzhou150.423.11667113.25
271502AsiaChinaHangzhou250.430.25120.16
281502AsiaChinaNanjing147.00173333333332.05118.766667
291502AsiaIndiaCuttack138.020.4649785.87927
301502AsiaIndiaGauda200.024.86666788.133333
311502AsiaIndiaVijayanagar499.215.33576.462
321502EuropeFranceParis186.048.853412.3488
331502EuropeTurkeyIstanbul210.041.00527528.9497
341502Middle EastEgyptCairo398.430.0431.24
351502Middle EastIranTabriz246.038.0846.2919
361502Middle EastMoroccoFez130.15384615384634.033333-5.01
371503AsiaChinaBeijing673.0839.9075116.39723
381503AsiaChinaGuangzhou150.623.11667113.25
391503AsiaChinaHangzhou250.630.25120.16
401503AsiaChinaNanjing147.002632.05118.766667
411503AsiaIndiaCuttack137.020.4649785.87927
421503AsiaIndiaGauda200.024.86666788.133333
431503AsiaIndiaVijayanagar498.815.33576.462
441503EuropeFranceParis186.548.853412.3488
451503EuropeTurkeyIstanbul215.041.00527528.9497
461503Middle EastEgyptCairo397.630.0431.24
471503Middle EastIranTabriz244.038.0846.2919
481503Middle EastMoroccoFez130.23076923076934.033333-5.01
491504AsiaChinaBeijing673.4439.9075116.39723
501504AsiaChinaGuangzhou150.823.11667113.25
511504AsiaChinaHangzhou250.830.25120.16
521504AsiaChinaNanjing147.00346666666732.05118.766667
531504AsiaIndiaCuttack136.020.4649785.87927
541504AsiaIndiaGauda200.024.86666788.133333
551504AsiaIndiaVijayanagar498.415.33576.462
561504EuropeFranceParis187.048.853412.3488
571504EuropeTurkeyIstanbul220.041.00527528.9497
581504Middle EastEgyptCairo396.830.0431.24
591504Middle EastIranTabriz242.038.0846.2919
601504Middle EastMoroccoFez130.30769230769234.033333-5.01
611505AsiaChinaBeijing673.839.9075116.39723
621505AsiaChinaGuangzhou151.023.11667113.25
631505AsiaChinaHangzhou251.030.25120.16
641505AsiaChinaNanjing147.00433333333332.05118.766667
651505AsiaIndiaCuttack135.020.4649785.87927
661505AsiaIndiaGauda200.024.86666788.133333
671505AsiaIndiaVijayanagar498.015.33576.462
681505EuropeFranceParis187.548.853412.3488
691505EuropeTurkeyIstanbul225.041.00527528.9497
701505Middle EastEgyptCairo396.030.0431.24
711505Middle EastIranTabriz240.038.0846.2919
721505Middle EastMoroccoFez130.38461538461534.033333-5.01
731506AsiaChinaBeijing674.1639.9075116.39723
741506AsiaChinaGuangzhou151.223.11667113.25
751506AsiaChinaHangzhou251.230.25120.16
761506AsiaChinaNanjing147.005232.05118.766667
771506AsiaIndiaCuttack134.020.4649785.87927
781506AsiaIndiaGauda200.024.86666788.133333
791506AsiaIndiaVijayanagar497.615.33576.462
801506EuropeFranceParis188.048.853412.3488
811506EuropeTurkeyIstanbul230.041.00527528.9497
821506Middle EastEgyptCairo395.230.0431.24
831506Middle EastIranTabriz238.038.0846.2919
841506Middle EastMoroccoFez130.46153846153834.033333-5.01
851507AsiaChinaBeijing674.5239.9075116.39723
861507AsiaChinaGuangzhou151.423.11667113.25
871507AsiaChinaHangzhou251.430.25120.16
881507AsiaChinaNanjing147.00606666666732.05118.766667
891507AsiaIndiaCuttack133.020.4649785.87927
901507AsiaIndiaGauda200.024.86666788.133333
911507AsiaIndiaVijayanagar497.215.33576.462
921507EuropeFranceParis188.548.853412.3488
931507EuropeTurkeyEdirne130.6441.68180826.562269
941507EuropeTurkeyIstanbul235.041.00527528.9497
951507Middle EastEgyptCairo394.430.0431.24
961507Middle EastIranTabriz236.038.0846.2919
971508AsiaChinaBeijing674.8839.9075116.39723
981508AsiaChinaGuangzhou151.623.11667113.25
991508AsiaChinaHangzhou251.630.25120.16
1001508AsiaChinaNanjing147.00693333333332.05118.766667
Rows: 1-100 | Columns: 7