Read CSV expand fraction number (eg. 0.12 to 0.120)

CharlieFirpo
CharlieFirpo New Altair Community Member
edited November 5 in Community Q&A
Dear all!

I have a CSV that contains fraction numbers: 0.11; 0.12; 0.13... Read CSV operator changes these numbers to 0.110; 0.120; 0.130. Why? How can I keep the original numbers?

Thank you!
Tagged:

Answers

  • Marco_Boeck
    Marco_Boeck New Altair Community Member
    Hi,

    that is still the original number ;)
    However you can instruct RapidMiner to only use 2 fraction digits, to do so click Tools -> Preferences -> General and edit the setting which says 'rapidminer.general.fractiondigits.numbers' from 3 to 2.

    Regards,
    Marco
  • CharlieFirpo
    CharlieFirpo New Altair Community Member
    Thank you!

    And what if I have 0.11 and 0.123 numbers?
    If I save the result with Write CSV then I will have the correct number of digits, so there will be no extra zeros. But if I use the Read CSV output at Generate Report, then my report will contain 3 digit numbers: 0.110; 0.120. If I set 'rapidminer.general.fractiondigits.numbers' from 3 to 2 then my 0.123 number will change into 0.12 and the report will conatin this, not the original :(

Categories