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?
- New Content published on w3resource:
- HTML-CSS Practical: Exercises, Practice, Solution
- Java Regular Expression: Exercises, Practice, Solution
- Scala Programming Exercises, Practice, Solution
- Python Itertools exercises
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework
- Angular - JavaScript Framework
- Vue - JavaScript Framework
- Jest - JavaScript Testing Framework