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
Read CSV expand fraction number (eg. 0.12 to 0.120)
CharlieFirpo
Member Posts: 48 Contributor II
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!
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!
0
Answers
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
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