Expect column values to not be null.
expect_column_values_to_not_be_null
This expectation level is PRODUCTION
Contributors:
Tags:
Backend support:#
Description#
Class Name:
ExpectColumnValuesToNotBeNull
Short Description:
Expect column values to not be null.
Docstring:
Expect column values to not be null.
To be counted as an exception, values must be explicitly null or missing, such as a NULL in PostgreSQL or an
np.NaN in pandas. Empty strings don't count as null unless they have been coerced to a null type.
expect_column_values_to_not_be_null is a :func:column_map_expectation <great_expectations.execution_engine.execution_engine.MetaExecutionEngine .column_map_expectation>
.
Args:
- column (str): The column name.
Keyword Args:
- mostly (None or a float between 0 and 1): Return
"success": True
if at least mostly fraction of values match the expectation. For more detail, see :ref:mostly
.
Other Parameters:
- result_format (str or None): Which output mode to use:
BOOLEAN_ONLY
,BASIC
,COMPLETE
, orSUMMARY
.
For more detail, see :ref:result_format <result_format>
. - include_config (boolean): If True, then include the expectation config as part of the result object. For more detail, see :ref:
include_config
. - catch_exceptions (boolean or None): If True, then catch exceptions and include them as part of the result object. For more detail, see :ref:
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 :ref:
meta
.
Returns:
An ExpectationSuiteValidationResult
Exact fields vary depending on the values passed to :ref:result_format <result_format>
and
:ref:include_config
, :ref:catch_exceptions
, and :ref:meta
.
See Also:
-
:func:
expect_column_values_to_be_null <great_expectations.execution_engine.execution_engine.ExecutionEngine.expect_column_values_to_be_null>
Renderers#
We have yet to add renderers to this expectation.
Examples#
one_null | two_null | three_null | no_null | all_null |
---|---|---|---|---|
4 | a | |||
5 | b | |||
5 | c | |||
7 | 6 | 5 | d |
Tests
basic_positive_case_complete_result_format
Input:
column: no_null,
result_format: BASIC,
}
Output:
success: true,
result: [object Object],
}
No Data
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