Full_Name: Wolfgang Huber Version: 1.6.2 OS: DEC OSF, Win, Linux Submission from: (NULL) (155.52.45.139) 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:> xobscht 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
Please, do read the documentation! Try write.table(..., col.names=NA) Andy> -----Original Message----- > From: w.huber@dkfz.de [mailto:w.huber@dkfz.de] > Sent: Thursday, March 06, 2003 12:42 PM > To: r-devel@stat.math.ethz.ch > Cc: R-bugs@biostat.ku.dk > Subject: [Rd] write.table row.names and col.names (PR#2611) > > > Full_Name: Wolfgang Huber > Version: 1.6.2 > OS: DEC OSF, Win, Linux > Submission from: (NULL) (155.52.45.139) > > > 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 > > ______________________________________________ > R-devel@stat.math.ethz.ch mailing list > stat.math.ethz.ch/mailman/listinfo/r-devel >------------------------------------------------------------------------------