You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When loading a csv file with big numbers the data on the table view where you select data types is correct, but the output data truncates the numbers. For example, the following number:
-22112248,96
Got converted (output only) to:
-2.211225e+07
Please note this is using european notation, that is "," as decimal separator.
Trying to reproduce the problem in Pandas I noted that when you print such number to your terminal you get "-2.211225e+07", but if you save it to a csv (using df.to_csv) the number ouputs correctly.
To correctly print the number on the terminal you need to include the following:
pd.options.display.float_format = "{:.2f}".format
How can we reproduce the problem?
I managed to reproduce it by importing a csv with this number:
-22112248,96
But it should work with similar numbers in size and format
What's your environment?
Operating system: Windows 11
Orange version: 3.37.0
How you installed Orange: Windows installer
The text was updated successfully, but these errors were encountered:
What's wrong?
When loading a csv file with big numbers the data on the table view where you select data types is correct, but the output data truncates the numbers. For example, the following number:
-22112248,96
Got converted (output only) to:
-2.211225e+07
Please note this is using european notation, that is "," as decimal separator.
Trying to reproduce the problem in Pandas I noted that when you print such number to your terminal you get "-2.211225e+07", but if you save it to a csv (using df.to_csv) the number ouputs correctly.
To correctly print the number on the terminal you need to include the following:
pd.options.display.float_format = "{:.2f}".format
How can we reproduce the problem?
I managed to reproduce it by importing a csv with this number:
-22112248,96
But it should work with similar numbers in size and format
What's your environment?
The text was updated successfully, but these errors were encountered: