Max Abs Scaler
Dataset Bank
| SrNo | Balance | Pdays | y |
|---|
| 1 | 1787 | -1 | no |
| 2 | 4789 | -339 | no |
| 3 | 1350 | 330 | no |
| 4 | 1476 | -1 | no |
| 5 | 0 | -1 | no |
| 6 | 747 | 176 | no |
| 7 | 307 | 330 | no |
$$x_{scale}=\frac{x_i}{|x_i|_{max}}$$
WITH CTE AS(
SELECT MAX(ABS(Balance)) BalanceMaxAbs, MAX(ABS(Pdays)) AS PdaysMaxAbs
FROM Shop.Bank
)
SELECT SrNo, Balance / CTE.BalanceMaxAbs AS BalanceScale, pdays / CTE.PdaysMaxAbs AS PdayScale, Y
FROM Shop.Bank, CTE
ORDER BY SrNo;Method 2
SELECT SrNo, Balance / (MAX(ABS(Balance)) OVER()) AS BalanceScale, Pdays / (MAX(ABS(Pdays)) OVER()) AS PdayScale, Y
FROM Shop.Bank ORDER BY SrNo;
| SrNo | Balance Scale | Pdays Scale | y |
|---|
| 1 | 0.373146795 | -0.002949853 | no |
| 2 | 1 | -1 | no |
| 3 | 0.281896012 | 0.973451327 | no |
| 4 | 0.308206306 | -0.002949853 | no |
| 5 | 0 | -0.002949853 | no |
| 6 | 0.15598246 | 0.519174041 | no |
| 7 | 0.064105241 | 0.973451327 | no |