[R] write to file append by column

[jim holtman]

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?