dfr drop-nulls for dataframe

Drops null values in dataframe.

Signature

> dfr drop-nulls (subset)

Parameters

  • subset: subset of columns to drop nulls

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 │
├───┼───┼───┼─────┤
│ 0121 │
│ 1121 │
╰───┴───┴───┴─────╯

drop null values in dataframe

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