Welcome to TidyPanel | Features | Basic Usage | Cleaning Variable Names | Advanced Features: Hierarchies and Audit Logs
Package: TidyPanel 0.1.2
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. Now natively supports Excel files, flat-file databases (CSV/TSV), 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) <doi:10.18637/jss.v059.i10> and the 'readxl' parsing infrastructure described in Wickham & Bryan (2023) <https://readxl.tidyverse.org>.
Authors:
TidyPanel_0.1.2.tar.gz
TidyPanel_0.1.2.zip(r-4.7)TidyPanel_0.1.2.zip(r-4.6)TidyPanel_0.1.2.zip(r-4.5)
TidyPanel_0.1.2.tgz(r-4.6-any)TidyPanel_0.1.2.tgz(r-4.5-any)
TidyPanel_0.1.2.tar.gz(r-4.7-any)TidyPanel_0.1.2.tar.gz(r-4.6-any)
TidyPanel_0.1.2.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION
card.svg |card.png
TidyPanel/json (API)
| # Install 'TidyPanel' in R: |
| install.packages('TidyPanel', repos = c('https://tonyisfool.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/tonyisfool/tidypanel/issues
Last updated from:06d56d5f9a. Checks:7 WARNING, 2 OK. Indexed: yes.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel-x86_64 | WARNING | 117 | ||
| source / vignettes | OK | 203 | ||
| linux-release-x86_64 | WARNING | 129 | ||
| macos-release-arm64 | WARNING | 107 | ||
| macos-oldrel-arm64 | WARNING | 91 | ||
| windows-devel | WARNING | 88 | ||
| windows-release | WARNING | 107 | ||
| windows-oldrel | WARNING | 77 | ||
| wasm-release | OK | 101 |
Exports:clean_variable_namesdetect_panel_structureinfer_data_typesnormalize_unitsread_messy_panelvalidate_panel
Dependencies:cellrangerclicpp11crayondplyrgenericsgluehmslifecyclemagrittrpillarpkgconfigprettyunitsprogressR6readxlrematchrlangstringistringrtibbletidyselectutf8vctrswithryaml
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Standardize and Clean Variable Names | clean_variable_names |
| Diagnose the Structure of a Messy Excel Panel File | detect_panel_structure |
| Smart Type Coercion & NA Recognition | infer_data_types |
| Normalize Numeric Columns Based on Header Unit Declarations | normalize_units |
| Robust Parsing and Extraction of Messy Excel Panel Data | read_messy_panel |
| Validate Data Quality of a Cleaned Panel Data Frame | validate_panel |
