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

haasderhaasder Member Posts: 1 Newbie
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?


  • Options
    David_ADavid_A Administrator, Moderator, Employee, RMResearcher, Member Posts: 297 RM Research

    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)

  • Options
    Telcontar120Telcontar120 Moderator, 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.