[R] Proper way to write data frame with column and row names

Simon Blomberg s.blomberg1 at uq.edu.au
Fri Oct 31 02:58:10 CET 2008

Try setting row.names=FALSE in the call to write.table. If you really
need those row names, create a variable containing the row names in the
data frame. Then use write.table with row.names=FALSE. 



On Fri, 2008-10-31 at 01:35 +0000, Daren Tan wrote:
> I need to write a data frame along with its column and row names to a text file. However, the first row in the text file is always short of one element. I have tried setting different parameters to write.table but that didn't help.
> > m
>    A B
> C 1 2
> D 3 4
> Using write.table(m, "table.xls", sep="\t", col.names=T, row.names=T) gives
> A B
> C 1 2
> D 3 4
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
Simon Blomberg, BSc (Hons), PhD, MAppStat. 
Lecturer and Consultant Statistician 
Faculty of Biological and Chemical Sciences 
The University of Queensland 
St. Lucia Queensland 4072 
Room 320 Goddard Building (8)
T: +61 7 3365 2506
email: S.Blomberg1_at_uq.edu.au

1.  I will NOT analyse your data for you.
2.  Your deadline is your problem.

The combination of some data and an aching desire for 
an answer does not ensure that a reasonable answer can 
be extracted from a given body of data. - John Tukey.

More information about the R-help mailing list