load_cities¶

In [ ]:

load_cities( 
            schema: str = 'public',
            name: str = 'cities')

Ingests the 'cities' dataset into the Vertica database. This dataset is ideal for geospatial functions. 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
schema	str	✓	Schema of the new relation. The default schema is public.
name	str	✓	Name of the new relation.

Returns¶

vDataFrame : the Cities vDataFrame.

Example¶

In [4]:

from verticapy.datasets import load_cities
load_cities()

Out[4]:

	Abc city Varchar(82)	🌎 Geometry(1048576)
1	Abidjan
2	Abu Dhabi
3	Abuja
4	Accra
5	Addis Ababa
6	Algiers
7	Amman
8	Amsterdam
9	Andorra
10	Ankara
11	Antananarivo
12	Apia
13	Ashgabat
14	Asmara
15	Astana
16	Asuncion
17	Athens
18	Baghdad
19	Baku
20	Bamako
21	Bandar Seri Begawan
22	Bangkok
23	Bangui
24	Banjul
25	Basseterre
26	Beijing
27	Beirut
28	Belgrade
29	Belmopan
30	Berlin
31	Bern
32	Bishkek
33	Bissau
34	Bloemfontein
35	Bogota
36	Brasilia
37	Bratislava
38	Brazzaville
39	Bridgetown
40	Brussels
41	Bucharest
42	Budapest
43	Buenos Aires
44	Bujumbura
45	Cairo
46	Canberra
47	Cape Town
48	Caracas
49	Castries
50	Chisinau
51	Colombo
52	Conakry
53	Cotonou
54	Dakar
55	Damascus
56	Dar es Salaam
57	Dhaka
58	Dili
59	Djibouti
60	Doha
61	Dublin
62	Dushanbe
63	Freetown
64	Funafuti
65	Gaborone
66	Georgetown
67	Guatemala
68	Hanoi
69	Harare
70	Hargeysa
71	Havana
72	Helsinki
73	Honiara
74	Islamabad
75	Jakarta
76	Jerusalem
77	Johannesburg
78	Juba
79	Kabul
80	Kampala
81	Kathmandu
82	Khartoum
83	Kiev
84	Kigali
85	Kingston
86	Kingstown
87	Kinshasa
88	Kuala Lumpur
89	Kuwait
90	København
91	La Paz
92	Libreville
93	Lilongwe
94	Lima
95	Lisbon
96	Ljubljana
97	Lome
98	London
99	Luanda
100	Lusaka

Rows: 1-100 | Columns: 2