13.1.1 Table format

Tables can be created with the table square bracket notation.

As an example, let’s create a table with two columns named “a” and “col2” having three rows. The syntax is to surround the definition with square brackets and then have a first element of empty square brackets. Following those brackets comes first column name, colon, and the list of values, then the second column, and continuing for all the columns. For keyed tables, the initial square brackets will contain key column names as we will discuss later.

 [[] a:1 20 3; col2: 3.6 4.8 0.1]
a  col2
-- ----
 1 3.6 
20 4.8 
 3 0.1

 [[] a:1; col2:3.6]   / will error :class as lists required
[[] a:1; col2:3.6]

:class

 [[] a:,1; col2:,3.6] / using list will succeed
[[]a:,1;col2:,3.6]

13.1.2 Dictionary format

Tables can also be created by flipping a dictionary into a table.

 +`a`col2!(1 20 3;  3.6 4.8 0.1)      / +columnnames!(values)
a  col2
-- ----
 1 3.6 
20 4.8 
 3 0.1 

13.1.3 File import

Tables can also be created by reading in a file.

t.csv

a, col2
1, 3.6
20, 4.8
3, 0.1

Use load file 2:x which returns a table.

 2:`t.csv
a   col2
-- -----
 1  3.6 
20  4.8 
 3  0.1