strip.white trailing [REQUEST]

[masip85]

If I have got a header name like "X Y", by default,the result of fread has a header called "X Y". Spaces are not changed by points like read.csv does by default. So after fread I've got to do ...
setnames(DT, make.names(colnames(DT)))
... to fix it. Could it be an option? Does it exist?

data.table package 1.9.6

[MichaelChirico]

could you please provide the first several lines of the file?

[masip85]

The file is this one:
https://data.cityofchicago.org/api/views/r5kz-chrr/rows.csv?accessType=DOWNLOAD

[masip85]

I'm sorry, is read.csv which does that by default, but no fread. Let me edit it, and I will change it to request.

[MichaelChirico]

Please install the development version, which has improved the check.names argument. I get this from your file:

names(fread("~/Downloads/Business_Licenses.csv", check.names = TRUE))
#  [1] "ID"                                "LICENSE.ID"                       
#  [3] "ACCOUNT.NUMBER"                    "SITE.NUMBER"                      
#  [5] "LEGAL.NAME"                        "DOING.BUSINESS.AS.NAME"           
#  [7] "ADDRESS"                           "CITY"                             
#  [9] "STATE"                             "ZIP.CODE"                         
# [11] "WARD"                              "PRECINCT"                         
# [13] "WARD.PRECINCT"                     "POLICE.DISTRICT"                  
# [15] "LICENSE.CODE"                      "LICENSE.DESCRIPTION"              
# [17] "LICENSE.NUMBER"                    "APPLICATION.TYPE"                 
# [19] "APPLICATION.CREATED.DATE"          "APPLICATION.REQUIREMENTS.COMPLETE"
# [21] "PAYMENT.DATE"                      "CONDITIONAL.APPROVAL"             
# [23] "LICENSE.TERM.START.DATE"           "LICENSE.TERM.EXPIRATION.DATE"     
# [25] "LICENSE.APPROVED.FOR.ISSUANCE"     "DATE.ISSUED"                      
# [27] "LICENSE.STATUS"                    "LICENSE.STATUS.CHANGE.DATE"       
# [29] "SSA"                               "LATITUDE"                         
# [31] "LONGITUDE"                         "LOCATION"  

Development version can be installed with

install.packages("data.table", type = "source", repos = "http://Rdatatable.github.io/data.table")

[MichaelChirico]

@arunsrinivasan duplicate of #1027

[arunsrinivasan]

check.names argument has been added to fread since v1.9.6. Set it to TRUE.

[MichaelChirico]

@arunsrinivasan the check.names in 1.9.6 doesn't incorporate David Arenburg's improvement (filling #1027) which fixes this issue... anyway, it is indeed fixed on development.

[arunsrinivasan]

Michael, that's right, thanks.

[masip85]

Right. Thanks,