DataPact · orders validation report

FAIL 10 error-severity expectation(s) failed.

01 — Summary

Expectations

Passed

Failed

Warnings

02 — Expectations

Result	Expectation	Column	Severity	Detail
fail	column_values_unique	order_id	error	1 duplicated value(s) e.g. {'value': '1001', 'count': 2}
fail	column_values_not_null	email	error	1/15 values failed not-null (6.7% unexpected; mostly=1.0) e.g. {'row': 5, 'value': ''}
fail	column_values_match_regex	email	error	1/14 values failed regex (7.1% unexpected; mostly=1.0) e.g. {'row': 2, 'value': 'not-an-email'}
fail	column_values_not_null	status	error	1/15 values failed not-null (6.7% unexpected; mostly=1.0) e.g. {'row': 14, 'value': ''}
fail	column_values_in_set	status	error	2/14 values failed in_set (14.3% unexpected; mostly=1.0) e.g. {'row': 3, 'value': 'REFUND'}, {'row': 10, 'value': 'delivered'}
fail	column_values_match_strftime_format	order_date	error	1/15 values failed strftime(%Y-%m-%d) (6.7% unexpected; mostly=1.0) e.g. {'row': 7, 'value': '2026/01/09'}
fail	column_values_between	subtotal	error	1/15 values failed between[0,100000] (6.7% unexpected; mostly=1.0) e.g. {'row': 4, 'value': '-2300.00'}
fail	column_values_between	quantity	error	2/15 values failed between[1,20] (13.3% unexpected; mostly=1.0) e.g. {'row': 8, 'value': '40'}, {'row': 13, 'value': '0'}
fail	column_values_in_set	country	error	1/15 values failed in_set (6.7% unexpected; mostly=1.0) e.g. {'row': 10, 'value': 'KENYA'}
fail	multicolumn_sum_to_equal	—	error	3/15 rows where sum['subtotal', 'tax'] != total e.g. {'row': 4, 'sum_parts': -1932.0, 'total': 2668.0}, {'row': 6, 'sum_parts': 499.09000000000003, 'total': 999.09}, {'row': 12, 'sum_parts': 1682.0, 'total': 9999.0}
pass	column_values_of_type	order_id	error
pass	column_to_exist	order_id	error
pass	column_values_not_null	order_id	error
pass	column_values_of_type	customer_id	error
pass	column_to_exist	customer_id	error
pass	column_values_not_null	customer_id	error
pass	column_values_of_type	email	error
pass	column_to_exist	email	error
pass	column_values_of_type	status	error
pass	column_to_exist	status	error
pass	column_values_of_type	order_date	error
pass	column_to_exist	order_date	error
pass	column_values_not_null	order_date	error
pass	column_values_of_type	subtotal	error
pass	column_to_exist	subtotal	error
pass	column_values_not_null	subtotal	error
pass	column_values_of_type	tax	error
pass	column_to_exist	tax	error
pass	column_values_not_null	tax	error
pass	column_values_of_type	total	error
pass	column_to_exist	total	error
pass	column_values_not_null	total	error
pass	column_values_between	total	error
pass	column_values_of_type	quantity	error
pass	column_to_exist	quantity	error
pass	column_values_not_null	quantity	error
pass	column_values_of_type	country	error
pass	column_to_exist	country	error
pass	column_values_not_null	country	error
pass	column_values_match_regex	customer_id	warn
pass	table_row_count_between	—	warn

03 — Data Profile

order_id

int

count: 15
nulls: 0 (0.0%)
distinct: 14
min / max: 1001 / 1015
mean: 1.01e+03
stdev: 4.65

1001–1002.4 · 3

1002.4–1003.8 · 1

1003.8–1005.2 · 2

1005.2–1006.6 · 1

1006.6–1008 · 1

1008–1009.4 · 1

customer_id

str

count: 15
nulls: 0 (0.0%)
distinct: 9
len min/max: 5 / 5

C-204 · 2

C-118 · 2

C-330 · 2

C-451 · 2

C-509 · 2

C-622 · 2

email

str

count: 14
nulls: 1 (6.7%)
distinct: 10
len min/max: 12 / 20

amina@example.co.ke · 2

david@example.net · 2

esther@example.co.ke · 2

felix@example.com · 2

brian@example.com · 1

not-an-email · 1

status

str

count: 14
nulls: 1 (6.7%)
distinct: 6
len min/max: 3 / 9

paid · 7

shipped · 2

new · 2

REFUND · 1

delivered · 1

refunded · 1

order_date

date

count: 15
nulls: 0 (0.0%)
distinct: 13
len min/max: 10 / 10

2026-01-04 · 2

2026-01-06 · 2

2026-01-05 · 1

2026-01-07 · 1

2026-01-08 · 1

2026/01/09 · 1

subtotal

float

count: 15
nulls: 0 (0.0%)
distinct: 13
min / max: -2300 / 2300
mean: 513
stdev: 973

-2300–-1840 · 1

-1840–-1380 · 0

-1380–-920 · 0

-920–-460 · 0

-460–0 · 0

0–460 · 7

tax

float

count: 15
nulls: 0 (0.0%)
distinct: 12
min / max: 10.48 / 368
mean: 131
stdev: 117

10.48–46.232 · 5

46.232–81.984 · 2

81.984–117.736 · 1

117.736–153.488 · 0

153.488–189.24 · 2

189.24–224.992 · 2

total

float

count: 15
nulls: 0 (0.0%)
distinct: 12
min / max: 75.98 / 9999
mean: 1.54e+03
stdev: 2.41e+03

75.98–1068.28 · 8

1068.28–2060.58 · 4

2060.58–3052.89 · 2

3052.89–4045.19 · 0

4045.19–5037.49 · 0

5037.49–6029.79 · 0

quantity

int

count: 15
nulls: 0 (0.0%)
distinct: 6
min / max: 0 / 40
mean: 4.67
stdev: 9.55

0–4 · 12

4–8 · 2

8–12 · 0

12–16 · 0

16–20 · 0

20–24 · 0

country

str

count: 15
nulls: 0 (0.0%)
distinct: 5
len min/max: 2 / 5

KE · 7

UG · 3

TZ · 2

RW · 2

KENYA · 1