?merge

> merge(A,B)
  C1  C2
1  A 200


On Thu, May 7, 2009 at 2:19 AM, Raghavan, Nandini [PRDUS] <
NRaghava@its.jnj.com> wrote:

> Hello,
>
>
>
> I am trying to extract a subset of a dataframe A (2 columns) by
> extracting all entries in A (several repeated entries) that match
> dataframe B in both columns.  For example, part of A and B are shown
> below.
>
> The following does not seem to work correctly. This only seems to select
> on the first component and all instances of the second.
>
> ind <- A$C1 %in% B[,1] & A$C2 %in% B[,2]
>
> Any suggestions as to how to do this in general (even for matches in
> multiple columns) would be appreciated.
>
>
>
> Regards,
>
> Nandini
>
>
>
>
>
> A:
>
>   C1   C2
>
> 1   F 1500
>
> 2   P  120
>
> 4   F  250
>
> 5   I  200
>
> 6   D 2010
>
> 7   F 1000
>
> 8   V    0
>
> 9   F 2100
>
> 10  F  500
>
> 11  E 1800
>
> 12  A  500
>
> 13  V    0
>
> 14  I  125
>
> 15  I   30
>
> 16  M  300
>
> 17  D   75
>
> 18  V  500
>
> 19  A  200
>
> 20  M 1000
>
> 21  P  225
>
>
>
> B:
>
>  C1   C2
>
> 1   A  200
>
> 2   A  600
>
> 3   A 1500
>
> 4   B  100
>
> 5   B 1000
>
> 6   C 5000
>
> 7   C  225
>
> 8   C  150
>
> 9   C  150
>
> 10  C  200
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>        [[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<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?

	[[alternative HTML version deleted]]


