05_More_Row_Filter_Examples

This example workflow shows more row filtering.

Reset the File Reader node to re-execute the workflow, then follow the steps below on your own:

Based on the adult.csv data set:

1. Exclude rows where marital-status is missing using a Row Filter node.

2. On the remaining rows, filter on Nominal Values:

   1. extract rows where marital-status = "Divorced" using a Row Filter node

   2. extract rows where marital-status = "Divorced" OR "Separated" using a Nominal Value Row Filter node

   3. extract rows where marital-status = "Divorced" OR "Separated" using a Reference Row Filter node

3. On the remaining rows, filter on multiple criteria:

   1. extract rows where marital-status = "Never-married" AND 20 <= age <= 40 AND workclass starts with "S" using a single Row Filter node with multiple criteria.

   2. extract rows where marital-status = "Never-married" AND 20 <= age <= 40 using a Rule-based Row Filter node.