verticapy.datasets.load_cities#
- verticapy.datasets.load_cities(schema: str | None = None, name: str = 'cities') vDataFrame #
Ingests the Cities dataset into the Vertica database. This dataset is ideal for 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 Cities vDataFrame.
Examples#
If you call this loader without any arguments, the dataset is loaded using the default schema (public).
from verticapy.datasets import load_cities load_cities()
AbccityVarchar(82)AbcLong varchar(2411724)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