[R] Importing Large Dataset into Excel

From: Wayne Aldo Gavioli <wgavioli_at_fas.harvard.edu>
Date: Tue, 11 Dec 2007 22:15:29 -0500

Hello all,

I seem to be having a problem importing a data set from Excel into R. I'm using the "read.table" command to import the data with the following line of code:

> newborn<-read.table("newborn edit.csv", header=T, sep=",")

where "newborn edit.csv" is the name of the file. Unfortunately, I'm getting back the following error message:

"Error in scan(file,, what, nmax, sep, dc, quote, skip, nlines, na.string, : line 528 did not have 44 elements"

As far as I can tell, line 528 of the spreadsheet table does have the same number of elements as the other rows - by chance can this error message mean anything else? Also, is there an easier way to import data from R into Excel using a single line of R code?

Thanks,

Wayne



R-help_at_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. Received on Wed 12 Dec 2007 - 03:19:26 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 12 Dec 2007 - 19:30:45 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.