r merge two columns 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"))

Example 3: combine ro columns in r

df$x <- paste(df$n,df$s)
 df
#   n  s     b    x
# 1 2 aa  TRUE 2 aa
# 2 3 bb FALSE 3 bb
# 3 5 cc  TRUE 5 cc