i just read a xlsx file with using read.xlsx(openxlsx).
but I got the result of having a different value like this picture.
this column contains both numeric and character data in xlsx.
why is it happening?
Asked
Active
Viewed 26 times
0
-
1Floating point error I believe - see this highly cited question: https://stackoverflow.com/questions/9508518/why-are-these-numbers-not-equal – thelatemail Mar 03 '20 at 04:13
-
thanks. Then, how can I move the original value? – jyhworld Mar 03 '20 at 04:32
-
`?round` the column to your desired number of significant decimals I reckon. – thelatemail Mar 03 '20 at 04:38
-
can i move them without any additional calculation in R? – jyhworld Mar 03 '20 at 04:44
-
Do the rounding in R after the import I mean. – thelatemail Mar 03 '20 at 04:44