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.

Inappropriate and missing values

AmudhanAmudhan Member Posts: 1 Newbie
Attribute-1 has fem, female want to replace it as Female
Attribute-2 has zero or negative or null want to replace it with mean
Attribute-3 is category want to replace with mode
Attribute-4 with mode

Can it be done using one operator?


  • Options
    rjones13rjones13 Member Posts: 191 Unicorn
    Hi @Amudhan,

    To replace specific values in Attribute 1, I would look to use the Map operator. The remaining operations are hard to perform in a single operator. We can replace missing values with mean (numerical columns) and mode (categorical columns) using Replace Missing values with the setting "average", but the additional Attribute-2 logic will require first the calculation of the mean, and then replacing all zero or negative values with the mean. I would look to use Generate Attributes here.

    For Attributes-3 and 4, if you want the columns to just be constant columns, then you will first need to calculate the modes before setting those columns to be this value.

    Hope this helps,



Sign In or Register to comment.