KNIME logo
Contact SalesDownload
Back to all templates

How to Aggregate Data

Aggregating data means combining records to produce summary statistics, such as averages or totals, grouped by a specific category. This approach helps you quickly understand patterns and differences within your data.

Data basics how-toData Transformation
Header icon
Workflow
70%
How to Aggregate Data

How This Workflow Works

This workflow summarizes the average number of hours worked per week for each education group in the Adult dataset. It groups the data by education level and calculates the mean hours, making it easy to compare work patterns across education categories.

Key Features:

  • Summarize work hours by education level
  • Identify patterns in work behavior across groups
  • Simplify complex datasets into actionable insights

Step-by-step:

1. Group Data by Education Level:

The workflow organizes the dataset by each unique education category, setting the stage for targeted analysis within each group.

2. Calculate Average Work Hours: 

For every education group, it computes the mean number of hours worked per week. This step distills the raw data into clear, comparable figures for each category.

How to Get Started