Nice one!!!

Tanks.

--
Noah Silverman
UCLA Department of Statistics
8208 Math Sciences Building
Los Angeles, CA 90095

On Feb 12, 2012, at 4:26 PM, Henrique Dallazuanna wrote:

> This works for me:
> 
> Lines <- "label_1, label_2, label_3
> 1,2,3
> 3,2,4
> 2,3,4
> Total Rows: 3"
> 
> d <- head(read.csv(textConnection(Lines)), -1)
> closeAllConnections()
> 
> On Sun, Feb 12, 2012 at 10:05 PM, Noah Silverman <noahsilverman@ucla.edu> wrote:
> Hi,
> 
> I have a CSV file that is formatted well, except that the last line is a "summary" not is CSV format.
> 
> Toy example:
> 
> label_1, label_2, label_3
> 1,2,3
> 3,2,4
> 2,3,4
> Total Rows: 3
> 
> 
> When I try to import this into R with:  d <- read.table("foo.csv", header=T, sep=",")
> It fails to import properly because of the last line.
> 
> Currently, I have a shell script that strips the last line from the file, then it imports to R cleanly.  I don't like this extra layer of processing.
> 
> Is there a way to import something like this cleanly in R.
> 
> Thanks!
> 
> --
> Noah
> ______________________________________________
> 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.
> 
> 
> 
> -- 
> Henrique Dallazuanna
> Curitiba-Paraná-Brasil
> 25° 25' 40" S 49° 16' 22" O


	[[alternative HTML version deleted]]

