CountRows - Maple Help
For the best experience, we recommend viewing online help using Google Chrome or Microsoft Edge.

Online Help

All Products    Maple    MapleSim


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

GetName

GetDescription

GetIdentifier

GetElementNames

CountRows

GetHeaders

GetData

Examples

Compatibility

Calling Sequence

GetName(ref)

GetDescription(ref)

GetElementNames(ref)

CountRows(ref)

GetHeaders(ref)

GetData(ref)

Parameters

ref

-

reference to built-in data

GetName

• 

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.

GetDescription

• 

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.

GetIdentifier

• 

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.

GetElementNames

• 

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.

CountRows

• 

Returns the total number of rows in the reference in a efficient manner.

GetHeaders

• 

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.

GetData

• 

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.

Examples

withDataSets:

refReferenceBuiltin,Country

refCountry (Name)Currency Code2 Letter Country Code(57 more)AfghanistanAFNAFAlbaniaALLALAlgeriaDZDDZ(182 more)

(1)

GetIdentifierref

Country

(2)

GetNameref

Country properties

(3)

GetDescriptionref

A table of country properties, containing immediate values for some properties and references to time series data (from Quandl) for others.

(4)

GetElementNamesref

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

(5)

CountRowsref

185

(6)

GetHeadersref

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

(7)

GetDataref1..2,1..2

AFNAFALLAL

(8)

Create a reference to the GeoNames data set.

refgBuiltin:-ReferenceGeonames

refgGeonames (GeoNamesid)NameType(7 more)68Boneh-ye Mehdisection of populated place121Lab Sefidlocality166Gorizilocality(1155858 more)

(9)

Count the number of rows in the GeoNames data set:

CountRowsrefg

1155861

(10)

Available data variables in the GeoNames data set include:

GetHeadersrefg

Name,Type,Latitude,Longitude,Country,Province/State/Region,City/County,Population,Time Zone

(11)

Search for Waterloo in Canada:

Waterloo_DatarefgCountry=Canada&comma;Type=populated place&comma;1000<Population&comma;Name=Waterloo

Waterloo_DataGeonames (GeoNamesid)NameType(7 more)6176821Waterloopopulated place6176823Waterloopopulated place

(12)

Return the all of the data from the search above:

GetDataWaterloo_Data

Waterloopopulated place45.3500799999999984−72.5158200000000051CanadaQuebecMonteregie4064America/TorontoWaterloopopulated place43.4667999999999992−80.5163900000000012CanadaOntarioundefined97475America/Toronto

(13)

To return specific data, such as the Population:

GetDataWaterloo_Data..,Population

406497475

(14)

Compatibility

• 

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