dfr is-in
for dataframe
Checks if elements from a series are contained in right series.
Signature
> dfr is-in (other)
Parameters
other
: right series
Examples
Checks if elements from a series are contained in right series
> let other = ([1 3 6] | dfr into-df);
[5 6 6 6 8 8 8] | dfr into-df | dfr is-in $other
╭───┬───────╮
│ # │ is_in │
├───┼───────┤
│ 0 │ false │
│ 1 │ true │
│ 2 │ true │
│ 3 │ true │
│ 4 │ false │
│ 5 │ false │
│ 6 │ false │
╰───┴───────╯
dfr is-in
for expression
Creates an is-in expression.
Signature
> dfr is-in (list)
Parameters
list
: List to check if values are in
Examples
Creates a is-in expression
> let df = ([[a b]; [one 1] [two 2] [three 3]] | dfr into-df);
$df | dfr with-column (dfr col a | dfr is-in [one two] | dfr as a_in)
╭───┬───────┬───┬───────╮
│ # │ a │ b │ a_in │
├───┼───────┼───┼───────┤
│ 0 │ one │ 1 │ true │
│ 1 │ two │ 2 │ true │
│ 2 │ three │ 3 │ false │
╰───┴───────┴───┴───────╯