[R] Export data

[David Barron]

Difficult to say exactly why it didn't work without knowing exactly
what you did.  The following works for me:

> res<-data.frame(A=1.5,B=4.5,C=7)
 > write.table(res,file="file.csv",sep="
",row.names=TRUE,col.names=TRUE,eol = "\n")
 > res2<-data.frame(3,6,9)
 > write.table(res2,file="file.csv",append=TRUE,sep="
",row.names=TRUE,col.names=FALSE,eol="\n")

By the way, the extension .csv is usually used for comma delimited format.

On 11/09/06, Marie-Noëlle Rolland <mrolland at grignon.inra.fr> wrote:
> Hi there,
>
> I would like to write a data output. In first time, a data frame (called
> "res") is written in a file *csv such as:
>
> A    B    C    # names of data
> 1.5  4.5  7    # values
>
> So I use "write.table" which prints "res" to a file "file.csv"
> write.table(res,file="file.csv",sep="",row.names=TRUE,col.names=TRUE,eol
> = "\n")
>
> After, I would like to append other data to the same file,
>
> A    B    C
> 1.5  4.5  7
> 3    6    9   # appended data
>
> I use then the same function but with different arguments:
> write.table(res,file="file.csv",append=TRUE,sep="",row.names=TRUE,col.names=FALSE,eol
> = "\n")
>
> Actually, it doesn't work, the file is overwritten by the new one.
>
> I got something like that:
> A    B    C
> 3    6    9
>
> Coul you help me? Thank you in advance
>
> Kind regards,
> Marie-Noëlle
>
> ______________________________________________
> R-help at stat.math.ethz.ch 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.
>


-- 
=================================
David Barron
Said Business School
University of Oxford
Park End Street
Oxford OX1 1HP