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,Continue reading “The Lab Data Transmogrification”
Author Archives: thestallions
Nani!!!
So the creators of the code finally got back to us. They recommended us to run the code on a machine with 20 CPU cores and 256GB RAM. I’m so confused how would providing more resources fix missing values errors. Seems like that is a dead end. I’m beginning to doubt how accurate the resultsContinue reading “Nani!!!”
The Intake-Output Extraction
In the continuation for the battle in acquiring urine output values, we loaded in the ‘intakeOutput.csv’ file. This served as a way of gathering the urine output values for only the patient IDs that we specified. More tests were done on the validity of all data cleaning processes. We are currently in the process onContinue reading “The Intake-Output Extraction”
Show Me The Data!
We decided to move on as we wait to get a reply for the creators of the competition code. We started to look through the database to find all the useful information that the doctor told us would be useful. We were able to find everything within the dataset thankfully. The urine output by weightContinue reading “Show Me The Data!”
Demo Usage
Having encountered many issues in using the full datasets in cleaning and feature extraction, a decision was made to use the demo datasets to create the framework and pipelines for our data cleaning and neural network models, after a Professor at the University kindly offered the use of their personal lab machine to run theContinue reading “Demo Usage”
The Patient Data Insufficiency
In the hunt for training data, we first began with grabbing all the patients that are only diagnosed with sepsis in order to shrink the data set, this allowed us to utilize the ‘diagnosis.csv’ file. This represented patients with sepsis as a ‘diagnosis : 1’ and patients without sepsisas ‘diagnosis : 0’. To begin ourContinue reading “The Patient Data Insufficiency”
Final Sepsis Features
After our last conversation with the consulting physician, the final features on which we plan to train the neural network were designed and extracted from the datasets. Cleaning the extracted data was attempted as well, however some problems were encountered in memory resources in cleaning the larger data files.
Sorting Out Plan of Action
We heard back from the doctor about what information we should look for in the dataset. This inlcudes: Urine output by weight temperature respiration rate white blood cell count creatinine lactate systemic systolic heart rate The following are the levels that could lead to septic shock upon further research: Body Attribute Body Attribute Value RequiredContinue reading “Sorting Out Plan of Action”
The Sepsis Hypothesis
The physician advised us on how sepsis is determined by summarizing Septic Shock. Septic shock, a subset of sepsis, is a severe condition that can possibly occur should sepsis lead to life-threatening hypo tension for a patient. The human body would possess the following attributes if they are in septic shock. Body Attribute Body AttributeContinue reading “The Sepsis Hypothesis”
Course Assignments & Supercomputers
Not much work was done this week, other than reaching out to the competitors for assistance in running and explaining their code. As other University courses had assignments due this week and time was spent working on them. Our email was responded with recommending using a virtual machine with more resources as they claim theirContinue reading “Course Assignments & Supercomputers”
The Stallions Chronicle 