Program: Extract_timeseries_from_excel_file
loading x elements...

Name: Extract_timeseries_from_excel_file

Discussion Thread

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.

Creator: tutorial_developer_improved

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.

ID: 268

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)

Version 9 (release)

Version 8 (release)

Version 7 (release)

Version 6 (development)

Version 5 (development)

Version 4 (development)

Version 3 (development)

Version 2 (development)

Version 1 (development)