Skip to content

fread incorrectly skips header on this file #1625

Description

@mattdowle

fread("http://www.nzta.govt.nz/resources/crash-analysis-system-data/docs/crash-data-2014.csv") :
Starting data input on line 2 and discarding line 1 because it has too few or too many items to be column names or data: "TLA NAME","CRASH ROAD","CRASH DIST","CRASH DIRN","INTSN","SIDE ROAD","CRASH ID","CRASH DATE","CRASH DOW","CRASH TIME","MVMT","VEHICLES","CAUSES","OBJECTS STRUCK","ROAD CURVE","ROAD WET","LIGHT","WTHRa","JUNC TYPE","TRAF CTRL","ROAD MARK","SPD LIM","CRASH FATAL CNT","CRASH SEV CNT","CRASH MIN CNT","PERS AGE1","PERS AGE2","EASTING","NORTHING"

From : http://stackoverflow.com/questions/28100868/download-file-inserts-an-extra-cr-after-each-crlf

Activity

  1. added this to the v1.9.8 milestone on Apr 5, 2016
  2. arunsrinivasan commented on Apr 6, 2016

    @arunsrinivasan
    Member

    Try it again with fill = TRUE.

    Perhaps that should be added to the warning message. Or we should load length(header) number of columns by default, and provide the warning that informs about fill=TRUE.

    Are you going to work on this? If not, I'd prefer it to be moved to v2.0.0.

  3. modified the milestones: , v1.9.8 on Jul 21, 2016
  4. modified the milestones: , on Jan 21, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions