Icon

Exercise1

<p><strong>Chapter 6/Exercise 1</strong></p><p>This is a simple reporting exercise similar to "Chapter 5/Exercise1".</p><p>The workflows reads <em>adult.csv</em> and then calculates a Pivot table displaying the number of occurrences for each workclass and income group.</p><p>After generating the Pivot table, the data is visualized in a table view and the distribution of work class and income groups are shown in a bar chart.</p>

URL: KNIME Beginner's Luck (Book Homepage) https://www.knime.com/knimepress/beginners-luck

Workflow: Chapter 6/Exercise 1


This is a simple reporting exercise similar to "Chapter 5/Exercise1".

The workflows reads adult.csv and then calculates a Pivot table displaying the number of occurrences for each workclass and income group.

After generating the Pivot table, the data is visualized in a table view and the distribution of work class and income groups are shown in a bar chart.

Reading data

Preparing data for reporting

Create report (dashboard)

Dashboard
Rename columns
Column Renamer
Count instancesby workclass andincome group
Pivot
adult.csv
CSV Reader
Ascendingby workclass
Sorter

Nodes

Extensions

Links