Extract range¶
fast step binning
Create a copy of a column nullifying values outside a specified range.
For columns containing dates, numbers or lists of numbers, values from inside a list are removed, nullifying the list itself when becoming empty.
Usage¶
The following are the step's expected inputs and outputs and their specific types.
extract_range(col_in: date|number|list[number], {"param": value}) -> (col_out: column)
where the object {"param": value}
is optional in most cases and if present may contain any of the parameters described in the
corresponding section below.
Example¶
Replace values outside of range [rangeLeft, rangeRight) with nulls:
extract_range(col_in, {"rangeLeft": 200, "rangeRight": 800}) -> (col_out)
Inputs¶
col_in: column:date|number|list[number]
A column to extract the range from.
Outputs¶
col_out: column
Parameters¶
rangeLeft: number | string
Inclusive left boundary of the selection's range.
Example parameter values:
200
-0.7
"2021-05-07T13:17:53Z"
rangeRight: number | string
Exclusive right boundary of the selection's range.
Example parameter values:
800
-0.2
"2022-07-07T12:15:03Z"