Automatic normalization
A.numnorm()and P.numnorm(cn) can perform normalization on numeric variable.
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 |
=T("D:// house_prices_test.csv") |
3 |
=A1.numnorm("LotArea") |
4 |
=A2.numnorm@r("LotArea",A3(2)) |
A1 Import the model data
A2 Import the prediction data
A3 Perform normalization on the variable "LotArea", return the processing result and processing record
A4 According to A3's processing record, the variable"LotArea" is normalized on the prediction data. @r means to do the same thing on the prediction data
SPL Official Website 👉 https://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc_SPL
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