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(columns=['id', 'name', 'age', 'salary'])

>>> print(employee_table)
┌────┬─────────┬─────┬─────────────────┐
│ id │ name    │ age │ salary          │
├────┼─────────┼─────┼─────────────────┤
│ 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.