Does this do what you want:
> data1
A B
1 1 a
2 1 b
3 2 c
4 2 d> data2
D E F
1 x y 1
2 w z 2> data1.1 <- aggregate(data1$B, list(data1$A), FUN=paste,
collapse=',')
> data1.1
Group.1 x
1 1 a,b
2 2 c,d> merge(data2, data1.1, by.x="F", by.y="Group.1")
F D E x
1 1 x y a,b
2 2 w z c,d>
On Wed, Oct 5, 2011 at 5:27 PM, darkgaze <donaldngwe at gmail.com>
wrote:> Hi all,
>
> Suppose I have
>
> data1
> A B
> 1 a
> 1 b
> 2 c
> 2 d
>
> and
>
> data2
> D E F
> x y 1
> w z 2
>
> and I want
>
> data2
> D E F G
> x y 1 a,b
> w z 3 c,d
>
> I am trying
>
> data2$G=list(data1$B[data1$A==data2$F,])
>
> How do I correct this approach?
>
> --
> View this message in context:
http://r.789695.n4.nabble.com/Subsetting-question-tp3876252p3876252.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> 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
Data Munger Guru
What is the problem that you are trying to solve?