Extract rows from data frame based on multiple identifiers in another data frame

Question

I would like to extract a selection of rows from a data frame based on multiple identifying variables contained in another data frame. Consider the following illustrative data set:

df <- data.frame(id=c(1,2,2,3,4,4,4,4,5), ref=c("A","B","C","D","E","F","F","G","H"), amount=c(10,15,20,25,30,35,-35,40,45))
required <- data.frame(id=c(2,3,4,4), ref=c("B","D","E","F"))

I would like the output in a data frame with id, ref and amount as follows:

id ref amount
2 B 15
3 D 25
4 E 30
4 F 35
4 F -35

Note in particular that id 4 and ref F have two matches from the df with amounts 35 and -35.

Matthew Lundberg · Accepted Answer · 2014-01-25 17:30:21Z

1

You want to merge:

merge(df, required)
##    id ref amount
##  1  2   B     15
##  2  3   D     25
##  3  4   E     30
##  4  4   F     35
##  5  4   F    -35

answered Jan 25, 2014 at 17:30

Matthew Lundberg

42.8k6 gold badges93 silver badges112 bronze badges

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

Collectives™ on Stack Overflow

Extract rows from data frame based on multiple identifiers in another data frame

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