get for dataframe

Creates dataframe with the selected columns

Signature

> get

Examples

Returns the selected column

> [[a b]; [1 2] [3 4]] | into df | get a

get for filters

Extract data using a cell path.

Signature

> get (cell_path) ...rest --ignore-errors --sensitive

Parameters

  • cell_path: the cell path to the data
  • ...rest: additional cell paths
  • --ignore-errors: when there are empty cells, instead of erroring out, replace them with nothing
  • --sensitive: get path in a case sensitive manner

Examples

Get an item from a list

> [0 1 2] | get 1

Get a column from a table

> [{A: A0}] | get A

Get a cell from a table

> [{A: A0}] | get 0.A

Extract the name of the 3rd record in a list (same as ls | $in.name)

> ls | get name.2

Extract the name of the 3rd record in a list

> ls | get 2.name

Extract the cpu list from the sys information record

> sys | get cpu

Getting Path/PATH in a case insensitive way

> $env | get paTH

Getting Path in a case sensitive way, won't work for 'PATH'

> $env | get -s Path