User Tools

Site Tools


transformations:createbuckets

Create Buckets

Creates numerical ranges of fixed width and assigns each row to one of the ranges based on values in specified column.

The action is typically used for grouping number values (such as age) by intervals of fixed width (e.g. age group). Created group labels can later be used in reports and charts.

Example

Table before:

Age
23
29
19
34
35
41

Objective: create buckets of 10 year width and assign a bucket to each age.

Table after:

Age Age group
23 20 .. 30
29 20 .. 30
19 10 .. 20
34 30 .. 40
35 30 .. 40
41 40 .. 50
transformations/createbuckets.txt · Last modified: 2020/11/27 17:19 by dmitry