Replace certain value with average?
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?
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?
Find more posts tagged with
Sort by:
1 - 2 of
21
Thank you very much that worked.
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