filter_joins | R Documentation |
x
based on the presence or absence of
matches in y
:semi_join()
return all rows from x
with a match in y
.
anti_join()
return all rows from x
without a match in y
.
anti_join(x, y, by = NULL)
semi_join(x, y, by = NULL)
x, y |
The |
by |
A character vector of variables to join by. If |
table1 <- data.frame(
pupil = rep(1:3, each = 2),
test = rep(c("A", "B"), 3),
score = c(60, 70, 65, 80, 85, 70),
stringsAsFactors = FALSE
)
table2 <- table1[c(1, 3, 4), ]
table1 %>% anti_join(table2, by = c("pupil", "test"))
table1 %>% semi_join(table2, by = c("pupil", "test"))
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.