English

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

Quantitative Methods 2023-08-10 v1

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.

Keywords

Cite

@article{arxiv.2308.04478,
  title  = {EasyMergeR: an interactive Shiny application to manipulate multiple XLSX files of multiple sheets},
  author = {Ziyu Zhu and Ximing Xu},
  journal= {arXiv preprint arXiv:2308.04478},
  year   = {2023}
}

Comments

6 pages, 1 figure

R2 v1 2026-06-28T11:51:10.842Z