I am recently on board of Studio coming from SPSS, and I ask for help.
I am working with two different data.frames (x and y), both of them contains around 300 columns/variables. I learn how to do a merging based on the same ID code from the subject ( merge (x, y, by = "ID", all= TRUE) but it merge both df with a total of 600 columns. Of course, this both df contains others similar variables, I was wondering if:
- Is there a way to identify the shared columns/variable between both df?
- How to merge all the same columns/variables of both df?
Thanks in advance and best regards!