Combine-two-DataFrames-in-R-with-different-columns.R

# loading the required library
library("dplyr")

## 
## 载入程辑包：'dplyr'

## The following objects are masked from 'package:stats':
## 
##     filter, lag

## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union

# declaring first data frame
data_frame1 <- data.frame(col1 = c(1,2,3), 
                          col2 = c(4,5,6), 
                          col3 = LETTERS[1:3])
data_frame1

##   col1 col2 col3
## 1    1    4    A
## 2    2    5    B
## 3    3    6    C

# declaring second data frame
data_frame2 <- data.frame(col3 = letters[1:3], 
                          col4 = TRUE)
data_frame2

##   col3 col4
## 1    a TRUE
## 2    b TRUE
## 3    c TRUE

# declaring 3nd data frame
data_frame3 <- data.frame(col5 = LETTERS[4:6], 
                          col6 = F)
data_frame3

##   col5  col6
## 1    D FALSE
## 2    E FALSE
## 3    F FALSE

# binding data frames
bind_rows(data_frame1,data_frame2)

##   col1 col2 col3 col4
## 1    1    4    A   NA
## 2    2    5    B   NA
## 3    3    6    C   NA
## 4   NA   NA    a TRUE
## 5   NA   NA    b TRUE
## 6   NA   NA    c TRUE

bind_rows(data_frame1,data_frame3)

##   col1 col2 col3 col5  col6
## 1    1    4    A <NA>    NA
## 2    2    5    B <NA>    NA
## 3    3    6    C <NA>    NA
## 4   NA   NA <NA>    D FALSE
## 5   NA   NA <NA>    E FALSE
## 6   NA   NA <NA>    F FALSE

#https://www.geeksforgeeks.org/combine-two-dataframes-in-r-with-different-columns/