[R] difference between write.csv(...) and write.table(..., sep=", ")

[Berend Hasselman]

> On 16-08-2015, at 16:38, Jinsong Zhao <jszhao at yeah.net> wrote:
> 
> Hi there,
> 
> I notice that write.csv is a wrap of write.table. However, I can't get the same results using both functions. Here is a reproducible example:
> 
> > x <- matrix(1:6, nrow =2)
> > rownames(x) <- letters[1:2]
> > colnames(x) <- LETTERS[1:3]
> > write.csv(x, "")
> "","A","B","C"
> "a",1,3,5
> "b",2,4,6
> > write.table(x, "", sep = ",")
> "A","B","C"
> "a",1,3,5
> "b",2,4,6
> 
> The difference of outputs from both functions is clear.
> 
> Is it possible to get the same results of write.csv using write.table?
> 

Yes. Read  the item col.names in the help for write.table and go to the section “CSV files”..

Use  write.table(x, "", sep = ",", col.names=NA)

Learn to use R’s help.

Berend

> Any suggestions will be really appreciated. Thanks in advance.
> 
> Best,
> Jinsong
> 
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> 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.