Options

# 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

1,996RM Engineeringthat 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

48Contributor IIAnd 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