How to calculate the attribute and replace the number and letter to the calculated value in rapidmi.

User: "jabr"
New Altair Community Member
Updated by Jocelyn
In the dataset, we have an attribute size that contains the size of the app like 12M, 45K, etc. I would like to calculate the 12M as 12*1000000 and replace the value as 12000000 and for 45K as 45*1000 and replace the value as 45000.
I have added a map operator and given the regular expression. But it not calculating in the Rapid miner. Please help  
Sort by:
1 - 2 of 21
    User: "Caperez"
    Altair Community Member
    Accepted Answer
    Hi @jabr

    please find attached an example to convert it. 

    Best
    User: "lionelderkrikor"
    New Altair Community Member
    Accepted Answer
    Hi @jabr,

    In attached file, you can find a working process which performs the requested transformation. (....inspired by @ceaperez solution ... ;)

    The trick here is to : 
     - replace "M" by "*1000000" (and "k" by "*1000")
     - split (using the Split operator) based on the caracter "*" pattern which produce 2 new attributes (size_1 and size_2)
    - generate the requested attribute (New size) by multiplying "size_1 by "size_2"

    You can remove the intermediate attributes  (Size_1 and Size_2) by adding and selecting these 2 attributes in the Select Attributes operator.

    Hope this helps,

    Regards,

    Lionel