Re: [R] Selecting rows that are the same in separate data frames

2008-12-09 Thread Henrique Dallazuanna
Try this: 1) Rows: merge(as.data.frame(a), as.data.frame(b), sort = FALSE) 2) Index: merge(cbind(as.data.frame(a), Idx = 1:nrow(a)), as.data.frame(b), sort = FALSE)$Idx On Tue, Dec 9, 2008 at 12:57 PM, ppaarrkk <[EMAIL PROTECTED]> wrote: > > I want to compare two matrices or data frames and s

Re: [R] Selecting rows that are the same in separate data frames

2008-12-09 Thread ppaarrkk
Thanks for reply. What I want is the equivalent of this : xxx = 1:10 which(xxx %in% c(2,5)) ...but where there is more than one criterion for matching. which (b %in% a) in the code I included does nothing (not surprisingly). I'm not sure that I can use merge, because I want the whole of

Re: [R] Selecting rows that are the same in separate data frames

2008-12-09 Thread Jorge Ivan Velez
Dear Simon, Try this: # Index -- FALSE, TRUE sapply(1:nrow(a),function(x) all(a[x,]%in%b)) # Rows of a that are in b which(sapply(1:nrow(a),function(x) all(a[x,]%in%b))) # Reporting a[sapply(1:nrow(a),function(x) all(a[x,]%in%b)),] HTH, Jorge On Tue, Dec 9, 2008 at 9:57 AM, ppaarrkk <[EMA

Re: [R] Selecting rows that are the same in separate data frames

2008-12-09 Thread bartjoosen
I'm not sure what you want, but take a look at ?merge and %in% ppaarrkk wrote: > > I want to compare two matrices or data frames and select or get an index > for those rows which are the same in both. I have tried the following : > > > > > > > a = matrix ( 1:10, ncol = 2 ) > a > > b = ma

[R] Selecting rows that are the same in separate data frames

2008-12-09 Thread ppaarrkk
I want to compare two matrices or data frames and select or get an index for those rows which are the same in both. I have tried the following : a = matrix ( 1:10, ncol = 2 ) a b = matrix ( c ( 2,3,4,7,8,9 ), ncol = 2 ) b a[a==b] a = as.data.frame ( matrix ( 1:10, ncol = 2 ) ) a b =