Wiki » History » Sprint/Milestone 2
Steven (eSHIFT) Uggowitzer, 01 June 2022 02:17 PM
| 1 | 2 | Steven (eSHIFT) Uggowitzer | h1. ODX - by the Software for Health Foundation |
|---|---|---|---|
| 2 | A bespoke tool designed to assist in data cleaning of AMR spreadsheets |
||
| 3 | 1 | Steven (eSHIFT) Uggowitzer | |
| 4 | 2 | Steven (eSHIFT) Uggowitzer | Created to address the expressed need of Nepal National Public Health Laboratory; they receive AST (Antimicrobial Susceptibility Testing (AST) Data | HAI data from public and private hospitals in spreadsheet form, extracted from many different LIMS systems and have significant challenges cleaning and managing that data for analysis and reporting. |
| 5 | 1 | Steven (eSHIFT) Uggowitzer | |
| 6 | 2 | Steven (eSHIFT) Uggowitzer | We engaged with LIMS service providers in Nepal to improve LIS extract formats where possible, and developed ODX to facilitate the data cleaning process |
| 7 | |||
| 8 | Users can load AST spreadsheets (extracts from LIS) into ODX, configure a few options such as whether it’s a human or animal health spreadsheet, source lab etc. |
||
| 9 | |||
| 10 | ODX will then output a new spreadsheet that has been cleaned based on user-configurable spelling mappings for column headers and required fields, or will give the user an error if something is not recognized or missing. |
||
| 11 | For example, if E. coli is misspelled in the spreadsheet it will automatically change it to the correct spelling if it is recognized, or will show an error if not. |
||
| 12 | |||
| 13 | This allows users to either manually change errors in the data set, or configure the system to fix things automatically if it is a common error. |
||
| 14 | |||
| 15 | ODX can fix spelling errors in antibiotics, pathogens, sample types, animal species, and automatically fix date errors or age issues. |