Normalization technique inquiry

KNIME Analytics Platform
1

Hello KNIME Support Team.

I am trying to use a normalization node during data preprocessing.

The Normalizer node you provide only provides min-max and z-score, but I want to apply Maxabs and Robust techniques and those options don’t seem to exist.

Which node should I use to use Maxabs and Robust normalization techniques?

Any help would be greatly appreciated.

2

Hi,

at least for the max-abs normalization you can use the math-node.
Here’s the source I for the math:
Feature Scaling: Standardization vs. Normalization And Various Types of Normalization | Minkyung’s blog

image
image768×346 16.1 KB

In my case, the column to be normalized is “EquivDiameter”

image
image847×591 18.8 KB

3 Likes
3

Hello, I am trying to use the MaxAbs Scaler as you suggested, but the Math Formula node is not working. Do you know what might be the issue? I have confirmed that there are no missing values in the columns.\

image
image865×715 26 KB

4

Hmm, that’s an error I’ve never seen.
I would check following:

  • remove everything in the Expression pane
  • double click COL_MAX(col_name) in the Function pane
  • set the curser between the brackets
  • doube click Fare Column

Does this work?

5

Thank you for your response. @ActionAndi

I can utilize the math formula when there is only one column, but I don’t think it can be applied to a variable number of column names and numbers.

Maxabs can be implemented through various methods, but there is no robust way to do it, right?

Your answer would be appreciated.

6

Hi Minyoung. @mychoi

I don’t think there should be any nesting inside the Col_MAX() function, do you understand?

Thank you.

7

Nesting the abs-Function in the COL_MAX call is working (at least in my installation).

@JaeHwanChoi: You can use the “math formula (Multi-Column)” node to apply this function to several columns. Is this what you are looking for?

If not, could you provide a formula or example how the computation or result should look like?

8

I understand how to use math formula (Multi-Column).

Thanks @ActionAndi

I think the nesting feature of COL_MAX is a version difference of KNIME, I am currently using two versions 5.4.1 and 5.4.2, but neither version works. Can you tell me which version you are using?

Also, are there any other nodes besides Maxabs that can utilize Robust?

I would be grateful for any answers.