Skip to content

[R-Forge #5384] fread() fail to deal with missing values in integer64 columns #488

Closed
Closed
[R-Forge #5384] fread() fail to deal with missing values in integer64 columns#488
Assignees
arunsrinivasan
Labels
bug
Milestone
v1.9.6

Description

@arunsrinivasan
arunsrinivasan
opened on Jun 8, 2014

Submitted by: Peter Stoyanov; Assigned to: Nobody; R-Forge link

Using fread() to read in the data below yields strange results for NA values in columns which fread() detects as integer64. All other columns are OK:

2012,276,,0,"S1","001",1,,724135215,1590915056,
2012,276,2,8,"S1","001",1, ,,154598,0
2012,276,2,12,"S1","001",1,NA,5118863,21819477,
2012,276,2,0,"S1","011",8,3127133583,3127133583,9003982501,0

The resulting data.table has "9218868437227407266" instead of "NA" in columns 8 and 9. Only str() prints these as NA, everything else I tried sees them as numeric values (min, max, sum, etc). Then again str() 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.

Activity

  1. richierocks commented on Mar 15, 2015

    @richierocks
    richierocks
    on Mar 15, 2015

    I've just fallen over this bug too. To reproduce:

    fread("x,y\n0,\n", colClasses = list(integer64 = "y"))
##    x                   y
## 1: 0 9218868437227407266
  2. arunsrinivasan
    closed this as completedin a71e21don Mar 15, 2015
  3. arunsrinivasan
    added this to the v1.9.6 milestone on Mar 15, 2015
  4. arunsrinivasan
    self-assigned this
    on Mar 15, 2015

  5. pstoyanov commented on Mar 15, 2015

    @pstoyanov
    pstoyanov
    on Mar 15, 2015

    Thank you (for this and all the other excellent work).

  6. richierocks commented on Mar 17, 2015

    @richierocks
    richierocks
    on Mar 17, 2015

    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 x but they are correctly missing in y.

  7. arunsrinivasan
    reopened this on Mar 17, 2015

  8. arunsrinivasan commented on Mar 17, 2015

    @arunsrinivasan
    arunsrinivasan
    on Mar 17, 2015
    MemberAuthor

    Thanks, will take a look asap.

  9. arunsrinivasan
    closed this as completedin 4db0c43on Mar 17, 2015

  10. arunsrinivasan commented on Mar 17, 2015

    @arunsrinivasan
    arunsrinivasan
    on Mar 17, 2015
    MemberAuthor

    Please write back if this is still not resolved.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

bug

Type

No type

Projects

No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions