EasyMergeR: an interactive Shiny application to manipulate multiple XLSX files of multiple sheets

Ziyu Zhu,Ximing Xu
2023-08-08
Abstract:The integration of sequencing data with clinical information is a widely accepted strategy in bioinformatics and health informatics. Despite advanced databases and sophisticated tools for processing omics data, challenges remain in handling the raw clinical data (typically in XLSX format with multiple sheets inside), either exported from health information system (HIS) or manually collected by investigators. This is particularly difficult for time-constrained medical staff with little or no programming background, and it is typically the first bottleneck in many clinical-oriented studies. To fill this gap, we developed EasyMergeR, a simple, user-friendly, code-free R Shiny application that allows interactive manipulation of multiple XLSX files with multiple sheets and provides basic data manipulation capabilities based on the tidyverse and other handy R packages.
Quantitative Methods
What problem does this paper attempt to address?
The paper is primarily dedicated to addressing the challenges of handling raw clinical data (usually stored in XLSX format and containing multiple worksheets) in clinical research. Specifically: - **Challenges in Clinical Data Processing**: With the development of Hospital Information Systems (HIS), although a large amount of electronic medical records and other medical information can be integrated, doctors face difficulties in processing this data. This is especially true for doctors without a programming background, making it the primary bottleneck in clinical research. - **Development Purpose**: To fill this gap, the authors developed EasyMergeR—an interactive, user-friendly, and code-free application based on the R and Shiny framework. EasyMergeR aims to simplify the manipulation of multiple XLSX files and their internal worksheets, providing basic data processing functions based on tidyverse and other commonly used R packages. In this way, EasyMergeR hopes to simplify the data preparation process, enabling users to conduct their research more easily, particularly those doctors who are not familiar with programming.