Filter rows based on categorical column

Author

Cox Lab

Published

November 15, 2023

1 General

2 Brief description

Those rows are kept or removed that have the specified value in the selected categorical column.

After this step, a new matrix is created that contains these values.

3 Parameters

3.1 Column

Selected categorical column the filtering is based on (default: first categorical column of the matrix).

3.2 Values

Rows with the containing values will be kept/discarded depending on the selected “Mode” (default: no values are selected).

3.3 Mode

The rows with the selected values will be kept/discarded depending on the selected “Mode” (default: “Remove matching rows”). If “Remove matching rows” is selected, rows having the values will be removed while all other rows will be kept. If “Keep matching rows” is selected, the opposite will happen.

3.4 Filter mode

The “Filter mode” defines, whether the input matrix will be reduced (“Reduce matrix” = default) or a new categorical column called “Filter” will be generated containing the categories “Keep” and “Discard” (“Filter mode” = “Add categorical column”).

4 Parameter window