How to Combine Two Data Frames in R

Let's say you have two tables of data, maybe imported from separate csv files, and you would like to combine them into one data frame. In this article, we will learn how to combine two data frames in R.

There are two main ways to combine data frames in R. We can use cbind if we want to combine them side by side, and rbind if we want to stack them on top of each other.

If you have two data frames that you want to merge based on an Id (such as a user and their purchases), that will be our next article.

Let's see an example of using cbind to combine side by side.

df1 = data.frame(ads = c("Twitter", "Google"))
df2 = data.frame(sales = c(7000, 8000))

cbind(df1, df2)

#    ads     sales
# 1 Twitter  7000
# 2  Google  8000

Finally, let's see an example of rbind to stack two data frames on top of each other.

df1 = data.frame(ads = c("Twitter"), sales = c(7000))
df2 = data.frame(ads = c("Google"), sales = c(8000))

rbind(df1, df2)


#    ads     sales
# 1 Twitter  7000
# 2  Google  8000