Icon

03 Bringing Things Together

Bringing Things Together - Exercise

This workflow shows a hands-on exercise in the L1-DS Introduction to KNIME Analytics Platform for Data Scientists - Basics course

URL: KNIME Self-Paced Courses https://www.knime.com/knime-self-paced-courses

Task 1: GroupBy 1. Read the adult.csv file by executing the CSV Reader node 2. Calculate the total number of rows and average age by gender 3. Calculate the modes of all string columns separately for each native country 4. Calculate - the number of missing values in the occupation column - the number of non-missing rows in the occupation column - the number of rows in the occupation column - the number of rows in the marital-status column
Task 2: Pivoting 1. Read the adult_binned.csv file by executing the CSV Reader node 2. Calculate the number of people in groups according to their work class and age bin 3. Calculate the mode of education level in groups according to their work class and age bin
Task 3: Joiner 1. Read the adult_education.table and adult_income.xlsx files by executing the reader nodes 2. Join the education data with the other demographics data (adult.csv). Use inner join on the ID column. 3. Join the income data with the joined table. Apply the same settings as before.

Task 4: Concatenate

1. Execute the Table Reader node. The joined table from the previous task contains the records for all countries except Scotland. The records for Scotland are stored in this separate adult_scotland.table file.
2. Concatenate the two tables into one

  1. Calculate the number of each marital status

Read data adult_income.xlsx
Excel Reader
Bar Chart
Pivot
Table Reader
Read adult.csv
CSV Reader
Pivot
Concatenate
Read adult_education.table
Table Reader
Pivot
adult_scotland.table
Table Reader
Joiner
Joiner
GroupBy
GroupBy
Bar Chart
GroupBy
GroupBy

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: Maarit Laukkanen
Created at: 2020-04-20
On NodePit since: 2026-09-25
Last update: 2026-09-26
Created with KNIME version: v5.12.0
Tags: aggregationgrouppivotgroupbyjoinconcatenateeducation

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

Try NodePit Runner!