Function Repository Resource:

TimeSeriesToDataset

Source Notebook

Convert a TimeSeries object to a Dataset

Contributed by: Arnoud Buzing

ResourceFunction["TimeSeriesToDataset"][ts]

converts the TimeSeries ts to a Dataset object.

ResourceFunction["TimeSeriesToDataset"][ts,labels]

converts the TimeSeries ts to a Dataset object and assigns labels as the column names.

Details

The generated Dataset contains two columns.
The first column contains the timestamps and uses is labeled "Date" by default.
The second column contains the values and is labeled "Value" by default.
labels is a two-element list which is used to specify column labels.

Examples

Basic Examples

Create a TimeSeries object using FinancialData:

In[1]:=
ts = FinancialData[
  "AAPL", {DateObject[{2024, 1, 1}, "Day"], DateObject[{2024, 9, 18}, "Day"]}]
Out[1]=

Convert the TimeSeries to a Dataset:

In[2]:=
ResourceFunction["TimeSeriesToDataset"][ts]
Out[2]=

Assign custom labels for the columns:

In[3]:=
ResourceFunction["TimeSeriesToDataset"][ts, {"A", "B"}]
Out[3]=

Create a TimeSeries object using SunPosition:

In[4]:=
sp = SunPosition[
  DateRange[DateObject[{2024, 1, 1}, "Day"], DateObject[{2024, 9, 19}, "Day"]]]
Out[4]=

Convert it to a Dataset:

In[5]:=
ResourceFunction["TimeSeriesToDataset"][sp]
Out[5]=

Publisher

Arnoud Buzing

Requirements

Wolfram Language 14.0 (January 2024) or above

Version History

  • 1.0.0 – 18 September 2024

Related Resources

License Information