[R] Importing Large Dataset into Excel
michael watson (IAH-C)
michael.watson at bbsrc.ac.uk
Thu Dec 13 08:48:12 CET 2007
It will be either:
1) line 528 contains a quote character somewhere: ' or "
2) line 528 contains a comma in one of the fields, not as a field separator
3) line 528 contains a comment character #
From: r-help-bounces at r-project.org on behalf of Julian Burgos
Sent: Wed 12/12/2007 6:09 PM
To: Wayne Aldo Gavioli
Cc: r-help at r-project.org
Subject: Re: [R] Importing Large Dataset into Excel
I'm assuming that you file is really a comma-separated file (*.csv) and
not an Excel workbook (*.xls) saved with a .csv extension, right? That
(in my experience) is a common mistake.
You should open your file with a simple text editor (notepad will do if
the file is not too large) and review line 528, instead of reviewing the
spreadsheet in Excel. You should be able to spot the problem right away.
Wayne Aldo Gavioli 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.
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.
More information about the R-help