W3cubDocs

/Nushell

dfr fill-nan for lazyframe

Replaces NaN values with the given expression.

Signature

> dfr fill-nan {flags} (fill)

Parameters

  • fill: Expression to use to fill the NAN values

Input/output types:

input output
any any

Examples

Fills the NaN values with 0

> [12NaN3NaN] |dfr into-df|dfr fill-nan0
╭───┬───╮
# │ 0 │
├───┼───┤
01
12
20
33
40
╰───┴───╯

Fills the NaN values of a whole dataframe

> [[ab]; [0.21] [0.1NaN]] |dfr into-df|dfr fill-nan0
╭───┬──────┬───╮
# │  a   │ b │
├───┼──────┼───┤
00.201
10.100
╰───┴──────┴───╯

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_fill-nan.html