Re: [R] problem reading csv file

From: David Winsemius <dwinsemius_at_comcast.net>
Date: Tue, 19 Apr 2011 16:00:56 -0400

Not attached. You might succeed if you rename the file with a .txt extension and re-post.

Almost surely an encoding issue. We may need your session Info to get "locale".

-- 
David
On Apr 19, 2011, at 2:47 PM, Petr Pikal wrote:


> Dear all
>
> I have several files which claim to be *.csv (one attached, maybe it
> will come through) . 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_at_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.
David Winsemius, MD West Hartford, CT ______________________________________________ R-help_at_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.
Received on Tue 19 Apr 2011 - 20:04:25 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 20 Apr 2011 - 13:10:31 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive