filter-rows-numerically

Finds rows in a datatable that match a numeric comparison using the `>`, `>=`, `<` or `<=` operators.

Note that non-numeric values in the search column, including empty (null) values, may cause problems:

TIP: You may want to send your data through the filter-blank-values adaptor before this filter-rows-numerically adaptor, if you want to filter numerically only the rows that have numeric values.

Arguments

Inputs:

data: The datatable to be filtered.

column: The name of the column to be filtered.

operator: One of <, <=, >, or >=.

check: The number to be used for the comparison operation.

Output:

data: A datatable containing the rows where the selected column matches the numerical comparison. This will be empty if there are no matches.

complementary: A datatable containing the rows where the selected column does not match the numerical comparison. This will be empty if all rows match the numerical comparison.

Possible use cases

• Finding sequencing samples with a low quality metric.

• Finding epidemiology samples from a specific age range.