Addressing missing values in routine health information system data : an evaluation of imputation methods using data from the Democratic Republic of the Congo during the COVID-19 pandemic
© 2021. The Author(s)..
BACKGROUND: Poor data quality is limiting the use of data sourced from routine health information systems (RHIS), especially in low- and middle-income countries. An important component of this data quality issue comes from missing values, where health facilities, for a variety of reasons, fail to report to the central system.
METHODS: Using data from the health management information system in the Democratic Republic of the Congo and the advent of COVID-19 pandemic as an illustrative case study, we implemented seven commonly used imputation methods and evaluated their performance in terms of minimizing bias in imputed values and parameter estimates generated through subsequent analytical techniques, namely segmented regression, which is widely used in interrupted time series studies, and pre-post-comparisons through paired Wilcoxon rank-sum tests. We also examined the performance of these imputation methods under different missing mechanisms and tested their stability to changes in the data.
RESULTS: For regression analyses, there were no substantial differences found in the coefficient estimates generated from all methods except mean imputation and exclusion and interpolation when the data contained less than 20% missing values. However, as the missing proportion grew, k-NN started to produce biased estimates. Machine learning algorithms, i.e. missForest and k-NN, were also found to lack robustness to small changes in the data or consecutive missingness. On the other hand, multiple imputation methods generated the overall most unbiased estimates and were the most robust to all changes in data. They also produced smaller standard errors than single imputations. For pre-post-comparisons, all methods produced p values less than 0.01, regardless of the amount of missingness introduced, suggesting low sensitivity of Wilcoxon rank-sum tests to the imputation method used.
CONCLUSIONS: We recommend the use of multiple imputation in addressing missing values in RHIS datasets and appropriate handling of data structure to minimize imputation standard errors. In cases where necessary computing resources are unavailable for multiple imputation, one may consider seasonal decomposition as the next best method. Mean imputation and exclusion and interpolation, however, always produced biased and misleading results in the subsequent analyses, and thus, their use in the handling of missing values should be discouraged.
Medienart: |
E-Artikel |
---|
Erscheinungsjahr: |
2021 |
---|---|
Erschienen: |
2021 |
Enthalten in: |
Zur Gesamtaufnahme - volume:19 |
---|---|
Enthalten in: |
Population health metrics - 19(2021), 1 vom: 04. Nov., Seite 44 |
Sprache: |
Englisch |
---|
Beteiligte Personen: |
Feng, Shuo [VerfasserIn] |
---|
Links: |
---|
Anmerkungen: |
Date Completed 09.11.2021 Date Revised 09.11.2021 published: Electronic Citation Status MEDLINE |
---|
doi: |
10.1186/s12963-021-00274-z |
---|
funding: |
|
---|---|
Förderinstitution / Projekttitel: |
|
PPN (Katalog-ID): |
NLM332745589 |
---|
LEADER | 01000naa a22002652 4500 | ||
---|---|---|---|
001 | NLM332745589 | ||
003 | DE-627 | ||
005 | 20231225220217.0 | ||
007 | cr uuu---uuuuu | ||
008 | 231225s2021 xx |||||o 00| ||eng c | ||
024 | 7 | |a 10.1186/s12963-021-00274-z |2 doi | |
028 | 5 | 2 | |a pubmed24n1109.xml |
035 | |a (DE-627)NLM332745589 | ||
035 | |a (NLM)34736462 | ||
040 | |a DE-627 |b ger |c DE-627 |e rakwb | ||
041 | |a eng | ||
100 | 1 | |a Feng, Shuo |e verfasserin |4 aut | |
245 | 1 | 0 | |a Addressing missing values in routine health information system data |b an evaluation of imputation methods using data from the Democratic Republic of the Congo during the COVID-19 pandemic |
264 | 1 | |c 2021 | |
336 | |a Text |b txt |2 rdacontent | ||
337 | |a ƒaComputermedien |b c |2 rdamedia | ||
338 | |a ƒa Online-Ressource |b cr |2 rdacarrier | ||
500 | |a Date Completed 09.11.2021 | ||
500 | |a Date Revised 09.11.2021 | ||
500 | |a published: Electronic | ||
500 | |a Citation Status MEDLINE | ||
520 | |a © 2021. The Author(s). | ||
520 | |a BACKGROUND: Poor data quality is limiting the use of data sourced from routine health information systems (RHIS), especially in low- and middle-income countries. An important component of this data quality issue comes from missing values, where health facilities, for a variety of reasons, fail to report to the central system | ||
520 | |a METHODS: Using data from the health management information system in the Democratic Republic of the Congo and the advent of COVID-19 pandemic as an illustrative case study, we implemented seven commonly used imputation methods and evaluated their performance in terms of minimizing bias in imputed values and parameter estimates generated through subsequent analytical techniques, namely segmented regression, which is widely used in interrupted time series studies, and pre-post-comparisons through paired Wilcoxon rank-sum tests. We also examined the performance of these imputation methods under different missing mechanisms and tested their stability to changes in the data | ||
520 | |a RESULTS: For regression analyses, there were no substantial differences found in the coefficient estimates generated from all methods except mean imputation and exclusion and interpolation when the data contained less than 20% missing values. However, as the missing proportion grew, k-NN started to produce biased estimates. Machine learning algorithms, i.e. missForest and k-NN, were also found to lack robustness to small changes in the data or consecutive missingness. On the other hand, multiple imputation methods generated the overall most unbiased estimates and were the most robust to all changes in data. They also produced smaller standard errors than single imputations. For pre-post-comparisons, all methods produced p values less than 0.01, regardless of the amount of missingness introduced, suggesting low sensitivity of Wilcoxon rank-sum tests to the imputation method used | ||
520 | |a CONCLUSIONS: We recommend the use of multiple imputation in addressing missing values in RHIS datasets and appropriate handling of data structure to minimize imputation standard errors. In cases where necessary computing resources are unavailable for multiple imputation, one may consider seasonal decomposition as the next best method. Mean imputation and exclusion and interpolation, however, always produced biased and misleading results in the subsequent analyses, and thus, their use in the handling of missing values should be discouraged | ||
650 | 4 | |a Journal Article | |
650 | 4 | |a Research Support, Non-U.S. Gov't | |
650 | 4 | |a Health management information system (HMIS) | |
650 | 4 | |a Health services research | |
650 | 4 | |a Low- and middle-income countries (LMICs) | |
650 | 4 | |a Missing data | |
650 | 4 | |a Multiple imputation | |
650 | 4 | |a Routine health information systems (RHIS) | |
700 | 1 | |a Hategeka, Celestin |e verfasserin |4 aut | |
700 | 1 | |a Grépin, Karen Ann |e verfasserin |4 aut | |
773 | 0 | 8 | |i Enthalten in |t Population health metrics |d 2003 |g 19(2021), 1 vom: 04. Nov., Seite 44 |w (DE-627)NLM12539151X |x 1478-7954 |7 nnns |
773 | 1 | 8 | |g volume:19 |g year:2021 |g number:1 |g day:04 |g month:11 |g pages:44 |
856 | 4 | 0 | |u http://dx.doi.org/10.1186/s12963-021-00274-z |3 Volltext |
912 | |a GBV_USEFLAG_A | ||
912 | |a GBV_NLM | ||
951 | |a AR | ||
952 | |d 19 |j 2021 |e 1 |b 04 |c 11 |h 44 |