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 <noahsilver...@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]]
______________________________________________ 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.