# Column Selector Functions: Easily Pick Columns
Pointblank Validation
2026-07-13|17:45:00 Polars
STEP COLUMNS VALUES TBL EVAL UNITS PASS FAIL W E C EXT
#4CA64C 1
col_vals_ge()
item_revenue 0 ✓ 2000 2000
1.00		 0
0.00		 -- -- -- --
#4CA64C 2
col_vals_ge()
session_duration 0 ✓ 2000 2000
1.00		 0
0.00		 -- -- -- --
#4CA64C 3
col_vals_regex()
player_id ^[A-Z]{12}\d{3} ✓ 2000 2000
1.00		 0
0.00		 -- -- -- --
#4CA64C 4
col_vals_regex()
session_id ^[A-Z]{12}\d{3} ✓ 2000 2000
1.00		 0
0.00		 -- -- -- --
#4CA64C 5
col_vals_not_null()
acquisition -- ✓ 2000 2000
1.00		 0
0.00		 -- -- -- --
#4CA64C 6
w9IiMwMDAwMDAiIGZpbGwtcnVsZT0ibm9uemVybyIgLz4KICAgICAgICAgICAgPHBhdGggZD0iTTMzLDcuOTM1OTc3MDUgQzMzLjI3NjE0MjQsNy45MzU5NzcwNSAzMy41LDguMTU5ODM0NjcgMzMuNSw4LjQzNTk3NzA1IEwzMy41LDU3LjU2NDAyMyBDMzMuNSw1Ny44NDAxNjUzIDMzLjI3NjE0MjQsNTguMDY0MDIzIDMzLDU4LjA2NDAyMyBDMzIuNzIzODU3Niw1OC4wNjQwMjMgMzIuNSw1Ny44NDAxNjUzIDMyLjUsNTcuNTY0MDIzIEwzMi41LDguNDM1OTc3MDUgQzMyLjUsOC4xNTk4MzQ2NyAzMi43MjM4NTc2LDcuOTM1OTc3MDUgMzMsNy45MzU5NzcwNSBaIiBpZD0ibGluZV9ibGFjayIgZmlsbD0iIzAwMDAwMCIgdHJhbnNmb3JtPSJ0cmFuc2xhdGUoMzMuMDAwMDAwLCAzMy4wMDAwMDApIHJvdGF0ZSgtMzIwLjAwMDAwMCkgdHJhbnNsYXRlKC0zMy4wMDAwMDAsIC0zMy4wMDAwMDApICIgLz4KICAgICAgICAgICAgPHBvbHlnb24gaWQ9ImxpbmVfd2hpdGUiIGZpbGw9IiNGRkZGRkYiIHRyYW5zZm9ybT0idHJhbnNsYXRlKDM0Ljg5OTQ5NiwgMzIuMTUzMzAzKSByb3RhdGUoLTMyMC4wMDAwMDApIHRyYW5zbGF0ZSgtMzQuODk5NDk2LCAtMzIuMTUzMzAzKSAiIHBvaW50cz0iMzQuMzk5NDk2MiA4LjU0MTYwNDY5IDM1LjM5OTQ5NjIgOC41NDE2MDQ2OSAzNS4zOTk0OTYyIDU1Ljc2NTAwMTkgMzQuMzk5NDk2MiA1NS43NjUwMDE5Ij48L3BvbHlnb24+CiAgICAgICAgPC9nPgogICAgPC9nPgo8L3N2Zz4=" /> col_vals_not_null()
country -- ✓ 2000 2000
1.00		 0
0.00		 -- -- -- --
#4CA64C 7
col_vals_regex()
player_id (.|\s)*\S(.|\s)* ✓ 2000 2000
1.00		 0
0.00		 -- -- -- --
#4CA64C 8
9ImFzdGVyaXNrIiAvPgogICAgICAgICAgICA8L2c+CiAgICAgICAgPC9nPgogICAgPC9nPgo8L3N2Zz4=" /> col_vals_regex()
session_id (.|\s)*\S(.|\s)* ✓ 2000 2000
1.00		 0
0.00		 -- -- -- --
#4CA64C 9
col_vals_regex()
item_type (.|\s)*\S(.|\s)* ✓ 2000 2000
1.00		 0
0.00		 -- -- -- --
#4CA64C 10
col_vals_regex()
item_name (.|\s)*\S(.|\s)* ✓ 2000 2000
1.00		 0
0.00		 -- -- -- --
#4CA64C 11
col_vals_regex()
acquisition (.|\s)*\S(.|\s)* ✓ 2000 2000
1.00		 0
0.00		 -- -- -- --
#4CA64C 12
col_vals_regex()
country (.|\s)*\S(.|\s)* ✓ 2000 2000
1.00		 0
0.00		 -- -- -- --
2026-07-13 17:45:00 UTC< 1 s2026-07-13 17:45:00 UTC
``` python import pointblank as pb import narwhals.selectors as ncs validation = ( pb.Validate( data=pb.load_dataset(dataset="game_revenue", tbl_type="polars") ) .col_vals_ge( columns=pb.matches("rev|dur"), # check values in columns having 'rev' or 'dur' in name value=0 ) .col_vals_regex( columns=pb.ends_with("_id"), # check values in columns with names ending in '_id' pattern=r"^[A-Z]{12}\d{3}" ) .col_vals_not_null( columns=pb.last_n(2) # check that the last two columns don't have Null values ) .col_vals_regex( columns=ncs.string(), # check that all string columns are non-empty strings pattern=r"(.|\s)*\S(.|\s)*" ) .interrogate() ) validation ``` Preview of Input Table
PolarsRows2,000Columns11
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