DataTube2 User Guide

This site gives you the initial and necessary information to run DataTube2, a visual mining application devoted to temporal data.

Outils pour utilisateurs

Outils du site


loading

Différences

Ci-dessous, les différences entre deux révisions de la page.

Lien vers cette vue comparative

Les deux révisions précédentes Révision précédente
Prochaine révision
Révision précédente
loading [2015/02/23 14:25]
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 ​ |}}
  
  
Ligne 66: 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,,,,,,,,,,​... \\
  
-Finallyhere 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 78: 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: ​
loading.1424697906.txt.gz · Dernière modification: 2015/02/23 14:25 par venturini