Package: TidyPanel Title: Universal Messy Panel Data Cleaner Version: 0.2.134 Authors@R: person(given = "Tony", family = "Lu", email = "xulunt123@gmail.com", role = c("aut", "cre")) Author: Tony Lu [aut, cre] Maintainer: Tony Lu Description: A robust toolkit designed to standardize and clean complex tabular data from commercial enterprise systems, healthcare records, logistics software, and HR databases. Now natively supports Excel files, flat-file databases (CSV/TSV/RDB), gzip-compressed CSV/TSV/TXT/RDB files, and raw data.frame inputs. Features include intelligent regex parsing for domain-specific noise (currencies, percentages), horizontal side-by-side panel splitting, automated metadata key-value extraction from decoy rows, gap-based block clustering, and messy table resolution. Methods draw on tidy data principles described in Wickham (2014) and the 'readxl' parsing infrastructure described in Wickham & Bryan (2023) . A local JSON command-line interface supports reproducible table-cleaning jobs and bounded agent handoffs. License: MIT + file LICENSE Encoding: UTF-8 Depends: R (>= 4.1.0) Roxygen: list(markdown = TRUE) RoxygenNote: 7.3.3 Imports: dplyr, stringr, stringi, readxl, jsonlite (>= 1.8.9) Suggests: knitr, rmarkdown VignetteBuilder: knitr Config/TidyPanel/Edition: public Config/pak/sysreqs: libicu-dev Repository: https://tonyisfool.r-universe.dev Date/Publication: 2026-11-04 03:40:24 UTC RemoteUrl: https://github.com/tonyisfool/tidypanel RemoteRef: HEAD RemoteSha: cb715cb003827b1874827ea0f2f92ad1c384728a NeedsCompilation: no Packaged: 2026-11-04 06:50:38 UTC; root