Table
Description: | A two-dimensional container with both columns and rows where each cell can hold any basic or structured data type |
Annotation: | table |
Table-Literal Syntax: | See below |
Casts: | N/A |
See Also: | Working with Tables |
Navigating and Accessing Structured Data | |
Types of Data - Tables |
Creating Tables
Table-literal syntax
Table literals can be created using a syntax similar to that of a list literal. Because tables also contain columns and not just values, we also specify the column names:
> [[column1, column2]; [Value1, Value2] [Value3, Value4]]
╭───┬─────────┬─────────╮
│ # │ column1 │ column2 │
├───┼─────────┼─────────┤
│ 0 │ Value1 │ Value2 │
│ 1 │ Value3 │ Value4 │
╰───┴─────────┴─────────╯
In this syntax, the headers are separated from the data cells using a semicolon(;
). The semicolon separator is mandatory in a table-literal. It must follow the headers.
List-of-Records syntax
You can also create a table as a list of records, JSON-style:
> [{name: "Sam", rank: 10}, {name: "Bob", rank: 7}]
╭───┬──────┬──────╮
│ # │ name │ rank │
├───┼──────┼──────┤
│ 0 │ Sam │ 10 │
│ 1 │ Bob │ 7 │
╰───┴──────┴──────╯
This list-of-records pattern plays on the Nushell data model, which sees a list of records as equivalent to a table. This is useful in cases where the length of a table may not be known ahead of time. In such a case, a stream of records likewise represents a table.
Common commands that can be used with table
table
ls
ps
sys
select
get
where
range
Note
Most of Nushell's filter commands work with tables. For a longer list see: help commands | where category == filters
.