Skip to content
Prev 209874 / 398500 Next

Loss of precision when importing data into R

Hanke, Alex-2 wrote:
If the fields of interest are rounded to one decimal place in the file then
that most likely means the loss of precision is occurring in the program you
are using to generate the CSV file-- not in the R importation step.

I seem to remember either Excel or OpenOffice calc having a nasty habit of
exporting to CSV what is *displayed* in the spreadsheet-- not what is
actually entered to each cell.  I.E. the numbers that end up in your file
are subject to the display precision that was set on the cells in your
spreadsheet.

Hope this helps!

-Charlie