Icon

Exercise1

<p><strong>Chapter 5/Exercise 1</strong></p><p>This is a simple reporting exercise that prepares data for being exported to build a bar chart.</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>

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

Workflow: Chapter 5/Exercise 1


This is a simple reporting exercise that prepares data for being exported to build a bar chart.

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

Reading data

Preparing data for reporting

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

Nodes

Extensions

Links