Validate quantities and prices against ranges

Task: the rules

Input
  inventory(id, sku, quantity, unit_price, country) — text. id is unique; sku is always present.

Normalize
  country: remove ASCII whitespace at both ends, then uppercase.

Quarantine each invalid row with the FIRST failing reason, checked in this order:
  1. missing_quantity        quantity is missing
  2. bad_quantity            quantity is not a whole number: optional "-" then digits only
  3. quantity_out_of_range   quantity is less than 1 or greater than 500
  4. bad_price               unit_price is missing, or is not: optional "-", digits, optionally "." and 1–2 digits
  5. price_out_of_range      unit_price is zero or negative
  6. bad_country             country is not one of US, CA, MX (a missing country is also bad_country)

Outputs (row order does not matter)
  clean(id text, sku text, quantity int64, unit_price decimal(10,2), country text)
  exceptions(id text, reason text)

Compact layout

Steps

0 of 200

Input table:Inputs are read-only. Every step works on a copy.

Input table inventory, rows 1 to 21 of 21
#
1	invybqz	SKU-6252	1	760.28	·CA (raw value " CA")
2	invf1ge	SKU-7738	501	580.05	MX
3	invoi41	SKU-0003	12	-1.00	USA
4	inveree	SKU-5191	23	572.57	·CA (raw value " CA")
5	inv29z8	SKU-0001	0	0.00	UK
6	invvnhm	SKU-4924	434	524.17	US
7	invkmms	SKU-4496	7.5	573.38	CA
8	inveec2	SKU-6847	1	0	us
9	invezdp	SKU-0936	436	956.62	US
10	invgt2u	SKU-9259	440	1,200.00	MX
11	inv4nh6	SKU-6643	72	1,200.00	MX
12	invi6w4	SKU-0002	missing	abc	missing
13	invqlou	SKU-7543	470	12.5	mx⇥ (raw value "mx\t")
14	inv04ar	SKU-1830	empty	969.00	US
15	invqmkt	SKU-6302	34	9.999	MX
16	invkepr	SKU-9281	empty	missing	CA
17	invbl5x	SKU-4147	500	missing	USA
18	inv6qmz	SKU-4169	388	0	empty
19	invympz	SKU-6955	empty	9.999	mx⇥ (raw value "mx\t")
20	invxr2k	SKU-4668	73	0.99	US
21	inv2c6v	SKU-0917	171	-1.00	USA

Preview · this dataset, in your browser, not a grade

21 input rows → 21 clean + 0 exceptions

Check answer · graded on the server, including datasets you can't see

Press Check answer when you're ready. Your pipeline runs on the visible data and on hidden datasets that follow the same rules.

Learn from this exercise

A worked solution becomes available after your first check or once you've used every hint.

Skip to next: Resolve customer records by normalized email →Review queue

Validate quantities and prices against ranges

Preview · this dataset, in your browser, not a grade

Check answer · graded on the server, including datasets you can't see

Learn from this exercise

AI tutor · may be wrong; the grader decides