Data Extracts

Pulling out data extracts that highlight rows with validation failures.

Validation with failures at Step 2:

Pointblank Validation
Validation with test unit failures available as an extract Polarsgame_revenue
		STEP	COLUMNS	VALUES	TBL	EVAL	UNITS	PASS	FAIL	W	S	N	EXT
#4CA64C	1	col_vals_gt()	item_revenue	0		✓	2000	2000 1.00	0 0.00	—	—	—	—
#4CA64C66	2	col_vals_ge()	session_duration	5		✓	2000	1986 0.99	14 0.01	—	—	—
2025-01-20 18:17:33 UTC< 1 s2025-01-20 18:17:33 UTC

Extract from Step 2 (.col_vals_ge(columns="session_duration", value=5)):

PolarsRows14Columns11
	player_id String	session_id String	session_start Datetime	time Datetime	item_type String	item_name String	item_revenue Float64	session_duration Float64	start_day Date	acquisition String	country String
1	QNLVRDEOXFYJ892	QNLVRDEOXFYJ892-lz5fmr6k	2015-01-10 16:44:17+00:00	2015-01-10 16:45:29+00:00	iap	gold3	3.49	3.7	2015-01-09	crosspromo	Australia
2	GFLYJHAPMZWD631	GFLYJHAPMZWD631-i2v1bl7a	2015-01-11 16:13:24+00:00	2015-01-11 16:14:54+00:00	iap	gems2	3.99	3.6	2015-01-09	organic	India
3	BFNLURISJXTH647	BFNLURISJXTH647-6o5hx27z	2015-01-12 17:37:39+00:00	2015-01-12 17:39:27+00:00	iap	offer5	11.59	4.1	2015-01-10	organic	India
4	BFNLURISJXTH647	BFNLURISJXTH647-6o5hx27z	2015-01-12 17:37:39+00:00	2015-01-12 17:41:45+00:00	iap	gems3	9.99	4.1	2015-01-10	organic	India
5	KILWZYHRSJEG316	KILWZYHRSJEG316-uke7dhqj	2015-01-13 22:16:29+00:00	2015-01-13 22:17:35+00:00	iap	offer2	10.99	3.2	2015-01-04	organic	Denmark
10	OMCVUAIKSDTR651	OMCVUAIKSDTR651-yso9e1b2	2015-01-17 20:58:34+00:00	2015-01-17 21:02:34+00:00	iap	offer5	20.29	4.2	2015-01-07	other_campaign	United States
11	MTCIWKOVASYP925	MTCIWKOVASYP925-1q3xvfmp	2015-01-20 12:34:43+00:00	2015-01-20 12:35:37+00:00	iap	offer5	26.09	3.9	2015-01-14	organic	Germany
12	MTCIWKOVASYP925	MTCIWKOVASYP925-1q3xvfmp	2015-01-20 12:34:43+00:00	2015-01-20 12:37:25+00:00	iap	gold2	1.79	3.9	2015-01-14	organic	Germany
13	BFNLURISJXTH647	BFNLURISJXTH647-len6vujd	2015-01-20 14:09:51+00:00	2015-01-20 14:10:03+00:00	iap	gold7	47.99	4.5	2015-01-10	organic	India
14	BFNLURISJXTH647	BFNLURISJXTH647-len6vujd	2015-01-20 14:09:51+00:00	2015-01-20 14:14:21+00:00	iap	gold6	23.99	4.5	2015-01-10	organic	India

import pointblank as pb

validation = (
    pb.Validate(
        data=pb.load_dataset(dataset="game_revenue"),
        tbl_name="game_revenue",
        label="Validation with test unit failures available as an extract"
    )
    .col_vals_gt(columns="item_revenue", value=0)      # STEP 1: no test unit failures
    .col_vals_ge(columns="session_duration", value=5)  # STEP 2: 14 test unit failures -> extract
    .interrogate()
    .interrogate()
)

pb.preview(validation.get_data_extracts(i=2, frame=True), n_head=20, n_tail=20)

Preview of Input Table

PolarsRows2000Columns11
	player_id String	session_id String	session_start Datetime	time Datetime	item_type String	item_name String	item_revenue Float64	session_duration Float64	start_day Date	acquisition String	country String
1	ECPANOIXLZHF896	ECPANOIXLZHF896-eol2j8bs	2015-01-01 01:31:03+00:00	2015-01-01 01:31:27+00:00	iap	offer2	8.99	16.3	2015-01-01	google	Germany
2	ECPANOIXLZHF896	ECPANOIXLZHF896-eol2j8bs	2015-01-01 01:31:03+00:00	2015-01-01 01:36:57+00:00	iap	gems3	22.49	16.3	2015-01-01	google	Germany
3	ECPANOIXLZHF896	ECPANOIXLZHF896-eol2j8bs	2015-01-01 01:31:03+00:00	2015-01-01 01:37:45+00:00	iap	gold7	107.99	16.3	2015-01-01	google	Germany
4	ECPANOIXLZHF896	ECPANOIXLZHF896-eol2j8bs	2015-01-01 01:31:03+00:00	2015-01-01 01:42:33+00:00	ad	ad_20sec	0.76	16.3	2015-01-01	google	Germany
5	ECPANOIXLZHF896	ECPANOIXLZHF896-hdu9jkls	2015-01-01 11:50:02+00:00	2015-01-01 11:55:20+00:00	ad	ad_5sec	0.03	35.2	2015-01-01	google	Germany
1996	NAOJRDMCSEBI281	NAOJRDMCSEBI281-j2vs9ilp	2015-01-21 01:57:50+00:00	2015-01-21 02:02:50+00:00	ad	ad_survey	1.332	25.8	2015-01-11	organic	Norway
1997	NAOJRDMCSEBI281	NAOJRDMCSEBI281-j2vs9ilp	2015-01-21 01:57:50+00:00	2015-01-21 02:22:14+00:00	ad	ad_survey	1.35	25.8	2015-01-11	organic	Norway
1998	RMOSWHJGELCI675	RMOSWHJGELCI675-vbhcsmtr	2015-01-21 02:39:48+00:00	2015-01-21 02:40:00+00:00	ad	ad_5sec	0.03	8.4	2015-01-10	other_campaign	France
1999	RMOSWHJGELCI675	RMOSWHJGELCI675-vbhcsmtr	2015-01-21 02:39:48+00:00	2015-01-21 02:47:12+00:00	iap	offer5	26.09	8.4	2015-01-10	other_campaign	France
2000	GJCXNTWEBIPQ369	GJCXNTWEBIPQ369-9elq67md	2015-01-21 03:59:23+00:00	2015-01-21 04:06:29+00:00	ad	ad_5sec	0.12	18.5	2015-01-14	organic	United States