how to include decimal in number when importing xl...

# datascience

[Ume Channel]

how to include decimal in number when importing xlxs

[Andrei Kislitsyn]

Can you please specify? Number values should be completely preserved. Try converting to Double from the previous thread, does it help?

[Ume Channel]

Nope - I update the xlxs data but it doesn't include decimals when I read the xlxs using dataFrame

[Andrei Kislitsyn]

Could you please specify in what column?

[Ume Channel]

I am specifying the all overflow numbers when it becomes E notation

[Andrei Kislitsyn]

You mean numbers that don't fit in Double? Do you want to parse them as BigDecimal?

[Ume Channel]

It fit but it display E-notation - I don't know if I solve it in a best case - I make it Big decimal

[Andrei Kislitsyn]

So, it's only display problem? With a workaround I wrote in a previous thread (I applied convert to Double? for all columns with wrong type), all E notations are gone in display, see screenshots. Do you still have them?

[Ume Channel]

Wow amazing, Thanks. The problem solved