TidyPanel: Universal Messy Panel Data Cleaner

A robust toolkit designed to standardize and clean complex tabular data from commercial enterprise systems, healthcare records, logistics software, and HR databases. Features include intelligent regex parsing for domain-specific noise (currencies, percentages), gap-based block clustering, and automated messy table resolution. Methods draw on tidy data principles described in Wickham (2014) <doi:10.18637/jss.v059.i10> and the 'readxl' parsing infrastructure described in Wickham & Bryan (2023) <https://readxl.tidyverse.org>.

Version: 0.1.2
Imports: dplyr, stringr, readxl
Suggests: knitr, rmarkdown, testthat, writexl
Published: 2026-05-11
DOI: 10.32614/CRAN.package.TidyPanel (may not be active yet)
Author: Tony Lu [aut, cre]
Maintainer: Tony Lu <xulunt123 at gmail.com>
License: MIT + file LICENSE
NeedsCompilation: no
Materials: README
CRAN checks: TidyPanel results

Documentation:

Reference manual: TidyPanel.html , TidyPanel.pdf
Vignettes: Introduction to TidyPanel (source, R code)

Downloads:

Package source: TidyPanel_0.1.2.tar.gz
Windows binaries: r-devel: not available, r-release: not available, r-oldrel: not available
macOS binaries: r-release (arm64): TidyPanel_0.1.2.tgz, r-oldrel (arm64): TidyPanel_0.1.2.tgz, r-release (x86_64): TidyPanel_0.1.2.tgz, r-oldrel (x86_64): not available

Linking:

Please use the canonical form https://CRAN.R-project.org/package=TidyPanel to link to this page.