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
SetFromDate, SetToDate
Examples
Compatibility
SetColumns(ref, columns)
SetFromDate(ref, date)
SetToDate(ref, date)
SetFrequency(ref, freq)
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"
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.
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.
Set the data frequency of the data to be retrieved. Cannot be more frequent than the original frequency.
with⁡DataSets:
We create a reference by using the Quandl identifier code.
ref ≔ Quandl:-Reference⁡BITCOINWATCH/MINING
ref≔Data setBitcoin Mining StatisticsQuandl BITCOINWATCH/MININGup to 2813 rows (daily), 13 columns2013-08-26 - 2021-05-08
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.
SetColumns⁡ref,2,3
Data setBitcoin Mining StatisticsQuandl BITCOINWATCH/MININGup to 2813 rows (daily), 2 columns2013-08-26 - 2021-05-08
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.
SpainOliveOil ≔ Quandl:-Reference⁡UINC/VOLO_ESP
SpainOliveOil≔Data setProduction of Virgin Olive Oil - SpainQuandl UINC/VOLO_ESPup to 22 rows (annual), 2 columns1995-12-31 - 2016-12-31
The SetFromDate command sets the start date for a sample of the data set.
SpainOliveOil ≔ SetFromDate⁡SpainOliveOil,2000-12-31
SpainOliveOil≔Data setProduction of Virgin Olive Oil - SpainQuandl UINC/VOLO_ESPup to 17 rows (annual), 2 columns2000-12-31 - 2016-12-31
The SetToDate command sets the end date for a sample of the data set.
SpainOliveOil ≔ SetToDate⁡SpainOliveOil,2011-12-31
SpainOliveOil≔Data setProduction of Virgin Olive Oil - SpainQuandl UINC/VOLO_ESPup to 12 rows (annual), 2 columns2000-12-31 - 2011-12-31
The SetColumns command restricts the data to just the amount in thousands of metric tons.
SpainOliveOil ≔ SetColumns⁡SpainOliveOil,2
SpainOliveOil≔Data setProduction of Virgin Olive Oil - SpainQuandl UINC/VOLO_ESPup to 12 rows (annual), 1 column2000-12-31 - 2011-12-31
The TimeSeriesPlot command can generate a plot:
TimeSeriesAnalysis:-TimeSeriesPlot⁡SpainOliveOil
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]
Download Help Document