How can you merge two data frames in R?

Instruction: Provide an example to illustrate how to merge two data frames by a common column in R.

Context: This question checks the candidate's ability to manipulate and combine data sets, a common task in data analysis.