Orange Forum • View topic - Error importing integers in txt/csv files

Error importing integers in txt/csv files

Report bugs (or imagined bugs).
(Archived/read-only, please use our ticketing system for reporting bugs and their discussion.)
Forum rules
Archived/read-only, please use our ticketing system for reporting bugs and their discussion.

Error importing integers in txt/csv files

Postby JamHan » Thu Dec 02, 2010 6:32

I've come across an unusual bug in Orange 2.0b (Windows 7 x64).
Loading a file with the following data (tab or comma delimited):

Code: Select all
AUD    2000101      0.79870
AUD    20000101     0.79870
AUD    220000101    0.79870

results in a data table that looks like this:

Code: Select all
AUD    2000101      0.79870
AUD    20000100     0.79870
AUD    220000096    0.79870


It seems when the number has more than 7 digits something goes wrong.

Postby marko » Thu Dec 02, 2010 9:54

Orange stores continuous attribute in floats (32-bit floating point numbers, IEEE754). Floats can represent integers exactly with 24 bits of precision (from -2^23..2^23-1 or from -8388608..8388607). An number larger than that will not be represented exactly.

We believe that higher accuracy for continuous values is not needed for learning. If you would like to store big numbers (such as telephone numbers) exactly, use StringVariable.


Return to Bugs