Skip to content

CSV header with column name "NA" is incorrectly parsed by fread #5124

@Mashin6

Description

@Mashin6

When .csv file header contains column name that is "NA" fread replaces it with V.. name.

e.g. .csv file like this

col1,colX,NA,NC,AN,nA
23,asd,df,sdf,asdf,sadf
23,asd,df,sdf,asdf,sadf
23,asd,df,sdf,asdf,sadf
23,asd,df,sdf,asdf,sadf
>tt <- fread("NA_test.csv")

>t
  col1 colX V3  NC   AN   nA
1:   23  asd df sdf asdf sadf
2:   23  asd df sdf asdf sadf
3:   23  asd df sdf asdf sadf
4:   23  asd df sdf asdf sadf

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions