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

Replace numeric base on condition from other columns

mengkoon007mengkoon007 Member Posts: 30 Contributor I
edited November 2018 in Help

Hi,

 

I have created a few macro as below:

  1. c_senior (value: 220)
  2. c_assistant (value: 150)

 

May someone kindly advise how can I replace the value in a column (eg. Rate) based on the condition from other columns?

Example: I would need to change the Rate column value from 200 to 220 if 

  • Column "badge_id" start with "E" and
  • Column "rank" is "senior"
Tagged:

Answers

  • Options
    Telcontar120Telcontar120 Moderator, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,635 Unicorn

    The "Generate Attrbute" operator should be able to do the trick, since it supports boolean logic and compound statements, although if required information is contained in an attribute (column) name, then you first need to extract it and make it an attribute value that can be referenced. 

     

    Brian T.
    Lindon Ventures 
    Data Science Consulting from Certified RapidMiner Experts
Sign In or Register to comment.