Variables

Profiles
{% if payload.mode == "single" %}
{% for column in payload.column_profiles %}

{{ column.column_name }}

{{ column.data_type }}

{{ column.data_type }}
{% set is_integer = column.numeric_profile.is_integer if column.numeric_profile else false %}
Values{{ column.non_null_count }}
Missing{{ column.null_count }} ({{ column.null_rate }})
Distinct{{ column.unique_count }}
Zeroes{{ column.zero_count }}
{% if column.list_profile %}
List length
Min{{ column.list_profile.length_stats.minimum }}
Max{{ column.list_profile.length_stats.maximum }}
Mean{{ column.list_profile.length_stats.mean | format_number(false) }}
Median{{ column.list_profile.length_stats.median | format_number(false) }}
{% if column.list_profile.value_samples %}
Sample values
    {% for sample in column.list_profile.value_samples %}
  • {{ sample }}
    • {% endfor %}
{% endif %} {% endif %} {% if column.value_samples and not column.list_profile %}
Sample values
    {% for sample in column.value_samples %}
  • {{ sample }}
    • {% endfor %}
{% endif %} {% if column.numeric_profile %}
Stats
Min{{ column.numeric_profile.stats.minimum | format_number(is_integer) }}
Max{{ column.numeric_profile.stats.maximum | format_number(is_integer) }}
Mean{{ column.numeric_profile.stats.mean | format_number(is_integer) }}
Median{{ column.numeric_profile.stats.median | format_number(is_integer) }}
Std{{ column.numeric_profile.stats.std | format_number(is_integer) }}
Variance{{ column.numeric_profile.stats.variance | format_number(is_integer) }}
IQR{{ column.numeric_profile.stats.iqr | format_number(is_integer) }}
Outlier rate{{ column.numeric_profile.outlier_rate | format_number(is_integer) }}
Quantiles
{% for quantile in column.numeric_profile.stats.quantiles %} {% endfor %}
{{ quantile.quantile }}{{ quantile.value | format_number(is_integer) }}
{% endif %}
{% if column.numeric_profile %} {% if column.numeric_profile.histograms %} {% set default_histogram = column.numeric_profile.histograms | first %} {% set default_bin = default_histogram.bin_count if default_histogram else None %}
Histogram
{% if column.numeric_profile.histograms | length > 1 %}
{% for histogram in column.numeric_profile.histograms %} {% endfor %}
{% endif %}
{% endif %} {% endif %} {% if column.categorical_profile %} {% if column.categorical_profile.histograms %} {% set default_histogram = column.categorical_profile.histograms | first %} {% set default_bin = default_histogram.bin_count if default_histogram else None %}
Histogram
{% endif %} {% endif %} {% if column.list_profile %} {% if column.list_profile.length_histograms %} {% set default_histogram = column.list_profile.length_histograms | first %} {% set default_bin = default_histogram.bin_count if default_histogram else None %}
Length histogram
{% if column.list_profile.length_histograms | length > 1 %}
{% for histogram in column.list_profile.length_histograms %} {% endfor %}
{% endif %}
{% endif %} {% endif %} {% if column.text_profile %} {% if column.text_profile.length_histograms %} {% set default_histogram = column.text_profile.length_histograms | first %} {% set default_bin = default_histogram.bin_count if default_histogram else None %}
Length histogram
{% if column.text_profile.length_histograms | length > 1 %}
{% for histogram in column.text_profile.length_histograms %} {% endfor %}
{% endif %}
{% endif %} {% endif %} {% if column.datetime_profile %} {% if column.datetime_profile.histograms %} {% set default_histogram = column.datetime_profile.histograms | first %} {% set default_bin = default_histogram.bin_count if default_histogram else None %}
Histogram
{% endif %} {% endif %} {% if column.numeric_profile %}
Most frequent values
{% for value in column.numeric_profile.top_values %} {% endfor %}
{{ value.value | format_number(is_integer) }}{{ value.count }}
Smallest values
{% for value in column.numeric_profile.min_values %} {% endfor %}
{{ value.value | format_number(is_integer) }}{{ value.count }}
Largest values
{% for value in column.numeric_profile.max_values %} {% endfor %}
{{ value.value | format_number(is_integer) }}{{ value.count }}
{% endif %} {% if column.categorical_profile %}
Top categories
{% for category in column.categorical_profile.top_categories %} {% endfor %}
{{ category.category }}{{ category.count }}
{% if column.categorical_profile.is_high_cardinality %}

High cardinality detected.

{% endif %}
{% endif %} {% if column.datetime_profile %}
Datetime range
Min{{ column.datetime_profile.min_datetime }}
Max{{ column.datetime_profile.max_datetime }}
Most frequent values
{% for value in column.datetime_profile.top_values %} {% endfor %}
{{ value.value }}{{ value.count }}
{% endif %} {% if column.text_profile %}
Most frequent values
{% for token in column.text_profile.top_tokens %} {% endfor %}
{{ token.token }}
Count: {{ token.count }}
Text length stats
Mean{{ column.text_profile.length_stats.mean | format_number(true) }}
Median{{ column.text_profile.length_stats.median | format_number(true) }}
Min{{ column.text_profile.length_stats.minimum | format_number(true) }}
Max{{ column.text_profile.length_stats.maximum | format_number(true) }}
{% endif %}
{% endfor %}
{% else %}
{% if payload.compare_column_profiles %}
{% for column in payload.compare_column_profiles %}

{{ column.column_name }}

Compare column

{% if column.left_profile.data_type == column.right_profile.data_type %}
{{ column.left_profile.data_type }}
{% else %}
{{ payload.comparison_summary.left_dataset.dataset_id }}: {{ column.left_profile.data_type }}
{{ payload.comparison_summary.right_dataset.dataset_id }}: {{ column.right_profile.data_type }}
{% endif %}
{{ payload.comparison_summary.left_dataset.dataset_id }}
Values{{ column.left_profile.non_null_count }}
Missing{{ column.left_profile.null_count }} ({{ column.left_profile.null_rate }})
Distinct{{ column.left_profile.unique_count }}
Zeroes{{ column.left_profile.zero_count }}
{% if column.left_profile.list_profile %}
List length
Min{{ column.left_profile.list_profile.length_stats.minimum }}
Max{{ column.left_profile.list_profile.length_stats.maximum }}
Mean{{ column.left_profile.list_profile.length_stats.mean | format_number(false) }}
Median{{ column.left_profile.list_profile.length_stats.median | format_number(false) }}
{% if column.left_profile.list_profile.value_samples %}
Sample values
    {% for sample in column.left_profile.list_profile.value_samples %}
  • {{ sample }}
    • {% endfor %}
{% endif %} {% endif %} {% if column.left_profile.value_samples and not column.left_profile.list_profile %}
Sample values
    {% for sample in column.left_profile.value_samples %}
  • {{ sample }}
    • {% endfor %}
{% endif %} {% if column.left_profile.list_profile and column.left_profile.list_profile.length_histograms %} {% set default_histogram = column.left_profile.list_profile.length_histograms | first %} {% set default_bin = default_histogram.bin_count if default_histogram else None %}
Length histogram
{% if column.left_profile.list_profile.length_histograms | length > 1 %}
{% for histogram in column.left_profile.list_profile.length_histograms %} {% endfor %}
{% endif %}
{% endif %} {% if column.left_profile.numeric_profile %} {% set left_integer = column.left_profile.numeric_profile.is_integer %}
Stats
Min{{ column.left_profile.numeric_profile.stats.minimum | format_number(left_integer) }}
Max{{ column.left_profile.numeric_profile.stats.maximum | format_number(left_integer) }}
Mean{{ column.left_profile.numeric_profile.stats.mean | format_number(left_integer) }}
Median{{ column.left_profile.numeric_profile.stats.median | format_number(left_integer) }}
Std{{ column.left_profile.numeric_profile.stats.std | format_number(left_integer) }}
Variance{{ column.left_profile.numeric_profile.stats.variance | format_number(left_integer) }}
IQR{{ column.left_profile.numeric_profile.stats.iqr | format_number(left_integer) }}
Outlier rate{{ column.left_profile.numeric_profile.outlier_rate | format_number(left_integer) }}
Quantiles
{% for quantile in column.left_profile.numeric_profile.stats.quantiles %} {% endfor %}
{{ quantile.quantile }}{{ quantile.value | format_number(left_integer) }}
{% endif %} {% if column.left_profile.categorical_profile %}
Top categories
{% for category in column.left_profile.categorical_profile.top_categories %} {% endfor %}
{{ category.category }}{{ category.count }}
{% if column.left_profile.categorical_profile.is_high_cardinality %}

High cardinality detected.

{% endif %}
{% endif %} {% if column.left_profile.datetime_profile %}
Datetime range
Min{{ column.left_profile.datetime_profile.min_datetime }}
Max{{ column.left_profile.datetime_profile.max_datetime }}
Most frequent values
{% for value in column.left_profile.datetime_profile.top_values %} {% endfor %}
{{ value.value }}{{ value.count }}
{% endif %} {% if column.left_profile.text_profile %}
Most frequent values
{% for token in column.left_profile.text_profile.top_tokens %} {% endfor %}
{{ token.token }}
Count: {{ token.count }}
Text length stats
Mean{{ column.left_profile.text_profile.length_stats.mean | format_number(true) }}
Median{{ column.left_profile.text_profile.length_stats.median | format_number(true) }}
Min{{ column.left_profile.text_profile.length_stats.minimum | format_number(true) }}
Max{{ column.left_profile.text_profile.length_stats.maximum | format_number(true) }}
{% endif %} {% if column.left_profile.numeric_profile %}
Most frequent values
{% for value in column.left_profile.numeric_profile.top_values %} {% endfor %}
{{ value.value | format_number(left_integer) }}{{ value.count }}
Smallest values
{% for value in column.left_profile.numeric_profile.min_values %} {% endfor %}
{{ value.value | format_number(left_integer) }}{{ value.count }}
Largest values
{% for value in column.left_profile.numeric_profile.max_values %} {% endfor %}
{{ value.value | format_number(left_integer) }}{{ value.count }}
{% endif %}
{{ payload.comparison_summary.right_dataset.dataset_id }}
Values{{ column.right_profile.non_null_count }}
Missing{{ column.right_profile.null_count }} ({{ column.right_profile.null_rate }})
Distinct{{ column.right_profile.unique_count }}
Zeroes{{ column.right_profile.zero_count }}
{% if column.right_profile.list_profile %}
List length
Min{{ column.right_profile.list_profile.length_stats.minimum }}
Max{{ column.right_profile.list_profile.length_stats.maximum }}
Mean{{ column.right_profile.list_profile.length_stats.mean | format_number(false) }}
Median{{ column.right_profile.list_profile.length_stats.median | format_number(false) }}
{% if column.right_profile.list_profile.value_samples %}
Sample values
    {% for sample in column.right_profile.list_profile.value_samples %}
  • {{ sample }}
    • {% endfor %}
{% endif %} {% endif %} {% if column.right_profile.value_samples and not column.right_profile.list_profile %}
Sample values
    {% for sample in column.right_profile.value_samples %}
  • {{ sample }}
    • {% endfor %}
{% endif %} {% if column.right_profile.list_profile and column.right_profile.list_profile.length_histograms %} {% set default_histogram = column.right_profile.list_profile.length_histograms | first %} {% set default_bin = default_histogram.bin_count if default_histogram else None %}
Length histogram
{% if column.right_profile.list_profile.length_histograms | length > 1 %}
{% for histogram in column.right_profile.list_profile.length_histograms %} {% endfor %}
{% endif %}
{% endif %} {% if column.right_profile.numeric_profile %} {% set right_integer = column.right_profile.numeric_profile.is_integer %}
Stats
Min{{ column.right_profile.numeric_profile.stats.minimum | format_number(right_integer) }}
Max{{ column.right_profile.numeric_profile.stats.maximum | format_number(right_integer) }}
Mean{{ column.right_profile.numeric_profile.stats.mean | format_number(right_integer) }}
Median{{ column.right_profile.numeric_profile.stats.median | format_number(right_integer) }}
Std{{ column.right_profile.numeric_profile.stats.std | format_number(right_integer) }}
Variance{{ column.right_profile.numeric_profile.stats.variance | format_number(right_integer) }}
IQR{{ column.right_profile.numeric_profile.stats.iqr | format_number(right_integer) }}
Outlier rate{{ column.right_profile.numeric_profile.outlier_rate | format_number(right_integer) }}
Quantiles
{% for quantile in column.right_profile.numeric_profile.stats.quantiles %} {% endfor %}
{{ quantile.quantile }}{{ quantile.value | format_number(right_integer) }}
{% endif %} {% if column.right_profile.categorical_profile %}
Top categories
{% for category in column.right_profile.categorical_profile.top_categories %} {% endfor %}
{{ category.category }}{{ category.count }}
{% if column.right_profile.categorical_profile.is_high_cardinality %}

High cardinality detected.

{% endif %}
{% endif %} {% if column.right_profile.datetime_profile %}
Datetime range
Min{{ column.right_profile.datetime_profile.min_datetime }}
Max{{ column.right_profile.datetime_profile.max_datetime }}
Most frequent values
{% for value in column.right_profile.datetime_profile.top_values %} {% endfor %}
{{ value.value }}{{ value.count }}
{% endif %} {% if column.right_profile.text_profile %}
Most frequent values
{% for token in column.right_profile.text_profile.top_tokens %} {% endfor %}
{{ token.token }}
Count: {{ token.count }}
Text length stats
Mean{{ column.right_profile.text_profile.length_stats.mean | format_number(true) }}
Median{{ column.right_profile.text_profile.length_stats.median | format_number(true) }}
Min{{ column.right_profile.text_profile.length_stats.minimum | format_number(true) }}
Max{{ column.right_profile.text_profile.length_stats.maximum | format_number(true) }}
{% endif %} {% if column.right_profile.numeric_profile %}
Most frequent values
{% for value in column.right_profile.numeric_profile.top_values %} {% endfor %}
{{ value.value | format_number(right_integer) }}{{ value.count }}
Smallest values
{% for value in column.right_profile.numeric_profile.min_values %} {% endfor %}
{{ value.value | format_number(right_integer) }}{{ value.count }}
Largest values
{% for value in column.right_profile.numeric_profile.max_values %} {% endfor %}
{{ value.value | format_number(right_integer) }}{{ value.count }}
{% endif %}
{% if column.histograms %} {% set default_histogram = column.histograms | first %} {% set default_bin = default_histogram.bin_count if default_histogram else None %}
Histogram
{% if column.histograms | length > 1 %}
{% for histogram in column.histograms %} {% endfor %}
{% endif %}
{% endif %}
{% endfor %}
{% else %}
No common columns to compare.
{% endif %} {% if payload.comparison_summary.column_profiles_left_only %}

{{ payload.comparison_summary.left_dataset.dataset_id }}-only columns

Single side
{% for column in payload.comparison_summary.column_profiles_left_only %}

{{ column.column_name }}

{{ payload.comparison_summary.left_dataset.dataset_id }} only

{{ column.data_type }}
{% set is_integer = column.numeric_profile.is_integer if column.numeric_profile else false %}
Values{{ column.non_null_count }}
Missing{{ column.null_count }} ({{ column.null_rate }})
Distinct{{ column.unique_count }}
Zeroes{{ column.zero_count }}
{% if column.list_profile %}
List length
Min{{ column.list_profile.length_stats.minimum }}
Max{{ column.list_profile.length_stats.maximum }}
Mean{{ column.list_profile.length_stats.mean | format_number(false) }}
Median{{ column.list_profile.length_stats.median | format_number(false) }}
{% if column.list_profile.value_samples %}
Sample values
    {% for sample in column.list_profile.value_samples %}
  • {{ sample }}
    • {% endfor %}
{% endif %} {% endif %} {% if column.value_samples and not column.list_profile %}
Sample values
    {% for sample in column.value_samples %}
  • {{ sample }}
    • {% endfor %}
{% endif %} {% if column.numeric_profile %}
Stats
Min{{ column.numeric_profile.stats.minimum | format_number(is_integer) }}
Max{{ column.numeric_profile.stats.maximum | format_number(is_integer) }}
Mean{{ column.numeric_profile.stats.mean | format_number(is_integer) }}
Median{{ column.numeric_profile.stats.median | format_number(is_integer) }}
Std{{ column.numeric_profile.stats.std | format_number(is_integer) }}
Variance{{ column.numeric_profile.stats.variance | format_number(is_integer) }}
IQR{{ column.numeric_profile.stats.iqr | format_number(is_integer) }}
Outlier rate{{ column.numeric_profile.outlier_rate | format_number(is_integer) }}
Quantiles
{% for quantile in column.numeric_profile.stats.quantiles %} {% endfor %}
{{ quantile.quantile }}{{ quantile.value | format_number(is_integer) }}
{% endif %}
{% if column.numeric_profile %} {% if column.numeric_profile.histograms %} {% set default_histogram = column.numeric_profile.histograms | first %} {% set default_bin = default_histogram.bin_count if default_histogram else None %}
Histogram
{% if column.numeric_profile.histograms | length > 1 %}
{% for histogram in column.numeric_profile.histograms %} {% endfor %}
{% endif %}
{% endif %} {% endif %} {% if column.categorical_profile %} {% if column.categorical_profile.histograms %} {% set default_histogram = column.categorical_profile.histograms | first %} {% set default_bin = default_histogram.bin_count if default_histogram else None %}
Histogram
{% endif %} {% endif %} {% if column.text_profile %} {% if column.text_profile.length_histograms %} {% set default_histogram = column.text_profile.length_histograms | first %} {% set default_bin = default_histogram.bin_count if default_histogram else None %}
Length histogram
{% if column.text_profile.length_histograms | length > 1 %}
{% for histogram in column.text_profile.length_histograms %} {% endfor %}
{% endif %}
{% endif %} {% endif %} {% if column.datetime_profile %} {% if column.datetime_profile.histograms %} {% set default_histogram = column.datetime_profile.histograms | first %} {% set default_bin = default_histogram.bin_count if default_histogram else None %}
Histogram
{% endif %} {% endif %} {% if column.numeric_profile %}
Most frequent values
{% for value in column.numeric_profile.top_values %} {% endfor %}
{{ value.value | format_number(is_integer) }}{{ value.count }}
Smallest values
{% for value in column.numeric_profile.min_values %} {% endfor %}
{{ value.value | format_number(is_integer) }}{{ value.count }}
Largest values
{% for value in column.numeric_profile.max_values %} {% endfor %}
{{ value.value | format_number(is_integer) }}{{ value.count }}
{% endif %} {% if column.categorical_profile %}
Top categories
{% for category in column.categorical_profile.top_categories %} {% endfor %}
{{ category.category }}{{ category.count }}
{% if column.categorical_profile.is_high_cardinality %}

High cardinality detected.

{% endif %}
{% endif %} {% if column.datetime_profile %}
Datetime range
Min{{ column.datetime_profile.min_datetime }}
Max{{ column.datetime_profile.max_datetime }}
Most frequent values
{% for value in column.datetime_profile.top_values %} {% endfor %}
{{ value.value }}{{ value.count }}
{% endif %} {% if column.text_profile %}
Most frequent values
{% for token in column.text_profile.top_tokens %} {% endfor %}
{{ token.token }}
Count: {{ token.count }}
Text length stats
Mean{{ column.text_profile.length_stats.mean | format_number(true) }}
Median{{ column.text_profile.length_stats.median | format_number(true) }}
Min{{ column.text_profile.length_stats.minimum | format_number(true) }}
Max{{ column.text_profile.length_stats.maximum | format_number(true) }}
{% endif %}
{% endfor %}
{% endif %} {% if payload.comparison_summary.column_profiles_right_only %}

{{ payload.comparison_summary.right_dataset.dataset_id }}-only columns

Single side
{% for column in payload.comparison_summary.column_profiles_right_only %}

{{ column.column_name }}

{{ payload.comparison_summary.right_dataset.dataset_id }} only

{{ column.data_type }}
{% set is_integer = column.numeric_profile.is_integer if column.numeric_profile else false %}
Values{{ column.non_null_count }}
Missing{{ column.null_count }} ({{ column.null_rate }})
Distinct{{ column.unique_count }}
Zeroes{{ column.zero_count }}
{% if column.list_profile %}
List length
Min{{ column.list_profile.length_stats.minimum }}
Max{{ column.list_profile.length_stats.maximum }}
Mean{{ column.list_profile.length_stats.mean | format_number(false) }}
Median{{ column.list_profile.length_stats.median | format_number(false) }}
{% endif %} {% if column.numeric_profile %}
Stats
Min{{ column.numeric_profile.stats.minimum | format_number(is_integer) }}
Max{{ column.numeric_profile.stats.maximum | format_number(is_integer) }}
Mean{{ column.numeric_profile.stats.mean | format_number(is_integer) }}
Median{{ column.numeric_profile.stats.median | format_number(is_integer) }}
Std{{ column.numeric_profile.stats.std | format_number(is_integer) }}
Variance{{ column.numeric_profile.stats.variance | format_number(is_integer) }}
IQR{{ column.numeric_profile.stats.iqr | format_number(is_integer) }}
Outlier rate{{ column.numeric_profile.outlier_rate | format_number(is_integer) }}
Quantiles
{% for quantile in column.numeric_profile.stats.quantiles %} {% endfor %}
{{ quantile.quantile }}{{ quantile.value | format_number(is_integer) }}
{% endif %}
{% if column.numeric_profile %} {% if column.numeric_profile.histograms %} {% set default_histogram = column.numeric_profile.histograms | first %} {% set default_bin = default_histogram.bin_count if default_histogram else None %}
Histogram
{% if column.numeric_profile.histograms | length > 1 %}
{% for histogram in column.numeric_profile.histograms %} {% endfor %}
{% endif %}
{% endif %} {% endif %} {% if column.categorical_profile %} {% if column.categorical_profile.histograms %} {% set default_histogram = column.categorical_profile.histograms | first %} {% set default_bin = default_histogram.bin_count if default_histogram else None %}
Histogram
{% endif %} {% endif %} {% if column.text_profile %} {% if column.text_profile.length_histograms %} {% set default_histogram = column.text_profile.length_histograms | first %} {% set default_bin = default_histogram.bin_count if default_histogram else None %}
Length histogram
{% if column.text_profile.length_histograms | length > 1 %}
{% for histogram in column.text_profile.length_histograms %} {% endfor %}
{% endif %}
{% endif %} {% endif %} {% if column.datetime_profile %} {% if column.datetime_profile.histograms %} {% set default_histogram = column.datetime_profile.histograms | first %} {% set default_bin = default_histogram.bin_count if default_histogram else None %}
Histogram
{% endif %} {% endif %} {% if column.numeric_profile %}
Most frequent values
{% for value in column.numeric_profile.top_values %} {% endfor %}
{{ value.value | format_number(is_integer) }}{{ value.count }}
Smallest values
{% for value in column.numeric_profile.min_values %} {% endfor %}
{{ value.value | format_number(is_integer) }}{{ value.count }}
Largest values
{% for value in column.numeric_profile.max_values %} {% endfor %}
{{ value.value | format_number(is_integer) }}{{ value.count }}
{% endif %} {% if column.categorical_profile %}
Top categories
{% for category in column.categorical_profile.top_categories %} {% endfor %}
{{ category.category }}{{ category.count }}
{% if column.categorical_profile.is_high_cardinality %}

High cardinality detected.

{% endif %}
{% endif %} {% if column.datetime_profile %}
Datetime range
Min{{ column.datetime_profile.min_datetime }}
Max{{ column.datetime_profile.max_datetime }}
Most frequent values
{% for value in column.datetime_profile.top_values %} {% endfor %}
{{ value.value }}{{ value.count }}
{% endif %} {% if column.text_profile %}
Most frequent values
{% for token in column.text_profile.top_tokens %} {% endfor %}
{{ token.token }}
Count: {{ token.count }}
Text length stats
Mean{{ column.text_profile.length_stats.mean | format_number(true) }}
Median{{ column.text_profile.length_stats.median | format_number(true) }}
Min{{ column.text_profile.length_stats.minimum | format_number(true) }}
Max{{ column.text_profile.length_stats.maximum | format_number(true) }}
{% endif %}
{% endfor %}
{% endif %}
{% endif %}