Write a R program to create inner, outer, left, right join(merge) from given two data frames

  • برمجة R

Write a R program to create inner, outer, left, right join(merge) from given two data frames.

الأجوبة

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
هل كان المحتوى مفيد؟

معلومات ذات صلة

تبحث عن مدرس اونلاين؟

محتاج مساعدة باختيار المدرس الافضل؟ تواصل مع فريقنا الان لمساعدتك بتأمين افضل مدرس
ماهو التخصص الذي تبحث عنه؟
اكتب هنا...