Custom time series collection data (*.table.csv)
A custom text data file with file extension *.table.csv contains a set of time series. For timestamp and column conventions, see Working with text data files.
The first line lists the variables in the file. Each subsequent line contains the following values for a time series:
Variable |
Description |
Date |
yyyy-MM-dd |
Time |
HH:mm:ss |
Milliseconds (optional) |
Millisecond (ms) component of custom time series collection time. This is an optional column and if the column is left blank, the default value of 0 ms is assigned. |
X_value |
Custom time series value for the time series. X denotes the custom time series name. See also Custom types for interpolation. |
X_status |
Value for the Status of the segment between the current and next time series value. This column is optional, and if the column is left blank, a default status value of 3 (Good) is assigned. |
Data types and interpolation
The tabulated collection is read by Echoview but no assumptions are made for the units of each time series in the collection.
A time series may be derived from the collection via the Time series select operator. The Time Series Properties of the operator offer you options to specify standard units or unspecified unitless data with a selected interpolation method.
Example:
TableCollection.table.csv contains Date, Time values and a set of time series with names Depth_m_value, Temperature_C_value, Pressure_kPa_value and Speed of sound_m/s_value. The file has no status values.
Date,Time,Depth_m_value,Temperature_C_value,Pressure_kPa_value,Speed of Sound_m/s_value
2/01/1985,0:00,0,0,101.3,1449.2
2/01/1985,1:00,1000,5,1013,1500
2/01/1985,2:00,2000,10,2026,1540
2/01/1985,3:00,3000,15,3039,1570
2/01/1985,4:00,4000,20,4052,1590
2/01/1985,5:00,5000,25,5065,1600
Figure 1. The file contents as displayed in a text editor (e.g., Notepad).
Figure 2: Echoview reads the TableCollection.table.csv and displays the set of time series in a table.