merge two columns r code example

Example 1: combine columns in r

df.1 <- data.frame("Name" = c("Jill","Jack","John"))
df.2 <- data.frame("Age" = c(42,16,63))
df.comb <- cbind(df.1,df.2)

Example 2: r merge by two columns

x <- data.frame(k1=c(NA,NA,3,4,5), k2=c(1,NA,NA,4,5), data=1:5)
y <- data.frame(k1=c(NA,2,NA,4,5), k2=c(NA,NA,3,4,5), data=1:5)
merge(x, y, by=c("k1","k2"))