[R] read.csv issue

Carlos J. Gil Bellosta cgb at datanalytics.com
Wed Aug 16 21:02:37 CEST 2006


Dear Harold,

One thing you can do is to read the file "plainly", even if the "\" is
lost and then, inside R, change the string value with gsub.

Sincerely,

Carlos J. Gil Bellosta

http://www.datanalytics.com
http://www.data-mining-blog.com


El mié, 16-08-2006 a las 14:43 -0400, Doran, Harold escribió:
> I'm trying to read in some data from a .csv format and have come across
> the following issue. Here is a simple example for replication
> 
> # A sample .csv format
> schid,sch_name
> 331-802-7081,School One
> 464-551-7357,School Two
> 388-517-7627,School Three \& Four
> 388-517-4394,School Five
> 
> Note the third line includes the \ character. However, when I read the
> data in I get
> 
> > read.csv(file.choose())
>          schid              sch_name
> 1 331-802-7081            School One
> 2 464-551-7357            School Two
> 3 388-517-7627 School Three & Four
> 4 388-517-4394           School Five
> 
> It turns out to be very important to read in this character as I have a
> program that loops through a data set and Sweave's about 30,000 files.
> The variable sch_name gets dropped into the tex file using
> \Sexpr{tmp$sch_name}. However, if there is an &, the latex file won't
> compile properly. So, what I need is for the data to be read in as
> 
>          schid              sch_name
> 1 331-802-7081            School One
> 2 464-551-7357            School Two
> 3 388-517-7627 School Three \& Four
> 4 388-517-4394           School Five
> 
> I am obligated by a client to include the & in the school name, so
> eliminating that isn't an option. I thought maybe comment.char or quote
> would be what I needed, but they didn't resolve the issue. I'm certain
> I'm missing something simple, I just can't see it.
> 
> Any thoughts?
> 
> Harold
> 
> 
> 
> 	[[alternative HTML version deleted]]
> 
> ______________________________________________
> R-help at 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
> and provide commented, minimal, self-contained, reproducible code.



More information about the R-help mailing list