{% macro th(name, ascending, descending, is_numeric) %} {% if name %} {{ name }} {% endif %}
{% endmacro %} {% macro th1(name, low, high, is_numeric) %} {{ th(name, "from columns with " + low + " to columns with " + high, "from columns with " + high + " to columns with " + low, is_numeric) }} {% endmacro %}
{{ th("Column", "from first column to last column", "from last column to first column", True) }} {{ th("Column name", "by column name from A to Z", "by column name from Z to A", False) }} {{ th("dtype", "by dtype from A to Z", "by dtype from Z to A", False) }} {{ th1("Null values", "the fewest null values", "the most null values", True) }} {{ th1("Unique values", "the fewest unique values", "the most unique values", True) }} {{ th1("Mean", "the lowest mean", "the highest mean", True) }} {{ th1("Std", "the lowest standard deviation", "the highest standard deviation", True) }} {{ th1("Min", "the lowest minimum value", "the highest minimum value", True) }} {{ th1("Median", "the lowest median", "the highest median", True) }} {{ th1("Max", "the lowest maximum value", "the highest maximum value", True) }} {% for column in summary.columns %} {% if column.n_unique %} {% else %} {% endif %} {% if "mean" in column %} {% else %} {% endif %} {% if column.quantiles %} {% elif "min" in column %} {% else %} {% endif %} {% endfor %}
{{ loop.index0 }} {{ column.name }} {{ column.dtype }} {{ column.null_count }} ({{ column.null_proportion | format_percent }}) {{ column.n_unique }} ({{ column.unique_proportion | format_percent }}) {{ column["mean"] | format_number }} {{ column["standard_deviation"] | format_number }} {{ column.quantiles[0.0] | format_number }} {{ column.quantiles[0.5] | format_number }} {{ column.quantiles[1.0] | format_number }} {{ column.min | format_number }} {{ column.max | format_number }}
{% include "no-filter-matches.html" %}