Create a merged data set for a research project

Job ID: 31277389

Budget: $15 – $25 AUD

I have a research project where I need to take information about 15000 hospitals from two different data sets. One data set is about hospital performance and consists of a table indexed by hospital and metric and I want that data denormalised in a single table and the other data set is about what IT modules are in use in the hospital. The two data sets do NOT have a common primary index, so I need a foreign key synthesised based on matching State, Town, and a close match on address and name. That's the hard part of the project. I have attached the two data sets. I have not included the HIMSS db as it is 700mb. What my goal here is to be able to join these two data sets via an inner join so I can analyse Hospital IT use and hospital performance.