select a row based on different column value (same row)

Question

df <- data.frame(ID = rep(c("WTN", "KON", "WTH","KOH"), each = 3),
                 Time = rep(c("A", "B", "C"), times = 4),
                 replicate(3,sample(1:100,12,rep=TRUE)))

I want to select a row based on the values of two different columns of the same row, in this case "WTN" and "A". Expected output:

1  WTN    A 84 96 26

It is not clear about the logic. Also, please use `set.seed` to make this reproducible — akrun, Feb 01 '17 at 09:29

score 0 · Accepted Answer · answered Feb 01 '17 at 09:39

0

We can use filter from dplyr

 library(dplyr)
 df %>%
     filter(ID == "WTN" & Time == "A")

answered Feb 01 '17 at 09:39

akrun

874,273
37
540
662

Thanks. Can I use this approach to subset just columns with values? – Al14 Feb 01 '17 at 09:48
@Al14 You can add `%>% select(-ID)` if I understand your question – akrun Feb 01 '17 at 09:49
Am I going to need a second line after filter? – Al14 Feb 01 '17 at 09:51
1

@Al14 Perhaps `df %>% filter(ID == "WTN" & Time == "A") %>% select(-ID, -Time) %>% unlist(., use.names = FALSE)` – akrun Feb 01 '17 at 09:51

select a row based on different column value (same row)

1 Answers1

Linked

Related