r - How to take values from one df and transfer to another based on a common column?

Question

This question already has answers here: question from:https://stackoverflow.com/questions/65881185/how-to-take-values-from-one-df-and-transfer-to-another-based-on-a-common-column

Answer 1

library(tidyverse)

my_df %>%
  left_join(., dictionary, by = "word") %>%
  mutate(sentiment = coalesce(sentiment.x, sentiment.y)) %>%
  select(-ends_with(c(".x", ".y")))

gives:

    name       word sentiment
1  Alice    absence  negative
2   Alex accomplish  positive
3 Andrew      angry  negative
4    Amy       envy      <NA>