The Altair Community is migrating to a new platform to provide a better experience for you. The RapidMiner Community will merge with the Altair Community at the same time. In preparation for the migration, both communities are on read-only mode from July 15th - July 24th, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here.

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?


  • Options
    [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.

  • Options
    emkoirlemkoirl Member Posts: 3 Contributor I
    Thank you very much that worked.
Sign In or Register to comment.