Left Join and Right Join using dplyr

Question

I have these two data-frames - "Employee-Designation" and "Employee-Salary"

Employee-Designation:

Name  Designation 
 John    CTO
 Sam     CEO
 Raj     SDE
 Amy     COO
 Anne    Analyst

Employee-Salary:

Name  Salary 
 John    12345
 Sam     23456
 Jason   43251
 Adam    32411
 Anne    22212

I would want to perform left join and right join on these two data-sets and join these two by the "Name" column.

Answer 1

The below is the code to perform left join

left_join(employee_designation,employee_salary,by="name")

Similarly, you can perform the right join as well:

right_join(employee_designation,employee_salary,by="name")