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.

Convert Excel Formulas

mhalcro1mhalcro1 Member Posts: 1 Learner I
in Help

Hi, I'm an excel user and complete RM novice; I've got a large spreadsheet I'm trying to convert in RM to speed things up but can't get the formula to calculate the same.  It's not complex - it's adding up a series of cells; I'm looking for help to convert from Excel into RM language - please see Excel formula sample below (all cells are numerical)

=AB3+AE3+AJ3+AM3+AR3+AU3+AZ3+BC3+0.2*BH3+BK3+0.2*BP3+BS3+0.2*BX3+CA3+EE3*CF3+CI3+EE3*CM3+CP3+EE3*CT3+CW3+EE3*DA3+DD3

Any help greatly received!

TIA

Tagged:

Answers

  • Telcontar120Telcontar120 RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,635 Unicorn
    The operator Generate Aggregation is one operator that can be used, if you only need one operation at a time (such as sum or average) across multiple columns (called attributes in RapidMiner).
    However, for a formula like the one you have above, in which there are different operations as well as some hard-coded numerical scaling factors, then you would need to use Generate Attributes.  In that operator you can define a new attribute as a function of any number of existing attributes and can specify whatever sequence of operations that you want.  Take a look at the sample process in the help for that operator to see how it works.
      
    Brian T.
    Lindon Ventures 
    Data Science Consulting from Certified RapidMiner Experts
Sign In or Register to comment.