Icon

08_​More_​GroupBy_​Examples

Workflow Demonstrating GroupBy Examples

Using the adult.csv data set: on each one of the 4 groups defined by sex and income values, calculate the total number of rows and average age and write the results to a CSV file; on each one of the 4 groups defined by sex and income values, calculate the average of all numerical columns; on full input table count: a) rows with missing values in column occupation; b) all rows in column occupation; c) rows with no missing value in column occupation; d) all rows in another column (i.e. marital-status).

Notice that this number should be the same as the number in 2.

Average age and row count for(sex, income) groups Count Rows Average of all numerical columnsfor (sex, income) groups Workflow demonstrating Groupby examples.For more information see the workflow metadata. Find it here: View -> Description Readingadult.csvon full input table count:1. rows with missing values in occupation2. all rows in occupation3. rows with no missing value in occupation4. all rows in another column(notice that this should be the same number as in 2.)count total number of rows and calculate avg agein the 4 groups definedby sex and incomeaverage of all numerical columnsin the 4 groups definedby sex and incomewrite to: knime://knime.workflow/data/resultingTable.csv File Reader GroupBy GroupBy GroupBy CSV Writer Average age and row count for(sex, income) groups Count Rows Average of all numerical columnsfor (sex, income) groups Workflow demonstrating Groupby examples.For more information see the workflow metadata. Find it here: View -> Description Readingadult.csvon full input table count:1. rows with missing values in occupation2. all rows in occupation3. rows with no missing value in occupation4. all rows in another column(notice that this should be the same number as in 2.)count total number of rows and calculate avg agein the 4 groups definedby sex and incomeaverage of all numerical columnsin the 4 groups definedby sex and incomewrite to: knime://knime.workflow/data/resultingTable.csv File Reader GroupBy GroupBy GroupBy CSV Writer

Nodes

Extensions

  • No modules found

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: rosy
Created at: 2017-01-31
On NodePit since: 2025-02-18
Last update: 2026-07-17
Created with KNIME version: v4.1.1
Tags: aggregationgroupbyETLCSV WriterCSVfile writerIO

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

Try NodePit Runner!