df_equiv

A convenience function, mostly used to testing that <code>rejoin</code>
works as intended. It checks that data frames have the same dimensions and
column names, with duplicates allowed, then checks they contain the same
data. For the latter step, column names are made unique first, so columns
with duplicate names must be presented in the same order in both 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.

Mark Webster

autodb

Automatic Database Normalisation for Data Frames

df_equiv function

<dl><dt>df1, df2</dt>
<dd>Data frames.</dd>
<dt>digits</dt>
<dd>a positive integer, indicating how many significant digits are
to be used for numeric and complex variables. A value of NA results in no
rounding. By default, this uses <code>getOption("digits")</code>, similarly to
<code><a href="/link/format?package=autodb&version=2.3.1" data-mini-rdoc="autodb::format">format</a></code>. See the note in <code><a href="/link/print.default?package=autodb&version=2.3.1" data-mini-rdoc="autodb::print.default">print.default</a></code> about
digits &gt;= 16.</dd></dl>

Arguments

Test data frames for equivalence under row reordering — df_equiv

<dl>

<dt>df1, df2</dt>
<dd>Data frames.</dd>


<dt>digits</dt>
<dd>a positive integer, indicating how many significant digits are
to be used for numeric and complex variables. A value of NA results in no
rounding. By default, this uses <code>getOption("digits")</code>, similarly to
<code><a href='https://rdrr.io/r/base/format.html'>format</a></code>. See the note in <code><a href='https://rdrr.io/r/base/print.default.html'>print.default</a></code> about
digits &gt;= 16.</dd>

</dl>

df_equiv: Test data frames for equivalence under row reordering

Description

Usage

Value

Arguments