[R] Importing Large Dataset into Excel
jholtman at gmail.com
Wed Dec 12 04:24:35 CET 2007
count.fields will tell you how many items are in each line. As you
said, they should all be the same, but this will confirm it.
field.count <- count.fields("newborn edit.csv", sep=",")
table(field.count) # determine count of the fields on a line
On Dec 11, 2007 7:15 PM, Wayne Aldo Gavioli <wgavioli at fas.harvard.edu> wrote:
> 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?
> R-help at r-project.org mailing list
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
+1 513 646 9390
What is the problem you are trying to solve?
More information about the R-help