[Rd] write.table row.names and col.names (PR#2610)
Dirk Eddelbuettel
edd at debian.org
Thu Mar 6 11:46:31 MET 2003
On Thu, Mar 06, 2003 at 06:41:38PM +0100, w.huber at dkfz.de wrote:
> When data.frames are written to a file using write.table and with row.names and
> col.names, then the colnames are displaced by 1 with respect to column content.
> Example:
>
>
> > x = data.frame(
> > obscht=c("chriesi", "bire"),
> > gmues=c("chrut","hoerdoepfl"))
> > rownames(x) = c("huet", "morn")
> > write.table(x, file="test.txt", sep="\t", quote=F)
>
> The table x now looks like:
> > x
> obscht gmues
> huet chriesi chrut
> morn bire hoerdoepfl
>
> but the file is as follows, and the column names will be confused when reading
> this file e.g. from Excel.
>
> obscht gmues
> huet chriesi chrut
> morn bire hoerdoepfl
AFAIK that is a feature. Look at the example(write.table), it does precisely
this and gets data back and forth to Excel.
Dirk
--
Prediction is very difficult, especially about the future.
-- Niels Bohr
More information about the R-devel
mailing list