Skip to content

Creating new Dataset

TIM Studio offers you to create Dataset from following sources:

  • upload from CSV file,
  • import data from SQL-like database (see list of supported databases below).

Creating Dataset from CSV file

To upload new CSV file:

  1. Navigate to Datasets section in TIM Studio and click on button Add Dataset,
  2. in dialogue window, make sure you are on CSV tab,
  3. drag&drop or select CSV file from your hard drive,
  4. enter name of Dataset, although it is prefilled from name of input file, it is possible to change it,
  5. confirm parameters of CSV file:
  6. Column separator,
  7. Decimal separator,
  8. Format of timestamp (see table below with format directives), at the moment format is not automatically detected,
  9. Timestamp column;

    TIM Studio tries to detect pattern of timestamp from your data automatically. However you can double check and correct if necessary. You can open CSV in notepad (or other similar editor) to determine correct values. This parameter has impact on correct data import and also, if your input does not match with reality you will be given warnings preventing you to proceed with data upload.

  10. optionally, select column that contains information about public holidays, it must contain binary values 0 or 1 only; This is important if you'd like to unlock functionality of Public Holidays dictionary for model building.

  11. click on Add Dataset button,
  12. upload process will start in the background, progress of upload is updated as percentage in list of Datasets.

image16.png
Uploading CSV file

All parameters, except Public Holiday column can be changed later.

You can monitor progress of upload in the list of Datasets as % value being updated.

image
Uploading in progress

In case issue is detected in your Dataset during the upload (or update) process, you will be given warning via Notifications, when clicked on it further details are provided.

image16.png
New notification alert

image16.png
New notification message

image16.png
Notification details

Be aware of requirements and constrains of input data.

Timestamp format directives

Directive Meaning Example
YYYY 4-digits year 2000 2001 ... 2099
MM Zero-padded month number 01 02 ... 12
M Month number 1 2 ... 12
DD Zero-padded day of month 01 02 ... 31
D Day of month 1 2 ... 31
HH Zero-padded hours in 24-hour format 00 01 02 ... 24
H Hours in 24-hour format 0 1 2 ... 24
hh Zero-padded hours in 12-hour format 00 01 02 ... 12
h Hours in 12-hour format 0 1 2 ... 12
a AM/PM or am/pm am pm AM PM
mm Zero-padded minutes 00 01 02 ... 59
m Minutes 0 1 2 ... 59
ss Zero-padded seconds 00 01 02 ... 59
s Seconds 0 1 2 ... 59
SSS Milliseconds 0 1 2 ... 999

For example, code for 2018-12-31 13:21:01 would be YYY-MM-DD HH:mm:ss.

New Dataset can be created also from Wizard when you are creating new Experiment. For more details read how to Create new Experiment.

Creating Dataset from SQL-like database

At the moment following databases are supported:

  • MySQL/MariaDB
  • Microsoft SQL
  • PostgresSQL

To upload data from database:

  1. Navigate to Datasets section in TIM Studio and click on button Add Dataset,
  2. in dialogue window, make sure you are on SQL database tab,
  3. enter name of Dataset, although it is prefilled from name of input file, it is possible to change it,
  4. provide following parameters so TIM Studio can connect correctly to your database:
  5. Type of database
  6. Host
  7. Port
  8. Username
  9. Password
  10. Database
  11. Table
  12. click on Connect button,
  13. optionally, select Public Holidays column (must contain only values 0 or 1),
  14. click on Add Dataset button,
  15. upload process will start in the background, progress of upload is updated as percentage in list of Datasets.

image
Creating connection to MySQL Database

All parameters, except Public Holiday column can be changed later.

Your password will be saved in encrypted form. TIM Studio does not know what is your password.