>From ?write.table: Normally there is no column name for a column of row names. If `col.names=NA' a blank column name is added. This can be used to write CSV files for input to spreadsheets.
-Greg > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 06, 2003 12:42 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: [Rd] write.table row.names and col.names (PR#2610) > > > 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 > > ______________________________________________ > [EMAIL PROTECTED] mailing list > https://www.stat.math.ethz.ch/mailman/listinfo/r-devel > LEGAL NOTICE\ Unless expressly stated otherwise, this message is... [[dropped]] ______________________________________________ [EMAIL PROTECTED] mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-devel