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

Online Help

All Products    Maple    MapleSim


DataSets[Quandl][Reference]

  

SetColumns

  

set included columns of a reference

  

SetFromDate

  

set start date of a reference

  

SetToDate

  

set end date of a reference

  

SetFrequency

  

set data frequency of a reference

 

Calling Sequence

Parameters

SetColumns

SetFromDate, SetToDate

SetFrequency

Examples

Compatibility

Calling Sequence

SetColumns(ref, columns)

SetFromDate(ref, date)

SetToDate(ref, date)

SetFrequency(ref, freq)

Parameters

ref

-

Quandl reference object

columns

-

positive integer or list of positive integers, all of which is less than or equal to the number of columns

date

-

string; has form YYYY-MM-DD

freq

-

string; must of one of "daily", "weekly", "monthly", "quarterly", "annual"

SetColumns

• 

Select a subset of the original columns to be included when data is retrieved.

• 

The order of the columns may be changed but duplicate columns are not allowed.

SetFromDate, SetToDate

• 

Set the date range of the data to be retrieved. The date string must be such that it is accepted by StringTools[ParseTime] with the format "%Y-%m-%d". For example "2015-02-18".

• 

Cannot exceed the original date range.

SetFrequency

• 

Set the data frequency of the data to be retrieved. Cannot be more frequent than the original frequency.

Examples

withDataSets:

We create a reference by using the Quandl identifier code.

refQuandl:-ReferenceBITCOINWATCH/MINING

refData setBitcoin Mining StatisticsQuandl BITCOINWATCH/MININGup to 2813 rows (daily), 13 columns2013-08-26 - 2021-05-08

(1)

The reference object has 13 columns of data. The SetColumns command selects a list of columns from the data set, in this case, returning the second and third columns.

SetColumnsref,2,3

Data setBitcoin Mining StatisticsQuandl BITCOINWATCH/MININGup to 2813 rows (daily), 2 columns2013-08-26 - 2021-05-08

(2)

The following data set contains some data on olive oil manufacturing in Spain. In this example, we select a subsample from the data reference and then plot it.

SpainOliveOilQuandl:-ReferenceUINC/VOLO_ESP

SpainOliveOilData setProduction of Virgin Olive Oil - SpainQuandl UINC/VOLO_ESPup to 22 rows (annual), 2 columns1995-12-31 - 2016-12-31

(3)

The SetFromDate command sets the start date for a sample of the data set.

SpainOliveOilSetFromDateSpainOliveOil,2000-12-31

SpainOliveOilData setProduction of Virgin Olive Oil - SpainQuandl UINC/VOLO_ESPup to 17 rows (annual), 2 columns2000-12-31 - 2016-12-31

(4)

The SetToDate command sets the end date for a sample of the data set.

SpainOliveOilSetToDateSpainOliveOil,2011-12-31

SpainOliveOilData setProduction of Virgin Olive Oil - SpainQuandl UINC/VOLO_ESPup to 12 rows (annual), 2 columns2000-12-31 - 2011-12-31

(5)

The SetColumns command restricts the data to just the amount in thousands of metric tons.

SpainOliveOilSetColumnsSpainOliveOil,2

SpainOliveOilData setProduction of Virgin Olive Oil - SpainQuandl UINC/VOLO_ESPup to 12 rows (annual), 1 column2000-12-31 - 2011-12-31

(6)

The TimeSeriesPlot command can generate a plot:

TimeSeriesAnalysis:-TimeSeriesPlotSpainOliveOil

Compatibility

• 

The DataSets[Quandl][Reference][SetColumns] command was introduced in Maple 2015.

• 

For more information on Maple 2015 changes, see Updates in Maple 2015.

See Also

DataSets

TimeSeriesAnalysis

TimeSeriesAnalysis[TimeSeriesPlot]