Expectation Validation Result

Evaluates whether a batch of data matches expectations.

Actions

Validation Filter:

Table of Contents
Overview
Expectation Suite: first_data.csv.warning
Data asset: None
Status: Succeeded
Statistics
Evaluated Expectations
38
Success Percent
100%

Info
Great Expectations Version
0.13.36
Run Name
20211007-160157-my-run-name-template
Run Time
2021-10-07T16:01:57Z
Batch Markers
ge_load_time
20211007T210157.060018Z
pandas_data_fingerprint
34f955f55943a2875d6f38519a348f01
Batch Spec
path
/home/khuyen/Data-science/data_science_tools/great_expectations_example/great_expectations/../data/second_data.csv
Table-Level Expectations
Status Expectation Observed Value
Must have these columns in this order: Unnamed: 0, Daily Time Spent on Site, Age, Area Income, Daily Internet Usage, Ad Topic Line, City, Male, Country, Timestamp, Clicked on Ad
['Unnamed: 0', 'Daily Time Spent on Site', 'Age', 'Area Income', 'Daily Internet Usage', 'Ad Topic Line', 'City', 'Male', 'Country', 'Timestamp', 'Clicked on Ad']
Ad Topic Line
Status Expectation Observed Value
values must never be null.
100% not null
value types must belong to this set: CHAR NCHAR VARCHAR NVARCHAR TEXT NTEXT STRING StringType string str object dtype('O').
0% unexpected
Age
Status Expectation Observed Value
minimum value must be greater than or equal to 15 and less than or equal to 23.
19
maximum value must be greater than or equal to 57 and less than or equal to 70.
60
mean must be greater than or equal to 30 and less than or equal to 40.
≈35.94358974
values must never be null.
100% not null
value types must belong to this set: INTEGER integer int int_ int8 int16 int32 int64 uint8 uint16 uint32 uint64 INT INTEGER INT64 TINYINT BYTEINT SMALLINT BIGINT IntegerType LongType.
int64
Area Income
Status Expectation Observed Value
minimum value must be greater than or equal to 12000 and less than or equal to 15000.
13996.5
maximum value must be greater than or equal to 70000 and less than or equal to 80000.
79332.33
mean must be greater than or equal to 54000 and less than or equal to 65000.
≈54428.13154
values must never be null.
100% not null
value types must belong to this set: FLOAT FLOAT4 FLOAT8 FLOAT64 DOUBLE DOUBLE_PRECISION NUMERIC FloatType DoubleType float_ float16 float32 float64 number DECIMAL REAL.
float64
City
Status Expectation Observed Value
values must never be null.
100% not null
fraction of unique values must be greater than or equal to 0.9 and less than or equal to 0.999.
≈0.9897435897
value types must belong to this set: CHAR NCHAR VARCHAR NVARCHAR TEXT NTEXT STRING StringType string str object dtype('O').
0% unexpected
Clicked on Ad
Status Expectation Observed Value
mean must be greater than or equal to 0.45 and less than or equal to 0.55.
≈0.5128205128
values must belong to this set: 0 1.
0% unexpected
values must never be null.
100% not null
value types must belong to this set: INTEGER integer int int_ int8 int16 int32 int64 uint8 uint16 uint32 uint64 INT INTEGER INT64 TINYINT BYTEINT SMALLINT BIGINT IntegerType LongType.
int64
Country
Status Expectation Observed Value
values must never be null.
100% not null
value types must belong to this set: CHAR NCHAR VARCHAR NVARCHAR TEXT NTEXT STRING StringType string str object dtype('O').
0% unexpected
Daily Internet Usage
Status Expectation Observed Value
minimum value must be greater than or equal to 95 and less than or equal to 110.
104.78
maximum value must be greater than or equal to 250 and less than or equal to 270.
267.01
mean must be greater than or equal to 170 and less than or equal to 185.
≈180.8764872
values must never be null.
100% not null
value types must belong to this set: FLOAT FLOAT4 FLOAT8 FLOAT64 DOUBLE DOUBLE_PRECISION NUMERIC FloatType DoubleType float_ float16 float32 float64 number DECIMAL REAL.
float64
Daily Time Spent on Site
Status Expectation Observed Value
minimum value must be greater than or equal to 30 and less than or equal to 40.
32.6
maximum value must be greater than or equal to 85 and less than or equal to 100.
91.43
mean must be greater than or equal to 55 and less than or equal to 70.
≈64.58282051
values must never be null.
100% not null
value types must belong to this set: FLOAT FLOAT4 FLOAT8 FLOAT64 DOUBLE DOUBLE_PRECISION NUMERIC FloatType DoubleType float_ float16 float32 float64 number DECIMAL REAL.
float64
Male
Status Expectation Observed Value
values must belong to this set: 0 1.
0% unexpected
mean must be greater than or equal to 0.45 and less than or equal to 0.55.
≈0.4743589744
values must never be null.
100% not null
value types must belong to this set: INTEGER integer int int_ int8 int16 int32 int64 uint8 uint16 uint32 uint64 INT INTEGER INT64 TINYINT BYTEINT SMALLINT BIGINT IntegerType LongType.
int64
Timestamp
Status Expectation Observed Value
values must never be null.
100% not null
value types must belong to this set: CHAR NCHAR VARCHAR NVARCHAR TEXT NTEXT STRING StringType string str object dtype('O').
0% unexpected