R Programming: Create inner, outer, left, right join from given two data frames
R Programming: Data frame Exercise-13 with Solution
Write a R program to create inner, outer, left, right join(merge) from given two data frames.
Sample Solution :
R Programming Code :
df1 = data.frame(numid = c(12, 14, 10, 11))
df2 = data.frame(numid = c(13, 15, 11, 12))
print("Left outer Join:")
result = merge(df1, df2, by = "numid", all.x = TRUE)
print(result)
print("Right outer Join:")
result = merge(df1, df2, by = "numid", all.y = TRUE)
print(result)
print("Outer Join:")
result = merge(df1, df2, by = "numid", all = TRUE)
print(result)
print("Cross Join:")
result = merge(df1, df2, by = NULL)
print(result)
Pictorial Presentation :

Sample Output:
[1] "Left outer Join:" numid 1 10 2 11 3 12 4 14 [1] "Right outer Join:" numid 1 11 2 12 3 13 4 15 [1] "Outer Join:" numid 1 10 2 11 3 12 4 13 5 14 6 15 [1] "Cross Join:" numid.x numid.y 1 12 13 2 14 13 3 10 13 4 11 13 5 12 15 6 14 15 7 10 15 8 11 15 9 12 11 10 14 11 11 10 11 12 11 11 13 12 12 14 14 12 15 10 12 16 11 12
R Programming Code Editor:
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a R program to sort a given data frame by multiple column(s).
Next: Write a R program to replace NA values with 3 in a given data frame.
Test your Programming skills with w3resource's quiz.
What is the difficulty level of this exercise?
- Weekly Trends
- Python Interview Questions and Answers: Comprehensive Guide
- Scala Exercises, Practice, Solution
- Kotlin Exercises practice with solution
- MongoDB Exercises, Practice, Solution
- SQL Exercises, Practice, Solution - JOINS
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- JavaScript String Exercises
- JavaScript HTML Form Validation
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join
We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook