Open 1to1 left.csv: | Open 1to1 right.csv: |
left <- read.csv('1to1 left.csv') | right <- read.csv('1to1 right.csv') |
left key Veggies 1 Mon Broccoli 2 Tue Celery 3 Thu Lettuce 4 Fri Spinach | right key Fruits 1 Mon Apples 2 Wed Bananas 3 Thu Cherries 4 Sat Dates |
outer_right <- merge(x = left, y = right, by = 'key', all.y = TRUE)
outer_right
key Veggies Fruits
1 Mon Broccoli Apples
2 Thu Lettuce Cherries
3 Sat <NA> Dates
4 Wed <NA> Bananas
# Or with the dplyr package
library(dplyr)
r_join <- left %>% right_join(right, by = 'key')
# Or by default
r_join <- left %>% right_join(right)
r_join
key Veggies Fruits
1 Mon Broccoli Apples
2 Wed <NA> Bananas
3 Thu Lettuce Cherries
4 Sat <NA> Dates
Functions referenced:
right_join (page 28)
More information:
RStudio Data Wrangling Cheatsheet
--- The End ---