R programming Merging in R Programming

Question

I'm trying to merge 2 data frames where each data frame has the same column name 'Date_Time' but different row counts. These are my data frames:

df1

Cmny_Name     Date_Time      Price 
A          1/1/2015 13:27    1083
B          1/1/2015 13:28    1084
C          1/1/2015 13:29    1053
D          1/1/2015 13:31    1063
E          1/1/2015 13:33    1033

df2:

Cmny_Name1     Date_Time      Price 
A          1/1/2015 13:27    1043
A          1/1/2015 13:28    1053
A          1/1/2015 13:29    1054
A          1/1/2015 13:35    1084

I want my output to look like this: (df3)

Date_Time      Cmny_Name    Price   Cmny_Name1     Price   
1/1/2015 13:27   A          1083        A          1043
1/1/2015 13:28   B          1084        A          1053
1/1/2015 13:29   C          1053        A          1054
1/1/2015 13:31   D          1063        A           NA
1/1/2015 13:33   E          1033        A           NA
1/1/2015 13:35   NA         NA          A          1084

Answer 1

You can merge the two data frames by following the below code snippet:

df3 <- merge(df1, df2, by = "Date_Time", all = TRUE)

Another way is to use the dplyr package:

library(dplyr)
df3 <- df1 %>% 
  full_join(df2, by = "Date_Time")

Hope it helps!

To learn more about R, enroll with data science with R programming course today.

Thanks.