i want to combining 2 dataframe but there are diferent variable
example

df1=data.frame(x1=c(1,1,1,2,2,2,2),x2=c("a","a","b","b","c","c","c"),x3=c("t","u","v","w","x","y","z"),x4=c("apple","apple","mango","mango","mango","mango","mango"))

df2=data.frame(x1=c(1,1,1,2,2,2,2),x2=c("a","a","b","b","c","c","c"),x4=c("apple","banana","banana","melon","melon","melon","melon"),x5=c("t","u","v","w","x","y","z"))

i’d tried with cbind, rbind, merge, right and left join, but no one can like I expected. my expectation in df is there 13 row and 5 column. why 13 column? because in row 1 can combined

>Solution :

You could do:

full_join(mutate(df1, x6 = x3), mutate(df2, x3 = x5)) %>% select(x1, x2, x3 = x6, x4, x5)

   x1 x2   x3     x4   x5
1   1  a    t  apple    t
2   1  a    u  apple <NA>
3   1  b    v  mango <NA>
4   2  b    w  mango <NA>
5   2  c    x  mango <NA>
6   2  c    y  mango <NA>
7   2  c    z  mango <NA>
8   1  a <NA> banana    u
9   1  b <NA> banana    v
10  2  b <NA>  melon    w
11  2  c <NA>  melon    x
12  2  c <NA>  melon    y
13  2  c <NA>  melon    z