Replace certain value with average?

emkoirl

I am currently working with a dataset for an assignment, that has a lot of values set to 0 in it (such as weight) and is therefore skewing the data..
I want to replace all 0 values with the average values of that column.

I have tried using replace missing values operator and setting the type to numeric value filter, with the numeric condition of "= 0".. But it is not working for some reason.

Is there any way to do this?

[Deleted User]

Hi emkoirl,

Missing values are represented by a question mark (?) in RapidMiner.

Therefore you have to declare the 0 values as missing (using the Declare Missing Values Operator) before you can replace them with the Replace Missing Values Operator.

Best,
Edin

emkoirl

Thank you very much that worked.