Discretize (bin) numerical values
Group numbers into bins (intervals).
Options
Input columns
Number column to transform into bin.
Binning mode
Choose from two binning modes:
-
Fixed size intervals: Define bin width to create bins of equal width. For example,
2
generates...,-2:0, 0:2, 2:4, ....
-
In each bin, the lower bound is included and the upper bound is excluded.
-
Minimum value: Set a minimum value N below which the corresponding bin will be < N . This also creates an offset for the bins: with
width=2
andminimum=0.5
, the generated bins will be0.5:2.5, 2.5:4.5, 4.5:6.5, ...
-
Maximum value: Set a maximum value N above which the corresponding bin will be >= N.
-
-
Custom, use raw values: specify non-overlapping intervals to create bins.
-
In each bin, the lower bound is included and the upper bound is excluded.
-
If a bound isn’t specified, +/- infinity will be used.
-
The output bin for a value that is out of the ranges will be an empty cell.
-
Output column
Perform the binning in an additional output column or leave it empty to perform the binning in place.