How to take data from dataframe to put it in another dataframe in R?

Question

[Amr]

How to take data from dataframe to put it in another dataframe in R?

I have a dataframe A has columns such as "Ensemble_Gene_id" and "Symbols", I have another dataframe B has only "Ensemble_Gene_id" but with filtered rows (not all rows same as dataframe A).

How to make column in dataframe B named "Symbols" which have the symbols of "Ensemble_Gene_id" in dataframe B? I want to take their symbols from dataframe A.

[Basti]

Maybe it should have been clearer with an example, but do you need merge(A,B,by="Ensemble_Gene_id") ?

[Amr]

Yes I guess this works too :) . it worked with left_join

Thanks

[ATpoint]

It's Ensembl, not Ensemble!

[Amr]

This is the answer?