Expect the values in column A to be greater than column B.
expect_column_pair_values_a_to_be_greater_than_b
This expectation level is EXPERIMENTAL
Contributors:
Tags:
core expectation
column pair map expectation
Metrics:
column_pair_values.a_greater_than_b.unexpected_count
table.row_count
column_pair_values.a_greater_than_b.filtered_row_count
column_pair_values.a_greater_than_b.unexpected_values
Description
Expect the values in column A to be greater than column B.
expect_column_pair_values_a_to_be_greater_than_b is a Column Pair Map Expectation.
Args:
- column_A (str): The first column name
- column_B (str): The second column name
- or_equal (boolean or None): If True, then values can be equal, not strictly greater
Keyword Args:
- ignore_row_if (str): "both_values_are_missing", "either_value_is_missing", "neither
Other Parameters:
- result_format (str or None): Which output mode to use: BOOLEAN_ONLY, BASIC, COMPLETE, or SUMMARY. For more detail, see result_format.
- include_config (boolean): If True, then include the expectation config as part of the result object.
- catch_exceptions (boolean or None): If True, then catch exceptions and include them as part of the result object. For more detail, see catch_exceptions.
- meta (dict or None): A JSON-serializable dictionary (nesting allowed) that will be included in the output without modification. For more detail, see meta.
Returns:
Exact fields vary depending on the values passed to result_format, include_config, catch_exceptions, and meta.
Want to make your own Expectation or an improvement to this one?
We've put together some great how to guides (including videos) on how to create your own expectations in a flash!
You can see those resources here: Contributor Resources