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