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