Development of data processing and visualization for bacterial and antibiotic susceptibility profile

Abstract

Bacterial data are under-utilized in Maharaj Nakorn Chiang Mai hospital. Bacterial data contains information regarding the bacteria that are isolated from various biological samples collected in routine clinical cares. The data can be used to create bacterial profiles and antibiotics susceptibility profiles which help doctor decide on the most appropriate antibiotics agent to be given to patients with infection. The aims of this study were to develop an application which create bacterial profiles and antibiotics susceptibility profiles by utilizing the hospital bacterial data. To do this, the study was sub-divided into 4 parts 1. Development of ETL process to prepare data for utilization, 2. Data quality assessment, 3. Development of pilot application utilizing prepared data to create bacterial profiles and antibiotics susceptibility profiles, and 4. Feasibility assessment of the pilot application. All data was extracted from Maharaj Nakorn Chiang Mai hospital database from 2017 to 2018 with an assistance from hospital information technology (IT) personnel.All extracted data was explored and compile into one table to be utilized by the pilot application. The pilot application was written in Google Collaboratory. Overall, the data quality was good. There was some missing data but should barely affect reliability and performance of the application. For feasibility assessment, the pilot application was given to 6 doctors conveniently selected from all doctors working in the hospital for test uses. Later, the doctors were interviewed and asked to provide feedbacks on the pilot application. The application received positive review overall. Improvement points were addressed focusing on data cleaning and preprocessing, minimizing any potential bias. This study provides insight into the development processes of the pilot application that provide bacterial profiles and antibiotics susceptibility profiles to doctors. Modifications are required before such application can be used in clinical practice.