Using anti join
In this method of joining data, the user calls the right_join function and this will return all rows from x where there are no matching values in y, keeping just columns from x.
anti_join() function:
This function returns all rows from x where there are no matching values in y, keeping just columns from x.
Syntax:
anti_join(x, y, by = NULL, on = NULL)
Parameters:
- x: A data.table
- y: A data.table
- by: A character vector of variables to join by.
- on: Indicate which columns in x should be joined with which columns in y.
Example:
In this example, we will be using the anti_join() function from the dplyr package to join two different data as shown in the image above in the R programming language.
R
# load the library library("dplyr") # create the dataframes gfg1<-data.frame(ID=c(1:5)) gfg2<-data.frame(ID=c(4:8)) # perform anti join anti_join(gfg1,gfg2, by = "ID") |
Output:
ID 1 1 2 2 3 3
Joining Data in R with Dplyr Package
In this article, we will be looking at the different methods of joining data with the dplyr in the R programming language.
We need to load the dplyr package. Type the below commands –
Install - install.packages("dplyr")
Load - library("dplyr")
Contact Us