Icon

08_​More_​GroupBy_​Examples

Workflow Demonstrating GroupBy Examples
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

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: 2019-07-12
Last update: 2024-04-26
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!