am3010
am3010

Reputation: 67

R: How to use "NOT IN" logic in R

How can I convert below sql query to R Logic:

SELECT * FROM FRUITS WHERE (ID||TYPE||DATE) NOT IN (SELECT (ID||TYPE||DATE) FROM SEASONAL_FRUITS)

Upvotes: 2

Views: 91

Answers (1)

akrun
akrun

Reputation: 886938

WIth tidyverse, it would be anti join

library(dplyr)
anti_join(FRUITS, SEASONAL_FRUITS, by = c("ID", "TYPE", "DATE"))        

Upvotes: 1

Related Questions