Import from CSV
Description
In SAFE you can import csv files to make it convenient to process tables from e.g. Excel.
The format of the .csv file is as follows for an MxN data size. The header consists of the sample rate fs
the xlabel, the ylabel and the tag and unit for each channel. It is important that the tags for x and
y match, and the units for x and y match respectively. After the header the data is inserted. All the x data first, followed
by the y data.
fs=int | ... | ... | |||
xlabel=str | ... | ... | |||
ylabel=str | ... | ... | |||
tag_0 [x_unit] | ... | tag_N [x_unit] | tag_0 [y_unit] | ... | tag_N [y_unit] |
x_data_0_0 | ... | x_data_0_N | y_data_0_0 | ... | y_data_0_N |
| ... | ... | ... | ... | ... | ... |
x_data_M_0 | ... | x_data_M_N | y_data_M_0 | ... | `y_data_M_N |
Output
The output is MxN and is the data from the .csv file, with the specified sample rate and x- and y-label
Attributes
| Attribute | Value |
|---|---|
| Name | ImportCsv |
| Settings | |
| Path | ' ' |
| Separator | , |
| Outputs | 1 |
Name
Name specifies the name of the block.
Path
Path specifies the path to the .csv file and will open a file explorer.
Separator
Separator specifies the separator type used in the .csv file. The separator can either be , or ;.
Outputs
Outputs specifies the number of output(s) the block will have. Each output will output the same csv import.
Examples
A single channel import.
fs=48000,
xlabel=Time,
ylabel=Amplitude,
Measurement 1 [s],Measurement 1 [Pa]
1,11
2,12
3,15
4,17
5,20
Multicolumn data import.
fs=48000,,,
xlabel=Time,,,
ylabel=Amplitude,,,
Measurement 1 [s],Measurement 2 [s],Measurement 1 [Pa],Measurement 2 [Pa]
1,1,11,66
2,2,12,114
3,3,15,150
4,4,17,19
5,5,20,10