This site gives you the initial and necessary information to run DataTube2, a visual mining application devoted to temporal data.
Ci-dessous, les différences entre deux révisions de la page.
Les deux révisions précédentes Révision précédente Prochaine révision | Révision précédente | ||
loading [2015/02/23 15:29] venturini [CSV format for asynchronous files: International (separator = TAB, decimal = .)] |
loading [2015/03/13 16:18] (Version actuelle) venturini [Encoding your own data] |
||
---|---|---|---|
Ligne 37: | Ligne 37: | ||
The DataTube2 synchronous format supports both encodings. To open a synchronous file, please start with: | The DataTube2 synchronous format supports both encodings. To open a synchronous file, please start with: | ||
- | {{ :opensync.png?nolink&300 |}} | + | {{ :opensync.png?nolink |}} |
and then specify the French/International encoding by answering "Yes" or "No" in the following window, which is diplayed when you open a file: | and then specify the French/International encoding by answering "Yes" or "No" in the following window, which is diplayed when you open a file: | ||
- | {{ :csvfrenchinternational.png?nolink&550 |}} | + | {{ :csvfrenchinternational.png?nolink |}} |
+ | |||
==== CSV format for asynchronous files: International (separator = "TAB", decimal = ".") ==== | ==== CSV format for asynchronous files: International (separator = "TAB", decimal = ".") ==== | ||
Ligne 47: | Ligne 49: | ||
The asynchronous format in DataTube2 uses TAB character as separator and "." for decimals. To open an asynchronous file, please select: | The asynchronous format in DataTube2 uses TAB character as separator and "." for decimals. To open an asynchronous file, please select: | ||
- | {{ :openasync.png?nolink&300 |}} | + | {{ :openasync.png?nolink |}} |
and then: | and then: | ||
- | {{ :csvasyncinternational2.png?nolink&300 |}} | + | {{ :csvasyncinternational2.png?nolink |}} |
Ligne 68: | Ligne 69: | ||
As an example, here are the first lines of file "DT2-synchronous-small-file-french.csv", which is **synchronous** and with the **French CSV encoding**: | As an example, here are the first lines of file "DT2-synchronous-small-file-french.csv", which is **synchronous** and with the **French CSV encoding**: | ||
+ | ''Time,VAR1,VAR2,VAR3,VAR4,VAR5,VAR6,VAR7,VAR8,VAR9,VAR10, ... \\ | ||
+ | timestamp,numeric,numeric,numeric,numeric,numeric,numeric,numeric,numeric,numeric,... \\ | ||
+ | 3;;;;;;;;;;... \\ | ||
+ | |||
+ | 4;;;;;;;;;;... \\ | ||
+ | |||
+ | 5;;;;;;;;;;... \\ | ||
+ | 6;;;;;;;;;;... \\ | ||
+ | 7;;;;;;;;;;... \\ | ||
+ | 8;;;;;;;;;;... \\ | ||
+ | 9;;;;;;;;;;... \\ | ||
+ | 10;;;;;;;;;;... \\ | ||
+ | 2003-09-28 00:00:00;-1000;15,1;81,1;35;14;213;0;6;25;14;... \\ | ||
+ | 2003-09-29 00:00:00;34;13;75;34,15;153;1;7;35;15;... \\ | ||
+ | ... \\ | ||
+ | '' | ||
Here are the first lines of file "DT2-synchronous-small-file-international.csv", which is **synchronous** and with the **International CSV encoding**: | Here are the first lines of file "DT2-synchronous-small-file-international.csv", which is **synchronous** and with the **International CSV encoding**: | ||
+ | ''Time,VAR1,VAR2,VAR3,VAR4,VAR5,VAR6,VAR7,VAR8,VAR9,VAR10, ... \\ | ||
+ | timestamp,numeric,numeric,numeric,numeric,numeric,numeric,numeric,numeric,numeric,... \\ | ||
+ | 3,,,,,,,,,,... \\ | ||
+ | |||
+ | 4,,,,,,,,,,... \\ | ||
- | Finally, here is a sample of file "???", which is **asynchronous** with **TAB separators**: | + | 5,,,,,,,,,,... \\ |
+ | 6,,,,,,,,,,... \\ | ||
+ | 7,,,,,,,,,,... \\ | ||
+ | 8,,,,,,,,,,... \\ | ||
+ | 9,,,,,,,,,,... \\ | ||
+ | 10,,,,,,,,,... \\ | ||
+ | 2003-09-28 00:00:00,-1000,15.1,81.1,35,14,213,0,6,25,14,... \\ | ||
+ | 2003-09-29 00:00:00,34,13,75,34,15,153,1,7,35,15,... \\ | ||
+ | ... \\ | ||
+ | '' | ||
+ | Finally, here is a sample of an asynchronous file, which is **asynchronous** with **TAB separators**: | ||
+ | '' | ||
+ | VAR1 2006-02-01 00:00:00 310.1\\ | ||
+ | VAR1 2006-02-02 00:00:00 320\\ | ||
+ | VAR1 2006-02-03 00:00:00 330\\ | ||
+ | VAR1 2006-02-04 00:00:00 340\\ | ||
+ | VAR1 2006-02-05 00:00:00 350\\ | ||
+ | ... \\ | ||
+ | '' | ||
Ligne 80: | Ligne 120: | ||
To encore your own data in a CSV file: | To encore your own data in a CSV file: | ||
- | * Select the format to use, i.e., either synchronous or asynchronous (see explanation above), | + | * Select the format to use, i.e., either synchronous or asynchronous (see explanations above), |
* Study the examples provided with DataTube2 (see the Data directory), | * Study the examples provided with DataTube2 (see the Data directory), | ||
* Give names to the variables, | * Give names to the variables, | ||
* To represent time values : | * To represent time values : | ||
* the GMT format is yyyy-mm-dd hh:mm:ss | * the GMT format is yyyy-mm-dd hh:mm:ss | ||
- | * yyyy must be greater than 1970 (this is due to the EPOCH format, we'll try to improve in future releases), | + | * yyyy must be greater than 1970 (this is due to the EPOCH format, we'll try to improve this in future releases), |
* DataTube2 can use GMT or EPOCH (but yet, please use GMT, we need additional testing for EPOCH format), | * DataTube2 can use GMT or EPOCH (but yet, please use GMT, we need additional testing for EPOCH format), | ||
* To represent data values: | * To represent data values: |