Understanding Why Merging DataFrames in R Results in More Rows Than Original Data

Joining Data Frames in R: A Comprehensive Guide to Inner, Outer, Left, and Right Joins