Hi,
I am confronted with this error while trying to read csv file into R session.
Though it is warning message, I noticed that the whole file was not read
properly.
After having gone through the whole file, unable to identify error in file. I am
copying the last 2 rows in original csv file after which the reading was not
proper. (cannot enclose file because of big size)
TRANSCONTINENTAL GAS - ZONE 6 (NY) (BASIS) - ICE FUTURES ENERGY DIV
2/25/2014
81271
51032
37508
14592
31154
1710
0
1490
1296
943
0
341
69914
73499
11357
7772
WAHA HUB - WEST TEXAS DELIVERED/BUYER'S INDEX - ICE FUTURES ENERGY DIV
2/25/2014
14232
13331
11786
0
0
0
0
615
0
280
0
0
13611
12401
621
1831
Can someone go through the same and suggest what I am missing out.
> cftc = read.table("cftcdata_ncn.csv", sep = ',', header =
TRUE, fill = TRUE)
Warning message:
In scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings, :
EOF within quoted string
> sessionInfo()
R version 3.1.0 (2014-04-10)
Platform: x86_64-w64-mingw32/x64 (64-bit)
locale:
[1] LC_COLLATE=English_United States.1252 LC_CTYPE=English_United States.1252
[3] LC_MONETARY=English_United States.1252 LC_NUMERIC=C
[5] LC_TIME=English_United States.1252
attached base packages:
[1] stats graphics grDevices utils datasets methods
base>
Many thanks for the help.
Best regards,
Krishna
[[alternative HTML version deleted]]