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
loading
Différences
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/19 14:54] venturini [Encoding your own data] |
loading [2015/03/13 16:18] (Version actuelle) venturini [Encoding your own data] |
||
|---|---|---|---|
| Ligne 36: | Ligne 36: | ||
| ^ Decimal separator | , | . | | ^ Decimal separator | , | . | | ||
| - | The DataTube2 synchronous format supports both encodings, and you can specify the French/International encoding by answering "Yes" or "No" in the following window, which is diplayed when you open a file: | + | The DataTube2 synchronous format supports both encodings. To open a synchronous file, please start with: |
| + | {{ :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: | ||
| + | |||
| + | |||
| + | {{ :csvfrenchinternational.png?nolink |}} | ||
| - | {{ :csv.png?nolink&550 |}} | ||
| ==== CSV format for asynchronous files: International (separator = "TAB", decimal = ".") ==== | ==== CSV format for asynchronous files: International (separator = "TAB", decimal = ".") ==== | ||
| - | The asynchronous format in DataTube2 uses TAB character as separator and "." for decimals: | + | The asynchronous format in DataTube2 uses TAB character as separator and "." for decimals. To open an asynchronous file, please select: |
| + | |||
| + | {{ :openasync.png?nolink |}} | ||
| + | |||
| + | and then: | ||
| + | |||
| + | {{ :csvasyncinternational2.png?nolink |}} | ||
| Ligne 54: | Ligne 65: | ||
| ==== Loading and visualizing the demo files ==== | ==== Loading and visualizing the demo files ==== | ||
| - | Simple demo files with artificial data are provided in each format (synchronous or asynchronous) and for each CSV encoding (French or international). | + | Simple demo files with artificial data are provided in each format (synchronous or asynchronous). For the synchonous format, we give you some examples for each CSV encoding (French or international). |
| + | 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**: | ||
| - | DT2-synchronous-small-file-international.csv | + | ''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**: | ||
| + | |||
| + | ''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,... \\ | ||
| + | ... \\ | ||
| + | '' | ||
| + | |||
| + | 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 63: | 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: | + | * Select the format to use, i.e., either synchronous or asynchronous (see explanations above), |
| - | * for synchronous format (see the discussion above), use either the French CSV format (like this ";3,1415;") or the International CSV format (like this ",3.1415,"), | + | |
| - | * for asynchronous format, use TAB for separators and "." for decimals, | + | |
| * 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, | ||
| * 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), |
| - | * Give names to the variables, | + | * To represent data values: |
| + | * for synchronous format (see the discussion above), use either the French CSV format (like this ";3,1415;") or the International CSV format (like this ",3.1415,"), | ||
| + | * for asynchronous format, use TAB for separators and "." for decimals, | ||
| + | |||
loading.1424354053.txt.gz · Dernière modification: 2015/02/19 14:54 par venturini
Outils de la page
Sauf mention contraire, le contenu de ce wiki est placé sous les termes de la licence suivante : GNU Free Documentation License 1.3
