Icon

13_​Classic_​Aggregations_​with_​GroupBy_​Node - Solution

13_Classic_Aggregations_with_GroupBy_Node - Solution
Exercise GroupBy1) Read data adult.csv available in the "data" folder2) Calculate the total number of rows and average age for all women with income >50K3) Calculate the averages of all numerical columns for each one of the 4 groups defined bysex and income values4) 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! The total number of rows and average ageThe averages of all numerical columns for the4 groups defined by sex and income valuesThe number of missing and non-missing values in occupationand total rows in occupation and in marital-statusRead data adult.csvFilter women withincome >50K GroupBy GroupBy GroupBy File Reader Rule-basedRow Filter Exercise GroupBy1) Read data adult.csv available in the "data" folder2) Calculate the total number of rows and average age for all women with income >50K3) Calculate the averages of all numerical columns for each one of the 4 groups defined bysex and income values4) 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! The total number of rows and average ageThe averages of all numerical columns for the4 groups defined by sex and income valuesThe number of missing and non-missing values in occupationand total rows in occupation and in marital-statusRead data adult.csvFilter women withincome >50K GroupBy GroupBy GroupBy File Reader Rule-basedRow Filter

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: 2020-08-06
Last update: 2024-05-03
Created with KNIME version: v4.1.2
Tags: e-learningaggregationgroupeducation

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

Try NodePit Runner!