Re: [R] Reading # in file with read.csv

From: Sundar Dorai-Raj <sundar.dorai-raj_at_pdf.com>
Date: Wed 12 Oct 2005 - 04:31:10 EST

Michel Friesenhahn wrote:
> I'm using read.csv to read in a csv file containing '#' characters. For
> example, say I'm reading the following file (test.csv):
>
> var1,var2,var3
> a,b,c
> d,e#,f
> g,h,i
>
> It outputs:
>
>

>>read.csv("Raw Data\\test.csv")

>
> var1 var2 var3
> 1 a b c
> 2 d e
> 3 g h i
> Warning message:
> incomplete final line found by readTableHeader on 'Raw Data\test.csv'
>
> read.csv appears to be treating '#' as a comment even in input data. Is there a
> way to turn this interpretation off?
>

 From ?read.csv:

comment.char: character: a character vector of length one containing a

           single character or an empty string.  Use '""' to turn off
           the interpretation of comments altogether.

Thus, you should use:

read.csv("Raw Data\\test.csv", comment.char = "")

--sundar



R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Wed Oct 12 04:34:47 2005

This archive was generated by hypermail 2.1.8 : Sun 23 Oct 2005 - 18:41:05 EST