DataSets[Builtin][Reference]
GetName
obtain a short name of a reference
GetIdentifier
obtain the identifier for a reference
GetDescription
obtain a description of a reference
GetElementNames
obtain the row names of a reference
CountRows
obtain the number of rows of a reference
GetHeaders
obtain the column names of a reference
GetData
obtain the data of a reference
Calling Sequence
Parameters
Examples
Compatibility
GetName(ref)
GetDescription(ref)
GetElementNames(ref)
CountRows(ref)
GetHeaders(ref)
GetData(ref)
ref
-
reference to built-in data
Returns the name of the reference as a string. This is a short string description of the data set. If you create a subset of a data set by using indexing, the name may change if the result has only a single (non-name) column or a single row.
Returns a string description of the data set. If you create a subset of a data set by using indexing, the description may change if the result has only a single (non-name) column or a single row.
Returns the identifier of a reference as a string. This is a unique identifier that can be used to find this reference among the built-in data sets.
Returns a list of strings which are the names of the rows in the reference. Each row name is unique in the containing data set. This command may be slow if used on the full GeoNames data set.
Returns the total number of rows in the reference in a efficient manner.
Returns a list of strings which are the names of the columns in the reference. Each column name is unique in the containing data set.
Returns the reference as a Matrix, without the column headers and without the row names. This command will retrieve all metadata, which may be slow if used on a large data set.
with⁡DataSets:
ref≔Reference⁡Builtin,Country
ref≔Country (Name)Currency Code2 Letter Country Code…(57 more)AfghanistanAFNAF…AlbaniaALLAL…AlgeriaDZDDZ…⋮⋮⋮⋱(182 more)
GetIdentifier⁡ref
Country
GetName⁡ref
Country properties
GetDescription⁡ref
A table of country properties, containing immediate values for some properties and references to time series data (from Quandl) for others.
GetElementNames⁡ref
Afghanistan,Albania,Algeria,Angola,Antigua and Barbuda,Argentina,Armenia,Australia,Austria,Azerbaijan,Bahrain,Bangladesh,Barbados,Belarus,Belgium,Belize,Benin,Bhutan,Bolivia,Bosnia and Herzegovina,Botswana,Brazil,Brunei,Bulgaria,Burkina Faso,Burundi,Cabo Verde,Cambodia,Cameroon,Canada,Central African Republic,Chad,Chile,China,Colombia,Comoros,Congo,Congo-Brazzaville,Costa Rica,Croatia,Cuba,Cyprus,Czech Republic,Denmark,Djibouti,Dominica,Dominican Republic,Ecuador,Egypt,El Salvador,Equatorial Guinea,Eritrea,Estonia,Ethiopia,Fiji,Finland,France,Gabon,Gambia,Georgia,Germany,Ghana,Greece,Grenada,Guatemala,Guinea,Guinea-Bissau,Guyana,Haiti,Honduras,Hong Kong,Hungary,Iceland,India,Indonesia,Iran,Iraq,Ireland,Israel,Italy,Ivory Coast,Jamaica,Japan,Jordan,Kazakhstan,Kenya,Kiribati,Kosovo,Kuwait,Kyrgyzstan,Laos,Latvia,Lebanon,Lesotho,Liberia,Libya,Lithuania,Luxembourg,Macedonia,Madagascar,Malawi,Malaysia,Maldives,Mali,Malta,Mauritania,Mauritius,Mexico,Moldova,Mongolia,Montenegro,Morocco,Mozambique,Myanmar,Namibia,Nepal,Netherlands,New Zealand,Nicaragua,Niger,Nigeria,Norway,Oman,Pakistan,Panama,Papua New Guinea,Paraguay,Peru,Philippines,Poland,Portugal,Qatar,Romania,Russia,Rwanda,Saint Lucia,Samoa,Sao Tome and Principe,Saudi Arabia,Senegal,Serbia,Seychelles,Sierra Leone,Singapore,Slovakia,Slovenia,Solomon Islands,Somalia,South Africa,South Korea,South Sudan,Spain,Sri Lanka,Sudan,Suriname,Swaziland,Sweden,Switzerland,Syria,Taiwan,Tajikistan,Tanzania,Thailand,The Bahamas,Timor-Leste,Togo,Tonga,Trinidad and Tobago,Tunisia,Turkey,Turkmenistan,Tuvalu,UAE,UK,USA,Uganda,Ukraine,Uruguay,Uzbekistan,Vanuatu,Venezuela,Vietnam,Yemen,Zambia,Zimbabwe
CountRows⁡ref
185
GetHeaders⁡ref
Currency Code,2 Letter Country Code,Country Code for Internet Top-Level Domain,3 Letter Country Code,Heliports,Children under the age of 5 years underweight (%),Military expenditures (% GDP),Contraceptive prevalence rate (%),Gross national saving (% GDP),Public debt (% GDP),Total renewable water resources,Health expenditures (% GDP),Obesity - adult prevalence rate (%),Hospital bed density / 1000 pop,Physicians density / 1000 pop,Education expenditures (% GDP),Electricity - from other renewable sources (%),Electricity - from fossil fuels (%),Electricity - from nuclear fuels (%),Electricity - from hydroelectric plants (%),Crude oil - exports,Crude oil - imports,Crude oil - production,Refined petroleum products - exports,Carbon dioxide emissions from consumption of energy,Electricity - installed generating capacity,Refined petroleum products - production,Refined petroleum products - consumption,Refined petroleum products - imports,Natural gas - exports,Natural gas - imports,Natural gas - production,Natural gas - consumption,Natural gas - proved reserves,Crude oil - proved reserves,Electricity - exports,Taxes and other revenues (% GDP),Electricity - imports,Telephones - mobile cellular,Budget surplus (+) or deficit (-) (% GDP),Electricity - production,Electricity - consumption,Telephones - main lines in use,Net migration rate / 1000 pop / year,Industrial production growth rate (%),Death rate / 1000 pop / year,Birth rate / 1000 pop / year,Unemployment rate (%),Inflation rate (consumer prices) (% / year),Total fertility rate (children / woman),HIV/AIDS - adult prevalence rate,HIV/AIDS - deaths / year,Internet hosts,Population growth rate (% / year),Labor force,Airports,Irrigated land,Land boundaries,Coastline
GetData⁡ref1..2,1..2
AFNAFALLAL
Create a reference to the GeoNames data set.
refg≔Builtin:-Reference⁡Geonames
refg≔Geonames (GeoNamesid)NameType…(7 more)68Boneh-ye Mehdisection of populated place…121Lab Sefidlocality…166Gorizilocality…⋮⋮⋮⋱(1155858 more)
Count the number of rows in the GeoNames data set:
CountRows⁡refg
1155861
Available data variables in the GeoNames data set include:
GetHeaders⁡refg
Name,Type,Latitude,Longitude,Country,Province/State/Region,City/County,Population,Time Zone
Search for Waterloo in Canada:
Waterloo_Data≔refgCountry=Canada,Type=populated place,1000<Population,Name=Waterloo
Waterloo_Data≔Geonames (GeoNamesid)NameType…(7 more)6176821Waterloopopulated place…6176823Waterloopopulated place…
Return the all of the data from the search above:
GetData⁡Waterloo_Data
Waterloopopulated place45.3500799999999984−72.5158200000000051CanadaQuebecMonteregie4064America/TorontoWaterloopopulated place43.4667999999999992−80.5163900000000012CanadaOntarioundefined97475America/Toronto
To return specific data, such as the Population:
GetData⁡Waterloo_Data..,Population
406497475
The DataSets[Builtin][Reference][GetName], DataSets[Builtin][Reference][GetIdentifier], DataSets[Builtin][Reference][GetDescription], DataSets[Builtin][Reference][GetElementNames], DataSets[Builtin][Reference][CountRows], DataSets[Builtin][Reference][GetHeaders] and DataSets[Builtin][Reference][GetData] commands were introduced in Maple 2015.
For more information on Maple 2015 changes, see Updates in Maple 2015.
See Also
DataSets
Download Help Document