Loading...

verticapy.datasets.load_pop_growth

verticapy.datasets.load_pop_growth(schema: str | None = None, name: str = 'pop_growth') → vDataFrame

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 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 pop growth vDataFrame.

Examples

If you call this loader without any arguments, the dataset is loaded using the default schema (public).

from verticapy.datasets import load_pop_growth

load_pop_growth()
123
year
Integer
Abc
continent
Varchar(100)
Abc
country
Varchar(100)
Abc
city
Varchar(100)
123
population
Float(22)
🌎
lat
Float(22)
🌎
lon
Float(22)
11500AsiaChinaHangzhou250.030.25120.16
21500EuropeFranceParis185.048.853412.3488
31500Middle EastEgyptCairo400.030.0431.24
41501AsiaChinaGuangzhou150.223.11667113.25
51501AsiaChinaHangzhou250.230.25120.16
61502AsiaIndiaGauda200.024.86666788.133333
71502Middle EastIranTabriz246.038.0846.2919
81503AsiaChinaGuangzhou150.623.11667113.25
91503AsiaChinaNanjing147.002632.05118.766667
101503EuropeFranceParis186.548.853412.3488
111503Middle EastMoroccoFez130.23076923076934.033333-5.01
121504AsiaChinaGuangzhou150.823.11667113.25
131504Middle EastIranTabriz242.038.0846.2919
141504Middle EastMoroccoFez130.30769230769234.033333-5.01
151505AsiaChinaBeijing673.839.9075116.39723
161505AsiaChinaGuangzhou151.023.11667113.25
171505Middle EastEgyptCairo396.030.0431.24
181506AsiaIndiaVijayanagar497.615.33576.462
191506Middle EastMoroccoFez130.46153846153834.033333-5.01
201507AsiaChinaNanjing147.00606666666732.05118.766667
211508AsiaChinaNanjing147.00693333333332.05118.766667
221508AsiaIndiaGauda200.024.86666788.133333
231508Middle EastIranTabriz234.038.0846.2919
241509AsiaChinaBeijing675.2439.9075116.39723
251509AsiaChinaHangzhou251.830.25120.16
261509AsiaChinaSuzhou131.81818181818231.3120.59
271509EuropeFranceParis189.548.853412.3488
281509Middle EastIranTabriz232.038.0846.2919
291510AsiaIndiaVijayanagar496.015.33576.462
301511AsiaChinaHangzhou252.230.25120.16
311511AsiaChinaNanjing147.00953333333332.05118.766667
321511AsiaChinaSuzhou134.031.3120.59
331511Middle EastEgyptCairo391.230.0431.24
341512AsiaChinaSuzhou135.09090909090931.3120.59
351512AsiaIndiaVijayanagar495.215.33576.462
361512EuropeFranceParis191.048.853412.3488
371512Middle EastIranTabriz226.038.0846.2919
381513AsiaChinaBeijing676.6839.9075116.39723
391513AsiaChinaGuangzhou152.623.11667113.25
401513AsiaChinaHangzhou252.630.25120.16
411513EuropeTurkeyIstanbul280.041.00527528.9497
421514AsiaChinaGuangzhou152.823.11667113.25
431514AsiaChinaHangzhou252.830.25120.16
441514AsiaIndiaVijayanagar494.415.33576.462
451515AsiaChinaGuangzhou153.023.11667113.25
461515AsiaChinaNanjing147.01332.05118.766667
471515AsiaIndiaGauda197.22222222222224.86666788.133333
481515AsiaIndiaVijayanagar494.015.33576.462
491515EuropeFranceParis192.548.853412.3488
501516AsiaIndiaGauda194.44444444444424.86666788.133333
511516AsiaIndiaVijayanagar493.615.33576.462
521516Middle EastIranTabriz218.038.0846.2919
531517AsiaChinaBeijing678.1239.9075116.39723
541517AsiaChinaSuzhou140.54545454545531.3120.59
551518AsiaChinaSuzhou141.63636363636431.3120.59
561518AsiaIndiaGauda188.88888888888924.86666788.133333
571518EuropeTurkeyIstanbul323.07692307692341.00527528.9497
581518Middle EastIranTabriz214.038.0846.2919
591519Middle EastIranTabriz212.038.0846.2919
601521AsiaChinaGuangzhou154.223.11667113.25
611521Middle EastIranTabriz208.038.0846.2919
621522AsiaChinaBeijing679.9239.9075116.39723
631522EuropeItalyNaples158.76625531914940.85177514.26812
641523EuropeItalyNaples160.80108510638340.85177514.26812
651523EuropeTurkeyIstanbul361.53846153846241.00527528.9497
661524Middle EastEgyptCairo380.830.0431.24
671525AsiaChinaGuangzhou155.023.11667113.25
681525AsiaChinaHangzhou255.030.25120.16
691525AsiaChinaNanjing157.00928571428632.05118.766667
701525AsiaIndiaVijayanagar490.015.33576.462
711525EuropeFranceParis197.548.853412.3488
721525EuropeTurkeyIstanbul376.92307692307741.00527528.9497
731527AsiaChinaGuangzhou155.423.11667113.25
741527AsiaIndiaVijayanagar489.215.33576.462
751527EuropeItalyNaples168.94040425531940.85177514.26812
761528AsiaChinaGuangzhou155.623.11667113.25
771528Middle EastIranTabriz194.038.0846.2919
781529AsiaChinaHangzhou255.830.25120.16
791530EuropeTurkeyIstanbul423.63636363636441.00527528.9497
801531AsiaChinaBeijing683.1639.9075116.39723
811531AsiaChinaGuangzhou156.223.11667113.25
821531EuropeFranceParis200.548.853412.3488
831531EuropeItalyNaples177.07972340425540.85177514.26812
841533AsiaChinaHangzhou256.630.25120.16
851533AsiaIndiaVijayanagar486.815.33576.462
861533EuropeFranceParis201.548.853412.3488
871533EuropeItalyVenice147.78048780487845.44084712.315514
881534EuropeItalyVenice149.14634146341545.44084712.315514
891534EuropeTurkeyEdirne145.7641.68180826.562269
901534Middle EastEgyptCairo372.830.0431.24
911535AsiaChinaNanjing167.00557142857132.05118.766667
921535Middle EastEgyptCairo372.030.0431.24
931536EuropeFranceParis203.048.853412.3488
941536EuropeItalyNaples187.25387234042640.85177514.26812
951536EuropeItalyVenice151.87804878048845.44084712.315514
961537AsiaChinaBeijing685.3239.9075116.39723
971537EuropeItalyNaples189.2887021276640.85177514.26812
981537EuropeTurkeyEdirne147.6841.68180826.562269
991537Middle EastIranTabriz176.038.0846.2919
1001538AsiaChinaBeijing685.6839.9075116.39723
Rows: 1-100 | Columns: 7