Version: 10 (release)
Newest release version: This is the newest release version of this Program.
Newest release or development version: This is the newest version of this Program.
This Program is part of the tutorial.
This program takes a file under the parameter name \"raw_timeseries_file\" and attempts to extract a timeseries from it that is properly formatted and cleaned to be suitable for further use by machine learning algorithms. It also takes a parameter \"require_timeseries_to_predict_tag\", which is a Tag of type require_timeseries_to_predict.
This Program requires files in excel format (.xlsx).
It can find tables anywhere in the file, but it only works properly if there are no missing values in the table.
It outputs files in the Python pandas format.
The detection of timeseries works if:
-The content is either vertical or horizontal.
-The table's x-axis may optionally have a header.
-The table's y-axis may optionally have a header.
The detection does not work if:
-There are missing values in a table. If this happens, this program will treat the gap as the end of the column and will treat the next number as the beginning of another, entirely new column.
Created: April 9, 2019, 4:56 p.m.
Docker Image: elody.com:444/extract_timeseries_from_excel_file@sha256:e042f9a6203944222c4f8723f6f1b739ec18feeecc3a8934826340b500bb76b1
Source code: Run the following command in a terminal to download the source code: 'lod-tools download-program -f <destination_folder> --name "Extract_timeseries_from_excel_file" --version 10'
all versions of this Program:
Version 10 (release)