W3cubDocs

/Nushell

dfr sum for expression

Creates a sum expression for an aggregation or aggregates columns to their sum value

Signature

> dfr sum {flags}

Input/output types:

input output
any any

Examples

Sums all columns in a dataframe

> [[ab]; [62] [14] [41]] |dfr into-df|dfr sum
╭───┬────┬───╮
│# │ a  │ b │
├───┼────┼───┤
│0│11│7│
╰───┴────┴───╯

Sum aggregation for a group-by

> [[ab]; [one2] [one4] [two1]]
|dfr into-df
|dfr group-bya
|dfr agg (dfr colb|dfr sum)
╭───┬─────┬───╮
│# │  a  │ b │
├───┼─────┼───┤
│0│one│6│
│1│two│1│
╰───┴─────┴───╯

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_sum.html