Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.

Inappropriate and missing values

AmudhanAmudhan Member Posts: 1 Learner I
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?

Answers

  • rjones13rjones13 Member Posts: 200 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,

    Best,

    Roland

Sign In or Register to comment.