great_expectations.expectations.core.expect_column_values_to_not_be_in_set

Module Contents

Classes

ExpectColumnValuesToNotBeInSet(configuration: Optional[ExpectationConfiguration] = None)

Expect column entries to not be in the set.

class great_expectations.expectations.core.expect_column_values_to_not_be_in_set.ExpectColumnValuesToNotBeInSet(configuration: Optional[ExpectationConfiguration] = None)

Bases: great_expectations.expectations.expectation.ColumnMapExpectation

Expect column entries to not be in the set.

For example:

# my_df.my_col = [1,2,2,3,3,3]
>>> my_df.expect_column_values_to_not_be_in_set(
        "my_col",
        [1,2]
    )
{
    "success": false
    "result": {
        "unexpected_count": 3
        "unexpected_percent": 50.0,
        "unexpected_percent_nonmissing": 50.0,
        "partial_unexpected_list": [
            1, 2, 2
        ],
    },
}

expect_column_values_to_not_be_in_set is a [Column Map Expectation](https://docs.greatexpectations.io/docs/guides/expectations/creating_custom_expectations/how_to_create_custom_column_map_expectations).

Parameters
  • column (str) – The column name.

  • value_set (set-like) – A set of objects used for comparison.

Keyword Arguments

mostly (None or a float between 0 and 1) – Successful if at least mostly fraction of values match the expectation. For more detail, see [mostly](https://docs.greatexpectations.io/docs/reference/expectations/standard_arguments/#mostly).

Other Parameters
Returns

//docs.greatexpectations.io/docs/terms/validation_result)

Exact fields vary depending on the values passed to result_format, include_config, catch_exceptions, and meta.

Return type

An [ExpectationSuiteValidationResult](https

library_metadata
map_metric = column_values.not_in_set
success_keys = ['value_set', 'mostly', 'parse_strings_as_datetimes']
default_kwarg_values
args_keys = ['column', 'value_set']
validate_configuration(self, configuration: Optional[ExpectationConfiguration] = None)

Validates that a value_set has been provided.

classmethod _prescriptive_template(cls, renderer_configuration: RendererConfiguration)
classmethod _prescriptive_renderer(cls, configuration: Optional[ExpectationConfiguration] = None, result: Optional[ExpectationValidationResult] = None, runtime_configuration: Optional[dict] = None)
_pandas_column_values_not_in_set(self, series: pd.Series, metrics: Dict, metric_domain_kwargs: dict, metric_value_kwargs: dict, runtime_configuration: Optional[dict] = None, filter_column_isnull: bool = True)