Icon

03 Bringing Things Together - Solution

Bringing Things Together - Exercise (Solution)
Task 1: GroupBy1. Read the adult.csv file by executing the CSV Reader node2. Calculate the total number of rows and average age by gender3. Calculate the modes of all string columns separately for each native country4. 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: Pivoting1. Read the adult_binned.csv file by executing the CSV Reader node2. Calculate the number of people in groups according to their work class and age bin3. Calculate the mode of education level in groups according to their work class and age bin Task 3: Joiner1. Read the adult_education.table and adult_income.xlsx files by executing the reader nodes2. 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: Concatenate1. Execute the Table Reader node. The joined table from the previous task contains the records for allcountries except Scotland. The records for Scotland are stored in a separate adult_scotland.table file.2. Concatenate the two tables into one The total number of rows and average age by genderThe number of missing and non-missing values in occupationand total rows in occupation and in marital-statusCreate the table with age-bin as a groupand workclass as a pivot and calculatethe number of people in groupsThe modes of string columns by native countryCreate the table with age-bin as a group and workclass as a pivot and find the mostwidespread level of education in the private workclassRead dataadult_income.xlsxRead adult.csvRead adult_binned.csvadult_scotland.tableRead adult_education.table GroupBy GroupBy Pivoting GroupBy Pivoting Concatenate Excel Reader CSV Reader CSV Reader Table Reader Joiner Joiner Table Reader Task 1: GroupBy1. Read the adult.csv file by executing the CSV Reader node2. Calculate the total number of rows and average age by gender3. Calculate the modes of all string columns separately for each native country4. 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: Pivoting1. Read the adult_binned.csv file by executing the CSV Reader node2. Calculate the number of people in groups according to their work class and age bin3. Calculate the mode of education level in groups according to their work class and age bin Task 3: Joiner1. Read the adult_education.table and adult_income.xlsx files by executing the reader nodes2. 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: Concatenate1. Execute the Table Reader node. The joined table from the previous task contains the records for allcountries except Scotland. The records for Scotland are stored in a separate adult_scotland.table file.2. Concatenate the two tables into one The total number of rows and average age by genderThe number of missing and non-missing values in occupationand total rows in occupation and in marital-statusCreate the table with age-bin as a groupand workclass as a pivot and calculatethe number of people in groupsThe modes of string columns by native countryCreate the table with age-bin as a group and workclass as a pivot and find the mostwidespread level of education in the private workclassRead dataadult_income.xlsxRead adult.csvRead adult_binned.csvadult_scotland.tableRead adult_education.table GroupBy GroupBy Pivoting GroupBy Pivoting Concatenate Excel Reader CSV Reader CSV Reader Table Reader Joiner Joiner Table 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: Maarit Laukkanen
Created at: 2020-04-20
On NodePit since: 2022-11-24
Last update: 2024-11-21
Created with KNIME version: v4.6.1
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!