Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

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

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!

Find more posts tagged with

AI Studio

Accepted answers

All comments

Marco_Boeck

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

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