Icon

03 Row and Column Filtering

03 Row and Column Filtering
Exercise: Column Filtering1) Read the adult_education.table file by executing the Table Reader node2) Exclude the "education-num" column- manually- by including only string type columns Exercise: Row Filtering1) Read the adult.csv file by executing the CSV Reader node2) 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"5) How many adults are- divorced?- never married?- never married and between 20 and 40 years old?- with work class State-gov, Self-emp-not-inc, or Self-emp-inc? Filter out rows where the marital status is missingDivorcedWorkclass starts with "S"Never-marriedNever married and ageis between 20 and 40Exclude education-nummanuallyExclude education-numby type selectionadult.csvRead adult_education.table Row Filter Row Filter Row Filter Row Filter Row Filter Column Filter Column Filter CSV Reader Table Reader Exercise: Column Filtering1) Read the adult_education.table file by executing the Table Reader node2) Exclude the "education-num" column- manually- by including only string type columns Exercise: Row Filtering1) Read the adult.csv file by executing the CSV Reader node2) 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"5) How many adults are- divorced?- never married?- never married and between 20 and 40 years old?- with work class State-gov, Self-emp-not-inc, or Self-emp-inc? Filter out rows where the marital status is missingDivorcedWorkclass starts with "S"Never-marriedNever married and ageis between 20 and 40Exclude education-nummanuallyExclude education-numby type selectionadult.csvRead adult_education.table Row Filter Row Filter Row Filter Row Filter Row Filter Column Filter Column Filter CSV Reader Table Reader

Nodes

Extensions

Links