I have two data frames. These are are two waves of the same survey, so they were filled out by the same people. Some of the column names are thus identical (.e.g email) and some are different (e.g. "question123" in dataframe A and "question678" in dataframe B".
I want to merge these two data frames so I have one row for every participant. The columns that overlap would ideally then also only exist once.
I tried to use the command "merge" to merge both dataframes but when I do this, every column gets doubled and I end up with two columns e.g. email.x and email.y with the same content.
How do I best do this?
