One of our collaborators was generating 20 odd files from a clinical research form (CRF) database. They all had the same identifiers but were broken up into several variables. I was in a meeting with him one day where I saw him trying to vlookup and merging these files…. Well, something needed to be done to avoid that tedious process!
Below is a short post on merging any number of files which have the same identifiers in python.