Good day! Hello how to fix when the number is over...

# datascience

[Ume Channel]

Good day! Hello how to fix when the number is overflow - like 1,927,384,739 becomes 1.927384739E9 - I don't want it to be expressed as E Notation

pjTDYzyiTmEte21D_oIlIY6HL8t_5FH7f-Global Library Data.xlsx

[Ume Channel]

Screenshot from 2025-04-30 07-15-29.png

[Andrei Kislitsyn]

Hi! Is it only related to visual output?

[Andrei Kislitsyn]

Oh I see now. There's a bug with type determination. This column should be of type Double? but has mixed values of String (empty ones) and Double . Moreover, there's a bug with generating extension properties for column access, because this DF contains a column with a line break in name ("Expenditures...").

[Andrei Kislitsyn]

I'll add issues with these 2 bugs, here's a workaround:
1. use rename or renameToCamelCase . renameToCamelCase doesn't work properly enough in the stable, but already works great on dev. On stable you'll get this

[Andrei Kislitsyn]

2. convert values in this column to Double? with a custom converter:

[Andrei Kislitsyn]

image.png

[Andrei Kislitsyn]

This should solve your problem, but feel free to ask!

[Andrei Kislitsyn]

issue: https://github.com/Kotlin/dataframe/issues/1166