The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 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

How replace missing values with average 0 decimals after the comma (for example: 8 in stead of 8.23)

haasderhaasder Member Posts: 1 Learner I
edited June 2019 in Help
I have some missing ages in my dataset. I want to replace them with averages with zero decimals after the comma, so with no commas. Can someone help me?
Tagged:

Answers

  • David_ADavid_A Administrator, Moderator, Employee-RapidMiner, RMResearcher, Member Posts: 297 RM Research
    Hi,

    you can use the Generate Attributes operator to round the numbers (function round(), ceil() or floor()).
    If you only want to round the replaced values. I would generate a temporary flag attribute before the replacement (if(missing(att1), 1,0) ) and then later only apply the rounding to those examples, were the flag is true:
    if(flag=TRUE, round(att1), att1)

    Best,
    David
  • Telcontar120Telcontar120 RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,635 Unicorn
    You can also use Format Numbers and then specify whatever pattern you want.

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