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

Marc Schwartz marc_schwartz at me.com
Sun Aug 16 16:59:50 CEST 2015


> On Aug 16, 2015, at 9:38 AM, 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?
> 
> Any suggestions will be really appreciated. Thanks in advance.
> 
> Best,
> Jinsong


> write.csv(x)
"","A","B","C"
"a",1,3,5
"b”,2,4,6


> write.table(x, sep = ",", qmethod = "double", col.names = NA)
"","A","B","C"
"a",1,3,5
"b”,2,4,6


Read the section on CSV files in ?write.table

Regards,

Marc Schwartz



More information about the R-help mailing list