Icon

01a. 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 tilesColors onageGrouped data on educationin tilesGrouped data on educationin tableAdult Color Manager Table View Row Filter Row Filter GroupBy Table View Round Double Tile View Color Manager Tile View Table View CSV 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 tilesColors onageGrouped data on educationin tilesGrouped data on educationin tableAdult Color Manager Table View Row Filter Row Filter GroupBy Table View Round Double Tile View Color Manager Tile View Table View CSV 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: 2021-06-21
Last update: 2024-12-24
Created with KNIME version: v4.3.3
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!