Table

The Table type represents a structured data table. It consists of columns and rows of data.

>>> from rayforce import Table, I64, Symbol, Vector

>>> columns = ["id", "name", "age", "salary"]
>>> values = [
        Vector([1, 2, 3, 4, 5], ray_type=I64),  # id column
        Vector(["Alice", "Bob", "Charlie", "Diana", "Eve"], ray_type=Symbol),  # name column
        Vector([25, 30, 35, 28, 32], ray_type=I64),  # age column
        Vector([50000, 60000, 70000, 55000, 65000], ray_type=I64),  # salary column
    ]

>>> employee_table = Table(dict(zip(columns, values)))
>>> employee_table
Table[Symbol('id'), Symbol('name'), Symbol('age'), Symbol('salary')]

>>> print(employee_table)
┌─────┬─────────┬─────┬───────────────┐
│ id  │  name   │ age │    salary     │
│ I64 │   SYM   │ I64 │      I64      │
├─────┼─────────┼─────┼───────────────┤
│ 1   │ Alice   │ 25  │ 50000         │
│ 2   │ Bob     │ 30  │ 60000         │
│ 3   │ Charlie │ 35  │ 70000         │
│ 4   │ Diana   │ 28  │ 55000         │
│ 5   │ Eve     │ 32  │ 65000         │
├─────┴─────────┴─────┴───────────────┤
│ 5 rows (5 shown) 4 columns (4 shown)│
└─────────────────────────────────────┘

Details

Table columns object is a Vector of Symbols. Due to QL restrictions, column names can not contain spaces or tabulations.

Table values object is a List of Vectors of specific type. Each Vector represents a specific column in table.