Numerical
Numerical columns contain numbers. The defining aspect of numerical data is that the numbers have an order and you can apply a variety of mathematical computations to them (average, sum, etc.) The actual values may follow a specific format, such as being rounded to 2 decimal digits and remaining between min/max bounds.

For example, you might be storing product purchase amounts (USD) with 2 decimal digits. You might be storing the ages of your customers as whole numbers that must be 18 or above.
If the data is stored a integers, it does not mean it's necessarily numerical. For example, HTTP response codes such as
200
, 404
, etc. are stored as integers but they are distinct categories. They cannot be combined or averaged.Use Gaussian Mixture Models to cluster and normalize the data.
Use a probability integral transform to normalize the data.
* These features are only available for licensed users. To learn more about purchasing a license, get in touch with us.
Last modified 1mo ago