Discretize (bin) numerical values

This processor groups numbers into bins (intervals).

Fixed length intervals mode

  • Bins width: difference between the lower and upper bounds of each bin (ex: 2 generates ...,-2:0, 0:2, 2:4, ...). The lower bound is included and the upper bound is excluded.
  • minimum/maximum value: The output for an out of range value is an empty cell. If a minimum value is specified, it is used to compute the offset (ex: with width=2 and minimum=0.5, the generated bins will be 0.5:2.5, 2.5:4.5, 4.5:6.5, ...).

Custom mode

You can specify couples of lower and upper bounds, the intervals should be disjoint. If a bound is not specified, +/- infinity is used. The output for an out of range value is an empty cell.