Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
Sign in
  • KNIME Hub
  • knime
  • Spaces
  • Examples
  • 02_ETL_Data_Manipulation
  • 02_Aggregations
  • 08_More_GroupBy_Examples
WorkflowWorkflow

Workflow Demonstrating GroupBy Examples

aggregation groupby ETL CSV Writer CSV +2

Last update: 

Drag Workflow
Workflow preview
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.

Used extensions & nodes

Created with KNIME Analytics Platform version 4.1.1
  • KNIME Core Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

Legal

By downloading the workflow, you agree to our terms and conditions.

License (CC-BY-4.0)
Short link
Discussion
Discussions are currently not available, please try again later.

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2021 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits