W3cubDocs

/Nushell

dfr var for expression

Create a var expression for an aggregation

Signature

> dfr var {flags}

Input/output types:

input output
any any

Examples

Var value from columns in a dataframe or aggregates columns to their var value

> [[ab]; [62] [42] [22]] |dfr into-df|dfr var
╭───┬──────┬──────╮
# │  a   │  b   │
├───┼──────┼──────┤
04.000.00
╰───┴──────┴──────╯

Var aggregation for a group-by

> [[ab]; [one2] [one2] [two1] [two1]]
|dfr into-df
|dfr group-bya
|dfr agg (dfr colb|dfr var)
╭───┬─────┬──────╮
# │  a  │  b   │
├───┼─────┼──────┤
0one0.00
1two0.00
╰───┴─────┴──────╯

Tips: Dataframe commands were not shipped in the official binaries by default, you have to build it with --features=dataframe flag

Copyright © 2019–2023 The Nushell Project DevelopersLicensed under the MIT License.
https://www.nushell.sh/commands/docs/dfr_var.html