Hello everyone!
Many people I work with, or have worked with in the past, have trouble using R/Stata/Python; as such, they can often struggle to merge data collected via repeat groups. I built this small tool to help them merge data without the having to write a single line of code.
Welcome to MergeR: a Shiny app to merge datasets
How does it work?
Step 1: Upload datasets in xlsx, xls or .csv and inspect the columns if needed (if using repeat group data with main survey data, separate the sheets as independent xls files!)
Step 2: Choose the unique ID variables in each dataset, and choose the merge type (i.e. 1:1, m:1, 1:m) and click Merge Datasets
Step 3: View the merged dataset and visually inspect it (if needed) before downloading. There is also a new column created called “merge_status” which tells you if row K has been merged or not (and if not, the data source of row K)
Thats it!
PS: For those who are unclear on how to merge, there is also a small (very small in fact) guide on how to merge and the differentr merge types!
I hope some of you find this helpful!
Best,
Zaeen
