Min-Max standardization
It is a linear transformation of the original data to map the result value to [0 - 1].
Conversion function:x∗=x−min/max−min,max:max value of sample,min:min value of sample
For example, the "LotArea" in the house price data is an order of magnitude larger variable, Standardize it as follow:
A |
|
1 |
=T("D://house_prices_train.csv") |
2 |
=A1.max(LotArea) |
3 |
=A1.min(LotArea) |
4 |
=A1.run(LotArea=(LotArea-A3)/(A2-A3)) |
Before standardization After standardization
SPL Official Website 👉 https://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProcSPL
SPL Learning Material 👉 https://c.scudata.com
SPL Source Code and Package 👉 https://github.com/SPLWare/esProc
Discord 👉 https://discord.gg/cFTcUNs7
Youtube 👉 https://www.youtube.com/@esProc_SPL