Detection and Assessment of Date-Like Anomalies in Clinical Laboratory Reference Ranges
DOI:
https://doi.org/10.59992/IJCI.2026.v5n10p3الكلمات المفتاحية:
Clinical Laboratory Data، Reference Range، Data Quality، Date-Like Anomalies، Candidate Reconstructionالملخص
The interpretation of clinical laboratory data is greatly influenced by reference ranges. But these ranges may result in date-like expressions which can block direct numeric processing and obscure the original range limits. In this study, this is explored with the Multi-Center Clinical Laboratory Dataset (MCLD) by integration of Rule Based Detection (RBD), Numeric Parsing Validation (NPV) and Rule Based Candidate Reconstruction (RBCR). The expression for dates is discovered by RBD, the range for interpretation is checked by the NPV, and potential numeric intervals are created by the RBCR. The candidates generated are evaluated for consistency and ambiguity within the candidates. In 145,288 laboratory records examined, 5,054 (3.48%) had date-like reference-range expressions, representing 18 different combinations of test name, expression, and measurement units. 18 cases were coded as numeric candidates. These candidates matched the Normal and Abnormal classifications on 5054 affected records. An additional analysis found compatible alternative intervals in 14 of the 18 cases within a limited search grid of integer boundaries. The results demonstrate that there is not always a single reference interval associated with a particular classification. The framework enables identification of anomalies that fall outside of date ranges, some possible numeric corrections, and the assessment of internal consistency and ambiguity of those corrections.
المراجع
] Clinical and Laboratory Standards Institute. Defining, Establishing, and Verifying Reference Intervals in the Clinical Laboratory. CLSI document EP28-A3c. 2010. https://clsi.org/shop/standards/ep28/
[2] Broman KW, Woo KH. Data Organization in Spreadsheets. The American Statistician. 2018;72(1):2–10. https://doi.org/10.1080/00031305.2017.1375989
[3] Ziemann M, Eren Y, El-Osta A. Gene name errors are widespread in the scientific literature. Genome Biology. 2016;17:177. https://doi.org/10.1186/s13059-016-1044-7
[4] Mahmood ML, Rawf KM, Mohammed HM, Salih WM, Abdalqadir AH. Multi-Center Clinical Laboratory Dataset (MCLD). Mendeley Data. 2026;Version 1. https://doi.org/10.17632/xxkd3kjfdd.1
[5] Van den Broeck J, Argeseanu Cunningham S, Eeckels R, Herbst K. Data Cleaning: Detecting, Diagnosing, and Editing Data Abnormalities. PLOS Medicine. 2005;2(10):e267. https://doi.org/10.1371/journal.pmed.0020267
[6] Chu X, Ilyas IF, Krishnan S, Wang J. Data Cleaning: Overview and Emerging Challenges. Proceedings of the 2016 International Conference on Management of Data. 2016:2201–2206. https://doi.org/10.1145/2882903.2912574
[7] Rekatsinas T, Chu X, Ilyas IF, Ré C. HoloClean: Holistic Data Repairs with Probabilistic Inference. Proceedings of the VLDB Endowment. 2017;10(11):1190–1201. https://doi.org/10.14778/3137628.3137631
[8] Mahdavi M, Abedjan Z, Castro Fernandez R, Madden S, Ouzzani M, Stonebraker M, Tang N. Raha: A Configuration-Free Error Detection System. Proceedings of the 2019 International Conference on Management of Data. 2019:865–882. https://doi.org/10.1145/3299869.3324956
[9] National Board of Medical Examiners (NBME). Laboratory Values [Internet]. Available from: https://www.nbme.org/laboratory-values/ (accessed 15 October 2026).
[10] Rahm E, Do HH. Data Cleaning: Problems and Current Approaches. IEEE Data Engineering Bulletin. 2000;23(4):3–13. https://dbs.uni-leipzig.de/research/publications/data-cleaning-problems-and-current-approaches
[11] Karr AF, Sanil AP, Banks DL. Data quality: A statistical perspective. Statistical Methodology. 2006;3(2):137–173. https://doi.org/10.1016/j.stamet.2005.08.005
[12] Kandel S, Heer J, Plaisant C, Kennedy J, van Ham F, Henry Riche N, et al. Research directions in data wrangling: Visualizations and transformations for usable and credible data. Information Visualization. 2011;10(4):271–288. https://doi.org/10.1177/1473871611415994
[13] Dallachiesa M, Ebaid A, Eldawy A, Elmagarmid AK, Ilyas IF, Ouzzani M, Tang N. NADEEF: A commodity data cleaning system. Proceedings of the ACM SIGMOD International Conference on Management of Data. 2013:541–552. https://doi.org/10.1145/2463676.2465327
[14] Abedjan Z, Chu X, Deng D, Castro Fernandez R, Ilyas IF, Ouzzani M, et al. Detecting data errors: Where are we and what needs to be done? Proceedings of the VLDB Endowment. 2016;9(12):993–1004. https://doi.org/10.14778/2994509.2994518
[15] Heidari A, McGrath J, Ilyas IF, Rekatsinas T. HoloDetect: Few-Shot Learning for Error Detection. Proceedings of the 2019 International Conference on Management of Data. 2019:829–846. https://doi.org/10.1145/3299869.3319888
