[R] Reading in csv with footer

Noah Silverman noahsilverman at ucla.edu
Mon Feb 13 01:05:09 CET 2012


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


More information about the R-help mailing list