bigfunctions > quantize_into_bins

quantize_into_bins

Signature

quantize_into_bins(value, bin_bounds)

Description

Get the bin_range in which belongs value with bins defined by their bin_bounds.

Examples

EUUSeurope-west1

select bigfunctions.eu.quantize_into_bins(-4, [0, 1, 5, 10])

select bigfunctions.us.quantize_into_bins(-4, [0, 1, 5, 10])

select bigfunctions.europe_west1.quantize_into_bins(-4, [0, 1, 5, 10])

+-----------+
| bin_range |
+-----------+
| ]-∞, 0[   |
+-----------+

EUUSeurope-west1

select bigfunctions.eu.quantize_into_bins(3, [0, 1, 5, 10])

select bigfunctions.us.quantize_into_bins(3, [0, 1, 5, 10])

select bigfunctions.europe_west1.quantize_into_bins(3, [0, 1, 5, 10])

+-----------+
| bin_range |
+-----------+
| [1, 5[    |
+-----------+

EUUSeurope-west1

select bigfunctions.eu.quantize_into_bins(9, [0, 1, 5, 10])

select bigfunctions.us.quantize_into_bins(9, [0, 1, 5, 10])

select bigfunctions.europe_west1.quantize_into_bins(9, [0, 1, 5, 10])

+-----------+
| bin_range |
+-----------+
| [5, 10]   |
+-----------+

EUUSeurope-west1

select bigfunctions.eu.quantize_into_bins(130, [0, 1, 5, 10])

select bigfunctions.us.quantize_into_bins(130, [0, 1, 5, 10])

select bigfunctions.europe_west1.quantize_into_bins(130, [0, 1, 5, 10])

+-----------+
| bin_range |
+-----------+
| ]10, +∞[  |
+-----------+