Binning
Abstract
Group numeric values into categories.
Group numeric values into categories.
There are 2 ways to divide columns: quantile and interval. By default, your data is automatically grouped based on the number of bins you specify. If you want to define the bins manually, toggle the button off.
Here's how the different options work:
Quantile. Equally divide values into bins. Each bin has an equal number of records, but the value range in each bin will be different. Returns the bin and the bin midpoint.
Interval. Equally divide a range of values into bins. The number of records in each bin will vary, but the value range in each bin is the same. Returns the bin and the bin midpoint.
When to use this tool
Use when you want to organize a column into categories.