[R] Read.table for macs

ripley@stats.ox.ac.uk ripley at stats.ox.ac.uk
Wed Jan 22 08:49:03 CET 2003


This is a known problem in R 1.6.2, the Darwin port reading MacOS 
CR-delimited files.
Just use the patched version, R-patched, or R 1.6.1.

On Wed, 22 Jan 2003, Henrik Bengtsson wrote:

> 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? 
> 
> Henrik Bengtsson
> 
> > -----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 
> > "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?
> > 
> > Thanks
> > 
> > Hamish McCallum
> > 
> > -- 
> > Dr Hamish McCallum
> > Department of Zoology and Entomology
> > The University of Queensland
> > Brisbane 4072
> > Australia
> > 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
> > 
> >
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> http://www.stat.math.ethz.ch/mailman/listinfo/r-help
> 

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595




More information about the R-help mailing list