This week we merged the separate cleaned files together into one the sample data file is starting to get big at this point and the merge was interesting to perform. We settled on performing an outer join so that information isn’t lost since we ensured we are only keeping information for patients that have a diagnosis and have information in the files from which we extracted data from.
However, the merge reintroduced null values hence the next step is to fill in these data points for each patient via data interpolation. hopefully that goes smoothly.
The Stallions Chronicle 