Program: Extract_timeseries_from_excel_file
loading x elements...

Name: Extract_timeseries_from_excel_file

Discussion Thread

Version: 5 (development)

Newest release version: Version 9

Newest release or development version: Version 9

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: 43

Created: Sept. 27, 2018, 3:15 p.m.

Docker Image:

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 5'

all versions of this Program:

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)