{% macro acc(kind) -%}{{ acc_words[kind] }}{%- endmacro %}

Chart page · {{ report.source.name }}

{{ title }}

  • {{ sections | length }} {{ 'dataset' if sections | length == 1 else 'datasets' }}
  • Second pass, exact counts

The charts load {{ library.name }} {{ library.version }} from a CDN; no data of the report leaves this page. The tables hold every figure and read without it.

{% for s in sections %}{% set r = s.result %}{% set hid = 'm' ~ loop.index %}

{{ '%02d' | format(loop.index) }} / {{ s.dataset }}

Combinations of missing values

Each record counts once, under the exact set of the columns it lacks a value in: the bars are exclusive.

Records with every value
{{ r.complete_records | count }}{{ share(r.complete_records, r.records) }} of {{ r.records | count }} records {{ acc('exact') }}
Lack at least one value
{{ s.lacking | count }}{{ share(s.lacking, r.records) }} of the records, in {{ r.columns | length | count }} columns {{ acc('exact') }}
Combinations
{% if not r.complete %}≥ {% endif %}{{ r.distinct | count }}{% if r.complete %}seen in the file {{ acc('exact') }}{% else %}at least, the table stopped growing {{ acc('at_least') }}{% endif %}
{% for line in s.lines %}

{% for part in line.parts %}{% if part.code %}{{ part.text }}{% else %}{{ part.text }}{% endif %}{% endfor %}{% if line.kind != 'exact' %} {{ acc(line.kind) }}{% endif %}

{% endfor %} {% if s.patterns %}

This chart needs JavaScript and a network connection to load {{ library.name }}. The tables below hold the same figures.

  • Each record is in one combination only, the exact set of the columns it lacks a value in; the records with every value are in none.
  • The plot draws the first {{ s.drawn | count }} combinations in the order chosen{% if s.patterns | length > s.drawn %}; the {{ (s.patterns | length - s.drawn) | count }} others ({{ (s.patterns[s.drawn:] | sum(attribute='count')) | count }} records) are in the table{% endif %}. The bars on the left count the records that lack each column.
  • A value is missing when its cell is empty, blank or a null marker of the configuration, as the scan counts it.
  • The totals were checked against the scan: the {{ r.records | count }} records are the complete ones and those of each combination.
  • It shows that values go missing together, not why.
{% endif %}

Combinations({{ s.patterns | length | count }}) {{ acc('exact') }}

{% for p in s.patterns %}{% endfor %}
Without a value in
Columns
Records
Share
{% for name in p.names %}{{ name }}{% if not loop.last %}, {% endif %}{% endfor %}{{ p.size | count }}{{ p.count | count }}{{ p.share }}
{% if r.other_patterns %}

{{ r.other_patterns | count }} rarer combinations ({{ r.other_records | count }} records) are counted but not listed: deep.missing.max_patterns_listed keeps the most frequent.

{% endif %} {% if not r.complete %}

{{ r.untracked | count }} records lack values in combinations found once deep.missing.max_patterns combinations were tracked; they are counted, not told apart. {{ acc('at_least') }}

{% endif %}

Columns that lack values({{ s.columns | length | count }}) {{ acc('exact') }}

{% for c in s.columns %}{% endfor %}
Column
Records without a value
Share
{% if c.href %}{{ c.display }}{% else %}{{ c.display }}{% endif %}{{ c.missing | count }}{{ c.share }}
{% endfor %}