Icon

03_​Basic_​Row_​Filter_​Component_​Answer

06_Basic_Row_Filter - Solution

Solution to an e-learning course exercise. Filter rows with the Row Filter node.



Exercise Basic Row Filter1) Read data adult.csv available in the "data" folder2) Filter out rows where the marital status is missing3) Extract rows where - the marital status is divorced- the marital status is never married and age is between 20 and 40 (both included)- the workclass starts with "S" Read the adult datasetWrite cleansed datato a'adult_cleansed' excel file File Reader Excel Writer Data Cleansing Exercise Basic Row Filter1) Read data adult.csv available in the "data" folder2) Filter out rows where the marital status is missing3) Extract rows where - the marital status is divorced- the marital status is never married and age is between 20 and 40 (both included)- the workclass starts with "S" Read the adult datasetWrite cleansed datato a'adult_cleansed' excel file File Reader Excel Writer Data Cleansing

Nodes

Extensions

Links