merging two files in JASP
I have two files, each with the same primary key. I would like to merge the data from these two files into one file, as in the example below:
PTID creatinine
1 1.5
2 0.8
PTID age
1 55
2 70
PTID creatinine age
1 1.5 55
2 0.8 70
Is there a way to do this in JASP?
Thank you!
Andrew Kramer
Comments
Unfortunately I don't think there is a way to do this from within JASP currently. In Excel I suspect you could achieve this with the vlookup() function, and in R (if you're familiar with it) you could do it in just a few lines using the full_join() or left_join() function of the dplyr package.
If it is just two files then I would just use copy-paste. A generic solution does not exist in JASP (yet). Would be a good feature request.
I used the VLOOKUP function in Excel, which is cumbersome. 😣
It would be a god feature to have in JASP, not just merging files but to match merge using one or more keys.
Earlier thread at https://forum.cogsci.nl/discussion/8023/how-to-merge-data-sets-in-jasp .
Feature request at https://github.com/jasp-stats/jasp-issues/issues/1557 .