Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
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