[R] Read.table for macs
hb at maths.lth.se
Wed Jan 22 07:29:03 CET 2003
It should be the same, but then I know nothing about R or Excel for Mac.
Obvious things to check is if it is Excel or R that is the problem, i.e.
have you tested to save your Excel data on a Mac and then tried to
import it into R on a Windows machine and vice versa?
When Europe wakes up they might be able to help you out if you tell them
what version you are running. What does R.Version() say?
> -----Original Message-----
> From: r-help-admin at stat.math.ethz.ch
> [mailto:r-help-admin at stat.math.ethz.ch] On Behalf Of Hamish McCallum
> Sent: den 22 januari 2003 16:10
> To: R-help at lists.R-project.org
> Subject: [R] Read.table for macs
> 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
> 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
> R-help at stat.math.ethz.ch mailing list
> http://www.stat.math.ethz.ch/mailman/listinfo/> r-help
More information about the R-help