R - subsetting rows from a data frame for column values within a vector

Question

Have a data.frame, df as below

id | name | value
1  | team1 | 3
1  | team2 | 1
2  | team1 | 1
2  | team2 | 4
3  | team1 | 0
3  | team2 | 6 
4  | team1 | 1
4  | team2 | 2 
5  | team1 | 3
5  | team2 | 0

How do we subset the data frame to get rows for all values of id from 2:4 ?

We can apply conditionally like df[,df$id >= 2 & df$id <= 4] . But is there a way to directly use a vector of integer ranges like ids <- c(2:4) to subset a dataframe ?

One way to do this is df[,df$id >= min(ids) & df$id <= max(ids)].

Is there a more elegant R way of doing this ?

df[df$id %in% ids,]. Or subset(df,subset=id %in% ids)

Jason
– Jason

2015-07-23 04:00:11 +00:00
Commented Jul 23, 2015 at 4:00 — Jason
– Jason, Commented Jul 23, 2015 at 4:00

Rorschach · Accepted Answer · 2015-07-23 04:04:07Z

2

The most typical way is mentioned already, but also variations using match

with(df, df[match(id, 2:4, F) > 0, ])

or, similar

with(df, df[is.element(id, 2:4), ])

answered Jul 23, 2015 at 4:04

Rorschach

32.7k5 gold badges87 silver badges135 bronze badges

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

2 Comments

akrun Over a year ago

Or library(data.table);setDT(df, key='id')[.(2:4)]

akrun Over a year ago

are you using the devel version? Otherwise you may need setkey(setDT, id)[.(2:4)]

Collectives™ on Stack Overflow

R - subsetting rows from a data frame for column values within a vector

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related