Expect the numeric difference between current and previous row is within expected range.
expect_column_values_to_change_between
This expectation level is EXPERIMENTAL
Contributors:
Tags:
experimental
Metrics:
column_values.nonnull.unexpected_count
column_values.change_between.unexpected_count
table.row_count
column_values.change_between.unexpected_values
Description
Expect the numeric difference between current and previous row is within expected range.
E.g:
input = [1,2,5]
expected difference range = between 1 and 2
result = false because the difference between 2 and 5 is not between 1 and 2
Args:
- column (str): The column name
Keyword Args:
- from_value (float): low range value
- to_value (float): high range value
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