Replace certain value with average?

emkoirlemkoirl Member Posts: 3 Contributor I
edited November 2018 in Help
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?

Answers

  • [Deleted User][Deleted User] Posts: 0 Learner II
    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
  • emkoirlemkoirl Member Posts: 3 Contributor I
    Thank you very much that worked.
Sign In or Register to comment.