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]]

______________________________________________
R-help@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.

Reply via email to