Thompson Laboratory for Regenerative Orthopedics, Department of Orthopedic Surgery, Missouri Orthopedic Institute, University of Missouri, Columbia, MO, USA.
Thompson Laboratory for Regenerative Orthopedics, Department of Orthopedic Surgery, Missouri Orthopedic Institute, University of Missouri, Columbia, MO, USA.
J Clin Densitom. 2021 Oct-Dec;24(4):658-662. doi: 10.1016/j.jocd.2021.02.002. Epub 2021 Feb 14.
INTRODUCTION/BACKGROUND: Since the 1970s imaging devices have been rapidly advancing to provide researchers, clinicians, radiologists, and practitioners greater capabilities to image bone. Today, dual-energy X-ray absorptiometry (DXA) has emerged as the gold standard for the assessment of bone and body composition. Despite recent improvements in DXA image quality and reduced radiation dosages and scan times, the data extraction process has yet to be streamlined. The objective of this study was to design an application to allow DXA users to quickly and accurately transfer DXA report data directly into a user-friendly format.
Initial development of the DXA Data Xtraction Assistant (DXA) included processing 485 DXA reports from a previous study. Using Python script, numeric data from these DXA reports were converted to .csv files and then merged into one file, effectively compiling and organizing all table data from each report, by participant and visit number. A graphical user interface was then developed and beta tested using multiple DXA manufacturers, models, and software versions. To compare the effectiveness of the DXA to the current standard of manual extraction, all 485 reports were manually transcribed into Microsoft Excel. The time required per report and the error rates were compared.
Manual transcription, by an experienced researcher, took over 10 h with an error rate of 0.6% and average error magnitude of 51%. Data extraction from DXA took less than 25 min to retrospectively reformat all DXA reports for the DXA and transcribe all 485 reports with 100% accuracy.
The DXA application automates DXA report data extraction and aggregation for clinical, research, and applied settings and drastically reduces manual data entry time and eliminates transcription errors.
简介/背景：自 20 世纪 70 年代以来，成像设备迅速发展，为研究人员、临床医生、放射科医生和从业人员提供了更大的能力来对骨骼进行成像。如今，双能 X 射线吸收法（DXA）已成为评估骨骼和身体成分的金标准。尽管 DXA 的图像质量、辐射剂量和扫描时间最近有所改善，但数据提取过程仍有待简化。本研究的目的是设计一个应用程序，使 DXA 用户能够快速、准确地将 DXA 报告数据直接转移到用户友好的格式中。
DXA 数据提取助手（DXA）的初步开发包括处理来自先前研究的 485 份 DXA 报告。使用 Python 脚本，将这些 DXA 报告中的数字数据转换为.csv 文件，然后将它们合并到一个文件中，有效地按参与者和访问编号编译和组织每个报告的所有表格数据。然后开发了一个图形用户界面，并使用多个 DXA 制造商、型号和软件版本进行了测试。为了比较 DXA 的有效性与当前的手动提取标准，将所有 485 份报告手动转录到 Microsoft Excel 中。比较了每份报告所需的时间和错误率。
由经验丰富的研究人员手动转录，需要超过 10 小时，错误率为 0.6%，平均错误幅度为 51%。从 DXA 中提取数据，只需不到 25 分钟的时间，即可回顾性地重新格式化所有 DXA 报告，并以 100%的准确率转录所有 485 份报告。
DXA 应用程序实现了临床、研究和应用环境中 DXA 报告数据的自动提取和聚合，大大减少了手动数据输入时间，并消除了转录错误。
