Hub
Pricing About
WorkflowWorkflow

Workflow Demonstrating GroupBy Examples

AggregationGroupbyETLCSV WriterCSV
+2
knime profile image
Draft Latest edits on 
Jan 31, 2017 4:56 PM
Drag & drop
Like
Download 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.
Loading deploymentsLoading ad hoc jobs

Used extensions & nodes

Created with KNIME Analytics Platform version 4.1.1
  • Go to item
    KNIME CoreTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

    knime profile image
    knime

Legal

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

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits