Datatable
The Datatable data type represents tabular data.
It is primarily used when working with .csv, .tsv, .xlsx and .text files, as well as databases.

Examples

`data` argument of the "Csv file to datatable" adaptor
The "Csv file to datatable" adaptor produces a Datatable from the data argument.
`data` argument of the "Datatable to csv" adaptor
The "Datatable to csv" adaptor accepts a Datatable for the data argument.

Internal Structure

Given the following csv file:
example.csv
1
col1,col2,col3
2
1,2,3
3
A,B,C
Copied!
An equivalent Datatable would be structured as follows:
example.json
1
{
2
columns: [
3
'col1',
4
'col2',
5
'col3'
6
],
7
rows: [
8
{
9
col1: 1,
10
col2: 2,
11
col3: 3
12
},
13
{
14
col1: A,
15
col2: B,
16
col3: C
17
}
18
]
19
}
Copied!
Last modified 22h ago