Icon

06 Aggregations

06 Aggregations
Exercise: 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 Notice that the last two aggregations should provide the same numbers! Exercise: 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 bin- What is the most common combination of age bin and work class? 34 or less w/ work classof "Private"- How many people belong to this group? 10,9363) Calculate the mode of education level in groups according to their work class and age bin- What is the most widespread education level in the private workclass independently of theage bin? HS-grad Read adult.csvRead adult_binned.csvtotal # of rowsand average ageby genderthe # of missing values, non-missing rows and # of rows in the occupation columnand the # of rows in the marital-status columnmodes of all stringcolumns for each native countrythe number of people in groups according to their work class and age bin the mode of education level in groups according to their work class and age bin CSV Reader CSV Reader GroupBy GroupBy GroupBy Pivoting Pivoting Exercise: 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 Notice that the last two aggregations should provide the same numbers! Exercise: 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 bin- What is the most common combination of age bin and work class? 34 or less w/ work classof "Private"- How many people belong to this group? 10,9363) Calculate the mode of education level in groups according to their work class and age bin- What is the most widespread education level in the private workclass independently of theage bin? HS-grad Read adult.csvRead adult_binned.csvtotal # of rowsand average ageby genderthe # of missing values, non-missing rows and # of rows in the occupation columnand the # of rows in the marital-status columnmodes of all stringcolumns for each native countrythe number of people in groups according to their work class and age bin the mode of education level in groups according to their work class and age bin CSV Reader CSV Reader GroupBy GroupBy GroupBy Pivoting Pivoting

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-02-24
Last update: 2024-05-03
Created with KNIME version: v4.5.1
Tags: aggregationgrouppivotgroupby

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

Try NodePit Runner!