gv.database

Produces text input for Graphviz to make an HTML diagram of a given database.

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

gv.database function

<dl><dt>x</dt>
<dd>a database, as returned by <code>autoref</code> or
<code>autodb</code>.</dd>
<dt>name</dt>
<dd>a scalar character, giving the name of the database, if any. This
name is used for the resulting graph, to allow for easier combining of
graphs into a single diagram if required.</dd>
<dt>nest_level</dt>
<dd>an integer, giving the amount of nesting allowed when
giving the class of a list column. Since lists can hold anything in R, this
allows showing common element classes and lengths.</dd>
<dt>...</dt>
<dd>further arguments passed to or from other methods.</dd></dl>

Arguments

Generate Graphviz input text to plot databases — gv.database

<dl>

<dt>x</dt>
<dd>a database, as returned by <code>autoref</code> or
<code>autodb</code>.</dd>


<dt>name</dt>
<dd>a scalar character, giving the name of the database, if any. This
name is used for the resulting graph, to allow for easier combining of
graphs into a single diagram if required.</dd>


<dt>nest_level</dt>
<dd>an integer, giving the amount of nesting allowed when
giving the class of a list column. Since lists can hold anything in R, this
allows showing common element classes and lengths.</dd>


<dt>...</dt>
<dd>further arguments passed to or from other methods.</dd>

</dl>

gv.database: Generate Graphviz input text to plot databases

Description

Usage

Value

Arguments

Details

See Also