Data documentation compiled by Great Expectations

Expectation Suite Overview

Info

Full Data Asset Identifier	data__dir/default/wikisurvey_17066_votes_2020-01-13T15_40_28Z
Data Asset Type	Dataset
Expectation Suite Name	BasicDatasetProfiler
Great Expectations Version	0.8.6+3.g6441519b

Table-Level Expectations

Must have more than 0 rows.
This table should have a list of columns in a specific order, but that order is not specified.

Notes

This Expectation suite currently contains 175 total Expectations across 22 columns.

To add additional notes, edit the meta.notes.content field in the appropriate Expectation json file.

Appearance ID

value types must belong to this set: BIGINT BYTEINT DECIMAL INT INTEGER IntegerType LongType SMALLINT TINYINT int.
may have any number of unique values.
may have any fraction of unique values.
values must not be null, at least 50 % of the time.
values must belong to this set: [ ].
values must be unique.

Created at

value types must belong to this set: CHAR StringType TEXT VARCHAR str string.
may have any number of unique values.
may have any fraction of unique values.
values must not be null, at least 50 % of the time.
values must belong to this set: [ ].
values must not match this regular expression: ^\s+|\s+$.

Hashed IP Address

value types must belong to this set: CHAR StringType TEXT VARCHAR str string.
may have any number of unique values.
may have any fraction of unique values.
values must not be null, at least 50 % of the time.
values must belong to this set: [ ].
values must not match this regular expression: ^\s+|\s+$.

Info

value types must belong to this set: DOUBLE_PRECISION DoubleType FLOAT FLOAT4 FLOAT8 FloatType NUMERIC float.
may have any number of unique values.
may have any fraction of unique values.
values must not be null, at least 50 % of the time.
values must belong to this set: [ ].

Left Choice ID

value types must belong to this set: BIGINT BYTEINT DECIMAL INT INTEGER IntegerType LongType SMALLINT TINYINT int.
may have any number of unique values.
may have any fraction of unique values.
values must not be null, at least 50 % of the time.
values must belong to this set: [ ].
minimum value may have any numerical value.
maximum value may have any numerical value.
mean may have any numerical value.
median may have any numerical value.
standard deviation may have any numerical value.
expect_column_quantile_values_to_be_between(**{'column': 'Left Choice ID', 'quantile_ranges': {'quantiles': [0.05, 0.25, 0.5, 0.75, 0.95], 'value_ranges': [[None, None], [None, None], [None, None], [None, None], [None, None]]}})
Column can match any distribution.

Loser ID

value types must belong to this set: BIGINT BYTEINT DECIMAL INT INTEGER IntegerType LongType SMALLINT TINYINT int.
may have any number of unique values.
may have any fraction of unique values.
values must not be null, at least 50 % of the time.
values must belong to this set: [ ].
minimum value may have any numerical value.
maximum value may have any numerical value.
mean may have any numerical value.
median may have any numerical value.
standard deviation may have any numerical value.
expect_column_quantile_values_to_be_between(**{'column': 'Loser ID', 'quantile_ranges': {'quantiles': [0.05, 0.25, 0.5, 0.75, 0.95], 'value_ranges': [[None, None], [None, None], [None, None], [None, None], [None, None]]}})
Column can match any distribution.

Loser Text

value types must belong to this set: CHAR StringType TEXT VARCHAR str string.
may have any number of unique values.
may have any fraction of unique values.
values must not be null, at least 50 % of the time.
values must belong to this set: [ ].
values must not match this regular expression: ^\s+|\s+$.

Missing Response Time Explanation

value types must belong to this set: DOUBLE_PRECISION DoubleType FLOAT FLOAT4 FLOAT8 FloatType NUMERIC float.
may have any number of unique values.
may have any fraction of unique values.
values must not be null, at least 50 % of the time.
values must belong to this set: [ ].

Prompt ID

value types must belong to this set: BIGINT BYTEINT DECIMAL INT INTEGER IntegerType LongType SMALLINT TINYINT int.
may have any number of unique values.
may have any fraction of unique values.
values must not be null, at least 50 % of the time.
values must belong to this set: [ ].
minimum value may have any numerical value.
maximum value may have any numerical value.
mean may have any numerical value.
median may have any numerical value.
standard deviation may have any numerical value.
expect_column_quantile_values_to_be_between(**{'column': 'Prompt ID', 'quantile_ranges': {'quantiles': [0.05, 0.25, 0.5, 0.75, 0.95], 'value_ranges': [[None, None], [None, None], [None, None], [None, None], [None, None]]}})
Column can match any distribution.

Referrer

value types must belong to this set: CHAR StringType TEXT VARCHAR str string.
may have any number of unique values.
may have any fraction of unique values.
values must not be null, at least 50 % of the time.
values must belong to this set: [ ].
values must not match this regular expression: ^\s+|\s+$.
distinct values must belong to a set, but that set is not specified.

Response Time (s)

value types must belong to this set: DOUBLE_PRECISION DoubleType FLOAT FLOAT4 FLOAT8 FloatType NUMERIC float.
may have any number of unique values.
may have any fraction of unique values.
values must not be null, at least 50 % of the time.
values must belong to this set: [ ].
minimum value may have any numerical value.
maximum value may have any numerical value.
mean may have any numerical value.
median may have any numerical value.
expect_column_quantile_values_to_be_between(**{'column': 'Response Time (s)', 'quantile_ranges': {'quantiles': [0.05, 0.25, 0.5, 0.75, 0.95], 'value_ranges': [[None, None], [None, None], [None, None], [None, None], [None, None]]}})
Column can match any distribution.

Right Choice ID

value types must belong to this set: BIGINT BYTEINT DECIMAL INT INTEGER IntegerType LongType SMALLINT TINYINT int.
may have any number of unique values.
may have any fraction of unique values.
values must not be null, at least 50 % of the time.
values must belong to this set: [ ].
minimum value may have any numerical value.
maximum value may have any numerical value.
mean may have any numerical value.
median may have any numerical value.
standard deviation may have any numerical value.
expect_column_quantile_values_to_be_between(**{'column': 'Right Choice ID', 'quantile_ranges': {'quantiles': [0.05, 0.25, 0.5, 0.75, 0.95], 'value_ranges': [[None, None], [None, None], [None, None], [None, None], [None, None]]}})
Column can match any distribution.

Session ID

value types must belong to this set: BIGINT BYTEINT DECIMAL INT INTEGER IntegerType LongType SMALLINT TINYINT int.
may have any number of unique values.
may have any fraction of unique values.
values must not be null, at least 50 % of the time.
values must belong to this set: [ ].
minimum value may have any numerical value.
maximum value may have any numerical value.
mean may have any numerical value.
median may have any numerical value.
standard deviation may have any numerical value.
expect_column_quantile_values_to_be_between(**{'column': 'Session ID', 'quantile_ranges': {'quantiles': [0.05, 0.25, 0.5, 0.75, 0.95], 'value_ranges': [[None, None], [None, None], [None, None], [None, None], [None, None]]}})
Column can match any distribution.

URL Alias

value types must belong to this set: CHAR StringType TEXT VARCHAR str string.
may have any number of unique values.
may have any fraction of unique values.
values must not be null, at least 50 % of the time.
values must belong to this set: [ ].
values must not match this regular expression: ^\s+|\s+$.
distinct values must belong to a set, but that set is not specified.

Updated at

value types must belong to this set: CHAR StringType TEXT VARCHAR str string.
may have any number of unique values.
may have any fraction of unique values.
values must not be null, at least 50 % of the time.
values must belong to this set: [ ].
values must not match this regular expression: ^\s+|\s+$.

User Agent

value types must belong to this set: CHAR StringType TEXT VARCHAR str string.
may have any number of unique values.
may have any fraction of unique values.
values must not be null, at least 50 % of the time.
values must belong to this set: [ ].
values must not match this regular expression: ^\s+|\s+$.

Valid

value types must belong to this set: BOOL BOOLEAN BooleanType bool.
may have any number of unique values.
may have any fraction of unique values.
values must not be null, at least 50 % of the time.
values must belong to this set: [ ].
distinct values must belong to a set, but that set is not specified.

Vote ID

value types must belong to this set: BIGINT BYTEINT DECIMAL INT INTEGER IntegerType LongType SMALLINT TINYINT int.
may have any number of unique values.
may have any fraction of unique values.
values must not be null, at least 50 % of the time.
values must belong to this set: [ ].
values must be unique.

Widget

value types must belong to this set: BOOL BOOLEAN BooleanType bool.
may have any number of unique values.
may have any fraction of unique values.
values must not be null, at least 50 % of the time.
values must belong to this set: [ ].
distinct values must belong to a set, but that set is not specified.

Wikisurvey ID

value types must belong to this set: BIGINT BYTEINT DECIMAL INT INTEGER IntegerType LongType SMALLINT TINYINT int.
may have any number of unique values.
may have any fraction of unique values.
values must not be null, at least 50 % of the time.
values must belong to this set: [ ].
distinct values must belong to a set, but that set is not specified.

Winner ID

value types must belong to this set: BIGINT BYTEINT DECIMAL INT INTEGER IntegerType LongType SMALLINT TINYINT int.
may have any number of unique values.
may have any fraction of unique values.
values must not be null, at least 50 % of the time.
values must belong to this set: [ ].
minimum value may have any numerical value.
maximum value may have any numerical value.
mean may have any numerical value.
median may have any numerical value.
standard deviation may have any numerical value.
expect_column_quantile_values_to_be_between(**{'column': 'Winner ID', 'quantile_ranges': {'quantiles': [0.05, 0.25, 0.5, 0.75, 0.95], 'value_ranges': [[None, None], [None, None], [None, None], [None, None], [None, None]]}})
Column can match any distribution.

Winner Text

value types must belong to this set: CHAR StringType TEXT VARCHAR str string.
may have any number of unique values.
may have any fraction of unique values.
values must not be null, at least 50 % of the time.
values must belong to this set: [ ].
values must not match this regular expression: ^\s+|\s+$.