How??
I dont think there is any parameter that does this job.
I came up with ddply function in plyr package but having tens of dataframe
and doing it in a for loop may not be a good idea.
ddply(test, ~ Src , colwise(paste, .(Target1)), collapse ="," );
Can you please write how it can be done by write.csv.
Or is there any efficient method that can do this for me.
dataframe1 = data.frame(cbind(Src = c(1,1,1,2,3), Target1 =
c('aaa','bbb','ccc','aaa','ddd')));
dataframe2 = data.frame(cbind(Src = c(2,3,4,4,4), Target2 =
c('aaaa','dddd','bbbb','eeee','ffff')));
dataframe3 = data.frame(cbind(Src = c(1,3,5,6,6), Target3 =
c('xx','yy','zz','tt','uu')));
test = merge(dataframe3, merge(dataframe1,dataframe2, by = 'Src', all=TRUE,
incomparables=''), by = 'Src', all=TRUE, incomparables='')
ddply(test, ~ Src , colwise(paste, .(Target1)), collapse ="," );
Thanks
On Mon, Jun 13, 2011 at 7:14 PM, Dr. D. P. Kreil (Boku) <
[email protected]> wrote:
> ?write.csv
>
> Cheers,
> David.
>
>
> On 14 June 2011 01:07, Mary Kindall <[email protected]> wrote:
> > Thanks for reply.
> > The following code is working but only patially. How to get the condensed
> > values separated by comma.
> >
> > dataframe1 = data.frame(cbind(Src = c(1,1,1,2,3), Target1 =
> > c('aaa','bbb','ccc','aaa','ddd')));
> > dataframe2 = data.frame(cbind(Src = c(2,3,4,4,4), Target2 =
> > c('aaaa','dddd','bbbb','eeee','ffff')));
> > dataframe3 = data.frame(cbind(Src = c(1,3,5,6,6), Target3 =
> > c('xx','yy','zz','tt','uu')));
> > merge(dataframe3, merge(dataframe1,dataframe2, by = 'Src', all=TRUE), by
> =
> > 'Src', all=TRUE)
> >
> >
> > 1> merge(dataframe3, merge(dataframe1,dataframe2, by = 'Src', all=TRUE),
> by
> > = 'Src', all=TRUE)
> > Src Target3 Target1 Target2
> > 1 1 xx aaa <NA>
> > 2 1 xx bbb <NA>
> > 3 1 xx ccc <NA>
> > 4 3 yy ddd dddd
> > 5 5 zz <NA> <NA>
> > 6 6 tt <NA> <NA>
> > 7 6 uu <NA> <NA>
> > 8 2 <NA> aaa aaaa
> > 9 4 <NA> <NA> bbbb
> > 10 4 <NA> <NA> eeee
> > 11 4 <NA> <NA> ffff
> >
> > Thanks
> >
> > --
> > M
> >
> >
> > On Mon, Jun 13, 2011 at 6:35 PM, Dr. D. P. Kreil (Boku)
> > <[email protected]> wrote:
> >>
> >> Hi, try
> >>
> >> ?merge
> >>
> >> Best,
> >> David.
> >>
> >>
> >> On 13 June 2011 23:48, Mary Kindall <[email protected]> wrote:
> >> > Hi R users,
> >> > I am new to R and am trying to merge data frames in the following way.
> >> > Suppose I have n data frames each with two fields. Field 1 is common
> >> > among
> >> > data frames but may have different entries. Field 2 is different.
> >> >
> >> >
> >> > Data frame 1:
> >> >
> >> > Src Target1
> >> > 1 aaa
> >> > 1 bbb
> >> > 1 ccc
> >> > 2 aaa
> >> > 3 ddd
> >> >
> >> >
> >> > Data frame 2:
> >> >
> >> > Src Target2
> >> > 2 aaaa
> >> > 3 dddd
> >> > 4 bbbb
> >> > 4 eeee
> >> > 4 ffff
> >> >
> >> >
> >> > Data frame 3:
> >> >
> >> > Src Target3
> >> > 1 xx
> >> > 3 yy
> >> > 5 zz
> >> > 6 tt
> >> > 6 uu
> >> >
> >> > And so on...
> >> >
> >> > I want to convert this into a data frame something similar to:
> >> > Src Target1 target2
> >> > target3
> >> > 1 aaa,bbb,ccc -
> >> > xx
> >> >
> >> > 2 aaa aaaa
> >> > -
> >> > 3 ddd dddd
> >> > yy
> >> > 4 - bbbb,eeee,ffff
> >> > -
> >> >
> >> > 5 -
> >> > - zz
> >> > 6 -
> >> > - tt,uu
> >> >
> >> >
> >> > Basically I am trying to make a consolidated table.
> >> >
> >> > Help appreciated.
> >> > Thanks
> >> > M
> >> >
> >> >
> >> > -------------
> >> > Mary Kindall
> >> > Yorktown Heights
> >> > USA
> >> >
> >> > [[alternative HTML version deleted]]
> >> >
> >> > ______________________________________________
> >> > [email protected] 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.
> >> >
> >
> >
> >
> > --
> > -------------
> > Mary Kindall
> > Yorktown Heights, NY
> > USA
> >
> >
>
--
-------------
Mary Kindall
Yorktown Heights, NY
USA
[[alternative HTML version deleted]]
______________________________________________
[email protected] 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.
