{"uid":"cap_9t_a5pEOAXam9j5d9NJg2","slug":"price-basket-observations-string-normalisation-exact-row-deduplication-3ad66f46","name":"Price Basket Observations — String Normalisation + Exact Row Deduplication","description":"Price basket observations — String normalisation + Exact row deduplication: String normalisation + Exact row deduplication for supplied price basket observations records (item_price, quantity_weight). Up to 200 rows; 2 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 2 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-economics-07-020?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","region","date","item_price","quantity_weight"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"region":{"type":"string","default":"","maxLength":80},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"item_price":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"quantity_weight":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","region":"group-a","row_id":"row-1","item_price":10,"quantity_weight":1},{"date":"2026-10-02","region":"group-b","row_id":"row-2","item_price":20,"quantity_weight":2},{"date":"2026-10-03","region":"group-a","row_id":"row-3","item_price":15,"quantity_weight":3},{"date":"2026-10-04","region":"group-b","row_id":"row-4","item_price":30,"quantity_weight":4}],"maxItems":200,"minItems":1}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_SMtJFRWSETtsRR5aEsGjp","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Normalises strings and removes exact duplicate rows from price basket observation records containing item_price and quantity_weight fields, returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"I have up to 200 rows of price basket observations with item_price and quantity_weight values — can you run string normalisation and exact row deduplication on them and give me the two analytical reports?","exampleUseCases":[{"title":"Retail price survey data cleaning","prompt":"I've collected price basket survey data across regions group-a and group-b with item prices and quantity weights from October 2026 — please normalise the strings and remove any exactly duplicated rows, and give me the two reports."},{"title":"Economics research deduplication pass","prompt":"Before I analyse this price basket dataset of 150 rows with item_price and quantity_weight fields, can you run exact row deduplication and string normalisation on it so the data is clean?"},{"title":"Multi-region basket observation audit","prompt":"I have price basket observations from multiple regions with dates and item prices — run string normalisation and exact duplicate removal on all the rows and return both analytical reports."}],"resultDescription":"Two independent analytical reports covering: (1) string normalisation results showing standardised text fields across region and date columns, and (2) exact row deduplication results identifying and removing fully duplicate records from the supplied price basket observations (item_price, quantity_weight). Reports cover up to 200 input rows. No external lookups or predictions are included.","failureModes":["More than 200 rows submitted — request exceeds maxItems limit and will be rejected","Missing required fields (row_id, region, date, item_price, or quantity_weight) cause row-level validation failure","Invalid date format (not YYYY-MM-DD pattern) causes schema rejection","item_price or quantity_weight values outside ±1,000,000,000,000 range cause validation error","Empty rows array (minItems: 1 not met) causes request rejection","Payment of 0.01 USDC not attached causes x402 payment-required response"],"whenToPreferThis":"Choose this endpoint when you need lightweight, local-engine data cleaning specifically for price basket observation records with item_price and quantity_weight fields, and you want both string normalisation and exact row deduplication delivered as two reports in a single call for a flat fee of $0.01 USDC. Prefer this over general-purpose data cleaning services when your dataset is ≤200 rows, you do not need live lookups or predictions, and cost predictability matters.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T12:31:31.490Z","isFirstParty":false,"canonicalSlug":"price-basket-observations-string-normalisation-exact-row-deduplication-3ad66f46"}