Create column based on another dataframe

Question

I have what seems a simple requirement, but I can't seem to achieve the desired result. My dataframes are rather large, so I will just give a screenshot:

What I want is: if ps2c$ps == present2$pn then ps2c$sf == present2$sf.

If it is not clear, for every ps2c$ps there is a present2$pn (present2 is just the mean data).

Answer 1

You don't supply test data, but something like the following might work:

ps2c$sf <- present2$sf[match(ps2c$ps, present2$pn)]