autodb
Automatic Database Normalisation for Data Frames
Description
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.
Downloads
270
Last 30 days
15788th
697
Last 90 days
3.1K
Last year
Trend: +17.9% (30d vs prior 30d)
CRAN Check Status
Show all 14 flavors
| Flavor | Status |
|---|---|
| r-devel-linux-x86_64-debian-clang | OK |
| r-devel-linux-x86_64-debian-gcc | OK |
| r-devel-linux-x86_64-fedora-clang | OK |
| r-devel-linux-x86_64-fedora-gcc | OK |
| r-devel-macos-arm64 | OK |
| r-devel-windows-x86_64 | OK |
| r-oldrel-macos-arm64 | NOTE |
| r-oldrel-macos-x86_64 | NOTE |
| r-oldrel-windows-x86_64 | NOTE |
| r-patched-linux-x86_64 | OK |
| r-release-linux-x86_64 | OK |
| r-release-macos-arm64 | OK |
| r-release-macos-x86_64 | OK |
| r-release-windows-x86_64 | OK |
Check details (3 non-OK)
installed package size
installed size is 14.3Mb
sub-directories of 1Mb or more:
doc 13.7Mb
installed package size
installed size is 14.3Mb
sub-directories of 1Mb or more:
doc 13.7Mb
installed package size
installed size is 14.3Mb
sub-directories of 1Mb or more:
doc 13.7Mb
Check History
NOTE 11 OK · 3 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Apr 3, 2026
installed package size
installed size is 14.3Mb
sub-directories of 1Mb or more:
doc 13.7Mb
installed package size
installed size is 14.3Mb
sub-directories of 1Mb or more:
doc 13.7Mb
installed package size
installed size is 14.3Mb
sub-directories of 1Mb or more:
doc 13.7Mb
ERROR 10 OK · 3 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE Apr 1, 2026
tests
Running ‘spelling.R’ [0s/0s]
Running ‘testthat.R’ [463s/565s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
> library(testthat)
> library(autodb)
Attaching package: 'autodb'
The following object is masked from 'pack
...[truncated]...
q>
Counterexample:
[[1]]
# A tibble: 2 x 1
q
<fct>
1 <NA>
2 FALSE
[[2]]
[1] "q"
[[3]]
character(0)
[[4]]
[1] 0
[ FAIL 1 | WARN 0 | SKIP 1 | PASS 778 ]
Error:
! Test failures.
Execution halted
installed package size
installed size is 14.3Mb
sub-directories of 1Mb or more:
doc 13.7Mb
installed package size
installed size is 14.3Mb
sub-directories of 1Mb or more:
doc 13.7Mb
installed package size
installed size is 14.3Mb
sub-directories of 1Mb or more:
doc 13.7Mb
NOTE 11 OK · 3 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 18, 2026
installed package size
installed size is 14.3Mb
sub-directories of 1Mb or more:
doc 13.7Mb
installed package size
installed size is 14.3Mb
sub-directories of 1Mb or more:
doc 13.7Mb
installed package size
installed size is 14.3Mb
sub-directories of 1Mb or more:
doc 13.7Mb
ERROR 10 OK · 3 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE Mar 11, 2026
tests
Running 'spelling.R' [0s] Running 'testthat.R' [575s] Running the tests in 'tests/testthat.R' failed. Complete output: > library(testthat) > library(autodb) Attaching package: 'autodb' The following object is masked from 'package:stat ...[truncated]... J 1 -1.151791e-04 <NA> -4 2 -2.498415e-05 TRUE 0 3 -2.498415e-05 FALSE -1 [[2]] [1] "J" [[3]] character(0) [[4]] [1] 0 [ FAIL 1 | WARN 0 | SKIP 1 | PASS 778 ] Error: ! Test failures. Execution halted
installed package size
installed size is 14.3Mb
sub-directories of 1Mb or more:
doc 13.7Mb
installed package size
installed size is 14.3Mb
sub-directories of 1Mb or more:
doc 13.7Mb
installed package size
installed size is 14.3Mb
sub-directories of 1Mb or more:
doc 13.7Mb
NOTE 11 OK · 3 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 10, 2026
installed package size
installed size is 14.3Mb
sub-directories of 1Mb or more:
doc 13.7Mb
installed package size
installed size is 14.3Mb
sub-directories of 1Mb or more:
doc 13.7Mb
installed package size
installed size is 14.3Mb
sub-directories of 1Mb or more:
doc 13.7Mb