Readers, Scenario: data x consists of one column; 1 2 3 data y; 4 5 6 Is it possible to write to file such that the file is: 1,4 2,5 3,6 using the write.file function? I have tried the command: write(x,file="file.csv",ncolumns=1,append=TRUE,sep=",") write(y,file="file.csv",ncolumns=1,append=TRUE,sep=",") but the result is: 1 2 3 4 5 6 yours, rhelpatconference.jabber.org r 251 mandriva 2008
write to file append by column
4 messages · e-letter, jim holtman
You can not append a column. Best bet, read the old file in, do a 'cbind', write the object back out.
On Tue, Nov 24, 2009 at 5:59 AM, e-letter <inpost at gmail.com> wrote:
Readers, Scenario: data x consists of one column; 1 2 3 data y; 4 5 6 Is it possible to write to file such that the file is: 1,4 2,5 3,6 using the write.file function? I have tried the command: write(x,file="file.csv",ncolumns=1,append=TRUE,sep=",") write(y,file="file.csv",ncolumns=1,append=TRUE,sep=",") but the result is: 1 2 3 4 5 6 yours, rhelpatconference.jabber.org r 251 mandriva 2008
______________________________________________ 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.
Jim Holtman Cincinnati, OH +1 513 646 9390 What is the problem that you are trying to solve?
On 24/11/2009, jim holtman <jholtman at gmail.com> wrote:
You can not append a column. Best bet, read the old file in, do a 'cbind', write the object back out. On Tue, Nov 24, 2009 at 5:59 AM, e-letter <inpost at gmail.com> wrote:
Readers, Scenario: data x consists of one column; 1 2 3 data y; 4 5 6 Is it possible to write to file such that the file is: 1,4 2,5 3,6 using the write.file function? I have tried the command: write(x,file="file.csv",ncolumns=1,append=TRUE,sep=",") write(y,file="file.csv",ncolumns=1,append=TRUE,sep=",") but the result is: 1 2 3 4 5 6 yours, rhelpatconference.jabber.org r 251 mandriva 2008
______________________________________________ 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.
-- Jim Holtman Cincinnati, OH +1 513 646 9390 What is the problem that you are trying to solve?
This is the requested format: 1,4 2,5 3,6 The write functions described previously produce the following format: 1 2 3 4 5 6
Here is the way to get the required output:
x <- data.frame(a=1:3)
write.csv(x, file='tempxx.csv', row.names=FALSE)
# new data
newData <- data.frame(b=4:6)
# read old data back in
oldData <- read.csv('tempxx.csv')
# cbind the new data
write.csv(cbind(oldData, newData), file='tempxx.csv', row.names=FALSE)
file.show('tempxx.csv')
"a","b" 1,4 2,5 3,6
On Tue, Nov 24, 2009 at 8:22 AM, e-letter <inpost at gmail.com> wrote:
On 24/11/2009, jim holtman <jholtman at gmail.com> wrote:
You can not append a column. ?Best bet, read the old file in, do a 'cbind', write the object back out. On Tue, Nov 24, 2009 at 5:59 AM, e-letter <inpost at gmail.com> wrote:
Readers, Scenario: data x consists of one column; 1 2 3 data y; 4 5 6 Is it possible to write to file such that the file is: 1,4 2,5 3,6 using the write.file function? I have tried the command: write(x,file="file.csv",ncolumns=1,append=TRUE,sep=",") write(y,file="file.csv",ncolumns=1,append=TRUE,sep=",") but the result is: 1 2 3 4 5 6 yours, rhelpatconference.jabber.org r 251 mandriva 2008
______________________________________________ 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.
-- Jim Holtman Cincinnati, OH +1 513 646 9390 What is the problem that you are trying to solve?
This is the requested format: 1,4 2,5 3,6 The write functions described previously produce the following format: 1 2 3 4 5 6
Jim Holtman Cincinnati, OH +1 513 646 9390 What is the problem that you are trying to solve?