Lab Data Extractor

This application allows you to import text files containing lab data, extract values for various lab variables, and compile them into a CSV file. It supports multiple text files per patient and handles missing data by leaving cells empty in the output CSV.

Installation

1. Ensure you have Python 3.6 or higher installed on your system.
2. No additional libraries are required beyond the standard library (tkinter is included with Python).

Usage

1. Run the lab_data_extractor.py script:

   python lab_data_extractor.py

2. In the GUI, enter the Patient ID and Patient Name.
3. Click Add Files to select text files containing lab data for the patient.
4. Click Extract Data and Add Row to process the files and add the data to the table.
5. Repeat steps 2-4 for each patient.
6. Click Save to CSV to export the compiled data to a CSV file.

Features

• Extracts lab data from text files for Hematology, Biochemistry, and Blood Gas variables.
• Supports multiple files per patient, consolidating data into a single row.
• Leaves cells empty for variables with no data.
• User-friendly GUI for easy data entry and file management.

Lab Variables

Hematology

• W.B.C, R.B.C, Hemoglobin, Hematocrit, Platelets, ESR 1st hr, RDW /cv, MPV, M.C.H, M.C.H.C, M.C.V, Neutrophils, Lymphocytes, Monocytes, Eosinophils, Band Cells, Toxic Granula

Biochemistry

• Blood Urea Nitrogen (BUN), Creatinine (Cr), Phosphatase Alkaline (Al Pos), S.G.O.T, AST, S.G.P.T, ALT, Calcium (Ca), Phosphorus (P), LDH, Magnesium (Mg), CK-MB, Troponin I, Sodium (Na), Potassium (K), Blood Sugar (BS)

Blood Gas

• pH (ABG), pCo2, pO2, HCO3, O2 Sat