[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