Re: [R] Importing an Excel file

From: Marc Schwartz <MSchwartz_at_medanalytics.com>
Date: Thu 08 Jul 2004 - 04:50:46 EST

On Wed, 2004-07-07 at 13:44, Marc Schwartz wrote:

> On Wed, 2004-07-07 at 13:21, Park, Kyong H Mr. RDECOM wrote:

> > Hello, R users,
> > I am a very beginner of R and tried read.csv to import an excel file after
> > saving an excel file as csv. But it added alternating rows of fictitious NA
> > values after row number 16. When I applied read.delim, there were trailing
> > several commas at the end of each row after row number 16 instead of NA
> > values. Appreciate your help.
> >
> > Kyong

One other thing:

The default delimiting characters in read.csv() and read.delim() are NOT the same.

The former uses a comma and the latter a TAB character. If you did not change the defaults in Excel when you created your CSV file, that would account for the difference behaviors upon import.

Be sure that the delimiting character in the R function you use properly corresponds to the actual delimiting character in your CSV file.

Marc



R-help@stat.math.ethz.ch mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Thu Jul 08 04:54:25 2004

This archive was generated by hypermail 2.1.8 : Wed 03 Nov 2004 - 22:54:45 EST