Icon

01. Tables - solution

Exercise on Table View and Tile View
Read the file:adult.csvavailable in data/Hint: use the File reader Filter out:Filter out people with amarriage statusindicating that they havenever been married.Hint: use the Row filter Assign colors to the table:Assign colors according to thesalary of each adult: Use red color for thoseearning less than 50K, greenfor those earning more than50K Table View:Inspect the data in an interactive view and filter them: only keep data for people who are 17 or18 years old.Get the final table containing "never married" marriage status 17 and 18 aged Table and Tile View:Group data on education showing average age for the educational groups. Get this result intothe table ordered as a tiles. Check the result in the preview and in interactive view. Before you do so, you should group data based on rounded age higher 50 greenlower 50 redAge 17 and 18Never married excludedAge 17 and 18Final datasetGrouped dataon educationGrouped data on educationin tableRound the meanof the ageGrouped data on educationin tilesAdult Color Manager Table View Row Filter Row Filter GroupBy Table View Round Double Tile View File Reader Read the file:adult.csvavailable in data/Hint: use the File reader Filter out:Filter out people with amarriage statusindicating that they havenever been married.Hint: use the Row filter Assign colors to the table:Assign colors according to thesalary of each adult: Use red color for thoseearning less than 50K, greenfor those earning more than50K Table View:Inspect the data in an interactive view and filter them: only keep data for people who are 17 or18 years old.Get the final table containing "never married" marriage status 17 and 18 aged Table and Tile View:Group data on education showing average age for the educational groups. Get this result intothe table ordered as a tiles. Check the result in the preview and in interactive view. Before you do so, you should group data based on rounded age higher 50 greenlower 50 redAge 17 and 18Never married excludedAge 17 and 18Final datasetGrouped dataon educationGrouped data on educationin tableRound the meanof the ageGrouped data on educationin tilesAdult Color Manager Table View Row Filter Row Filter GroupBy Table View Round Double Tile View File Reader

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: lenovo
Created at: 2020-07-29
On NodePit since: 2020-12-05
Last update: 2024-11-21
Created with KNIME version: v4.2.1
Tags: row filtercolor managerJavaScriptTable ViewTile View

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!