On 19.04.2011 20:47, Petr Pikal wrote:
Dear all
I have several files which claim to be *.csv (one attached, maybe it
will come through).
Can you provide the file on some webspace or send it to me privately, I
will take a look tomorrow then.
Uwe Ligges
They can be read to Open Office without much
problem, however I can not read them into R. I tried
read.table("H2O.CSV", sep=",", dec=".")
V1
1 ˙ţ1
2
3
....
read.table("H2O.CSV", sep=",", dec=".", skip=1)
Error in read.table("H2O.CSV", sep = ",", dec = ".", skip = 1) :
empty beginning of file
readLines("H2O.CSV", 1)
[1] "˙ţ1"
readLines("H2O.CSV", 5)
[1] "˙ţ1" "" "" "" ""
readChar("H2O.CSV", 10)
[1] "˙ţ1"
readBin("H2O.CSV", 10)
[1] 9.456937e-308
This is how first two lines appear in Notepad
1,1.77436423301697,"BV
",91.0779418945313,7.35872077941895,0.178956836462021,1.70007145404816,1.90102112293243
2,1.94783389568329,"VV
",1341.51489257812,9.04244899749756,1.76539707183838,1.90102112293243,3.52783703804016
....
The problem seems to be in first item "˙ţ1" which somehow blocks
further values to be read.
Does anybody have idea what to do or where to look for some help? I do
not want to transfer files through spreadsheet manually.
Best regards
Petr
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
