Compare two data.frames to find the rows in data.frame 1 and data.frame 2 which have equal values in selected columns

Question

I have 2 data frames (a1 and a2)

a1
A   B   C   D
1   A   6   8
2   D   7   3 #**
3   X   3   3

a2
A   B   C   D
4   D   2   3 #**
5   Z   3   5
6   X   3   4


a1 <- data.frame(
  A = 1:3,
  B = c("A", "D", "X"),
  C = c(6, 7, 3),
  D = c(8, 3, 3)
)
a2 <- data.frame(
  A = 4:6,
  B = c("D", "Z", "X"),
  C = c(2, 3, 3),
  D = c(3, 5, 4)
)

I want to get the tuples (a1$A,a2$A) for the rows which have the same values in colums B and D

In this example, I would get (2,4) because they have the same values in colums B and D, respectively D and 3

Do a1 and a2 have the same number of rows?

Richie Cotton
– Richie Cotton

2011-08-31 10:53:31 +00:00
Commented Aug 31, 2011 at 10:53 — Richie Cotton
– Richie Cotton, Commented Aug 31, 2011 at 10:53

Richie Cotton · Accepted Answer · 2011-08-31 11:00:09Z

3

Use merge to merge the data frames.

merged <- merge(a1, a2, c("B", "D"))
subset(merged, select = c(A.x, A.y))

answered Aug 31, 2011 at 11:00

Richie Cotton

122k47 gold badges254 silver badges371 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Compare two data.frames to find the rows in data.frame 1 and data.frame 2 which have equal values in selected columns

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related