Data cleaning on lab and vital periodic tables were done this week.
From the ‘lab.csv’ file, wbcx1000, lactate and creatinine values were all extracted from the ‘labname’ column per patient by making rows with data into columns. This was paired with the lab’s offset value to synchronize overlapping patient data.
Within the ‘vitalPeriodic.csv’ file, temperature, heartrate, respiration and systemicsystolic were gathered as well.
All values were all extracted and written to separate csv files.