how to replace zero on dataset

[willson]

hi i have a dataset, on each column I have lot of zero value.
i want a methode to repcale zero with the mean. thanks

[AlexanderFillbrunn]

Hi,
Please take a look at the Missing Value node. I think that will do exactly what you need.
Kind regards
Alexander

Edit: I did not take into account that you have zeros instead of missing values. See @HansS’ post for information how to turn the zeros into missing values first.

[HansS]

Hi @willson

First with a Rule Engine Node you do: $column1$ > 0 => $column1$
so the column is duplicate and every 0 will return as a missing
With the Missing Value node you use the option to replace the missings by the mean value.

[willson]

@HansS

$column1$ > 0 => $column1$

but I have many column with different name, should I duplicate the rule node foreach column

[HansS]

Hi @willson
No, See this post. from another forum topic. You can use it as an example (replace the Rank node; with the Rule Engine and Missing Value node).

gr. Hans

[willson]

thanks but I use java snippet easy thanks lot