[R] Newbie query - reading data into R

Prof Brian Ripley ripley at stats.ox.ac.uk
Tue Jan 26 16:20:40 CET 1999


> From: Peter Dalgaard BSA <p.dalgaard at biostat.ku.dk>
> Date: 26 Jan 1999 15:43:08 +0100
> 
> Prof Brian Ripley <ripley at stats.ox.ac.uk> writes:
> 
> > Try sep="\t", if they are really separated by tabs (they were not in
> > your email by the time it reached here).  Actually, you don't need
> > as.if=F, either, as the first column should be the row names:
> > 
> > > read.table("test.dat", header=T, row.names=1, sep="\t")
> >              Number
> > Napier          324
> > Auckland        657
> > Wellington      879
> > Christchurch    904
> > 
> > works on your example (with tabs in the file).
> > 
> > (S-PLUS behaves differently here, and guesses the first column
> > should be the row names without being told).  
> 
> So does read.table on Unix - I don't remember it doing anything else?
(On R? Your own example shows it does not!)

> And with the original data (TAB separated and with a header for col.1
> too), I got
> 
> > read.table("~/tmp/testdata", header=T)
>           City Number
> 1       Napier    324
> 2     Auckland    657
> 3   Wellington    879
> 4 Christchurch    904
> > class(read.table("~/tmp/testdata", header=T))
> [1] "data.frame"
> 
> I.e. no problem. ???

On Splus 3.4:
> read.table("test.dat", header=T)
             Number 
      Napier    324
    Auckland    657
  Wellington    879
Christchurch    904

which is not the same as R 0.63.2:

> read.table("test.dat", header=T)
          City Number
1       Napier    324
2     Auckland    657
3   Wellington    879
4 Christchurch    904

is it?  That was my point: read.table in R and S-PLUS are subtly different.

-- 
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 272860 (secr)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._



More information about the R-help mailing list