{{ '%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 part in line.parts %}{% if part.code %}{{ part.text }}{% else %}{{ part.text }}{% endif %}{% endfor %}{% if line.kind != 'exact' %} {{ acc(line.kind) }}{% endif %}
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.
Combinations({{ s.patterns | length | count }}) {{ acc('exact') }}
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 }} |
{{ 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.
{{ 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') }}
Columns that lack values({{ s.columns | length | count }}) {{ acc('exact') }}
Column | Records without a value | Share |
|---|---|---|
{% if c.href %}{{ c.display }}{% else %}{{ c.display }}{% endif %} | {{ c.missing | count }} | {{ c.share }} |