autodb: Automatic Database Normalisation for Data Frames
Automatic normalisation of a data frame to third normal form, with the intention of easing the process of data cleaning. (Usage to design your actual database for you is not advised.) Originally inspired by the 'AutoNormalize' library for 'Python' by 'Alteryx' (<https://github.com/alteryx/autonormalize>), with various changes and improvements. Automatic discovery of functional or approximate dependencies, normalisation based on those, and plotting of the resulting "database" via 'Graphviz', with options to exclude some attributes at discovery time, or remove discovered dependencies at normalisation time.
| Version: | 3.2.4 |
| Depends: | R (≥ 4.1.0) |
| Suggests: | rlang, spelling, DiagrammeR (≥ 1.0.7), testthat (≥ 3.3.0), R.utils (≥ 2.11.0), hedgehog (≥ 0.1), tibble (≥ 3.2.1), knitr, rmarkdown |
| Published: | 2025-11-17 |
| DOI: | 10.32614/CRAN.package.autodb |
| Author: | Mark Webster 
[aut, cre] |
| Maintainer: | Mark Webster <markwebster204 at yahoo.co.uk> |
| BugReports: | https://github.com/CharnelMouse/autodb/issues |
| License: | BSD_3_clause + file LICENSE |
| URL: | https://charnelmouse.github.io/autodb/, https://github.com/CharnelMouse/autodb |
| NeedsCompilation: | no |
| Language: | en-GB |
| Materials: | README, NEWS |
| CRAN checks: | autodb results |
Documentation:
| Reference manual: | autodb.html , autodb.pdf |
| Vignettes: |
Using autodb (source, R code) Limitations (source, R code) A larger example: the nudge dataset (source, R code) Handling missing values (source, R code) Planned improvements (source, R code) |
Downloads:
| Package source: | autodb_3.2.4.tar.gz |
| Windows binaries: | r-devel: autodb_3.2.4.zip, r-release: autodb_3.2.4.zip, r-oldrel: autodb_3.2.4.zip |
| macOS binaries: | r-release (arm64): autodb_3.2.4.tgz, r-oldrel (arm64): autodb_3.2.4.tgz, r-release (x86_64): autodb_3.2.4.tgz, r-oldrel (x86_64): autodb_3.2.4.tgz |
| Old sources: | autodb archive |
Linking:
Please use the canonical form https://CRAN.R-project.org/package=autodb to link to this page.