❖ FixedNullCombinations

❖ SDV Enterprise Bundle. This feature is available as part of the CAG Bundle, an optional add-on to SDV Enterprise. For more information, please visit the CAG Bundle page.

Compatibility: 2 or more columns of any sdtype

Do you want to apply this constraint to PII data? As part of its algorithm, this constraint will learn and remember some parameters in the synthesizer. While you can always share your synthetic data, we recommend caution when sharing out your synthesizer itself, as it will contain some of these parameters.

The FixedNullCombinations constraint enforces that the null combinations between a set of columns are fixed. That is, no other permutations or shuffling of null values is allowed other than what's already observed in the data.

Parameters

(required) column_names: A list of two or more columns whose combinations are fixed when it comes to null values. The SDV will not further shuffle the null values between these column names.

Example

Define your constraint using the parameters and then add it to a synthesizer.

my_constraint = {
    'constraint_class': 'FixedNullCombinations',
    'table_name': 'locations', # for multi table synthesizers
    'constraint_parameters': {
        'column_names': ['city', 'country']
    }
}

my_synthesizer.add_constraints(constraints=[
    my_constraint
])

FAQs

Why can't I apply this constraint to a single column?

This constraint ensures that the synthetic data only contains null combinations that exist in the real data. If there is only one column, there are no combinations.

The SDV already guarantees that the synthetic data contains a similar proportion of null values as the real data for a single column.

What happens to the values that are non-null?

This constraint will only fix the combinations of null values. For example, it will allow a synthesizer to learn cases where some columns must be null together, or not at all.

It will continue to create new permutations of non-null values. If you would like to fix all combinations (null and non-null values), please apply the FixedCombinations constraint instead.