dfr drop-nulls for dataframe

Drops null values in dataframe.

WARNING

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

Signature

> dfr drop-nulls {flags} (subset)

Parameters

  • subset: subset of columns to drop nulls

Input/output types:

inputoutput
anyany

Examples

drop null values in dataframe

> let df = ([[a b]; [1 2] [3 0] [1 2]] | dfr into-df);
    let res = ($df.b / $df.b);
    let a = ($df | dfr with-column $res --name res);
    $a | dfr drop-nulls
╭───┬───┬───┬─────╮
 # │ a │ b │ res │
├───┼───┼───┼─────┤
 0  1  2    1 
 1  1  2    1 
╰───┴───┴───┴─────╯

drop null values in dataframe

> let s = ([1 2 0 0 3 4] | dfr into-df);
    ($s / $s) | dfr drop-nulls
╭───┬─────────╮
 # │ div_0_0 │
├───┼─────────┤
 0        1 
 1        1 
 2        1 
 3        1 
╰───┴─────────╯