Repository navigation
[R-Forge #5384] fread() fail to deal with missing values in integer64 columns #488
Description
Activity
I've just fallen over this bug too. To reproduce:
fread("x,y\n0,\n", colClasses = list(integer64 = "y")) ## x y ## 1: 0 9218868437227407266
Thank you (for this and all the other excellent work).
Thanks for this. The fix isn't quite complete though. It works when fread correctly auto-detects the column classes, but not when it has to bump a column to integer64.
To reproduce:
fread( "x,y 0,12345678901234 0, 0, 0, 0, , , , , , , , , , , , 12345678901234, 0, 0, 0, 0, 0, ")
In this example missing values still show as 9218868437227407266 in
xbut they are correctly missing iny.Thanks, will take a look asap.
Please write back if this is still not resolved.
Submitted by: Peter Stoyanov; Assigned to: Nobody; R-Forge link
Using
fread()to read in the data below yields strange results forNAvalues in columns whichfread()detects asinteger64. All other columns are OK:The resulting
data.tablehas "9218868437227407266" instead of "NA" in columns 8 and 9. Onlystr()prints these asNA, everything else I tried sees them as numeric values (min,max,sum, etc). Then againstr()prints out the fourth element of column 8 as "1.55e-314" instead of "3127133583".I posted this first here on StackOverflow but it did not generate any interest for 2 weeks, so I've linked it here as well.