From: Andrew C. Ward (firstname.lastname@example.org)
Date: Wed 22 Jan 2003 - 16:21:42 EST
I usually save Excel files as CSV, and then use read.csv() to get them into R.
Also, there are variants of read.table() that seem more successful at reading
in delimited files (see read.delim, read.delim2).
Andrew C. Ward
Department of Chemical Engineering
The University of Queensland
Brisbane Qld 4072 Australia
Quoting Hamish McCallum <email@example.com>:
> Dear All,
> I've been using R for windows for a while, without too many problems.
> However, I'm forced to use the MAC OS system for teaching, because our
> teaching labs are mac only (not my idea!!). I have a very basic problem,
> but one that doesn't appear on the FAQs. I simply want to import data
> from a spreadsheet. I'm using exactly what works fine on Windows, namely:
> 1 save the file from Excel as tab-delimited, say called "test.txt",
> with the variable names in the first row.
> 2 Read in into R with
> test<-read.table("test.txt", header=T)
> It does weird things, especially if any variables are characters. For
> example, it has omitted the 5th observation for the 1st variable, and
> then appended it to the first variable name. I've tried read.csv with
> csv files, read.delim, etc. None seem to work. Am I being really silly,
> and if so, how do you do it? Or is there an easier way to get data into
> the mac port? Or is the mac port entirely useless?
> Can anyone out there help?
> Hamish McCallum
> Dr Hamish McCallum
> Department of Zoology and Entomology
> The University of Queensland
> Brisbane 4072
> Phone (+617) 3365 2450 Fax (+617) 3365 1655
> Rfirstname.lastname@example.org mailing list
Remail@example.com mailing list
This archive was generated by hypermail 2.1.3 : Tue 01 Jul 2003 - 09:11:19 EST