{"uid":"cap_-zjPh8slNh4Ng_UopohQv","slug":"competitor-supplied-prices-exact-row-deduplication-iqr-outlier-flags-48b03ee2","name":"Competitor Supplied Prices — Exact Row Deduplication + IQR Outlier Flags","description":"Competitor supplied prices — Exact row deduplication + IQR outlier flags: Exact row deduplication + IQR outlier flags for supplied competitor supplied prices records (list_price, package_quantity). 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-company-07-049?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","list_price","package_quantity"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"list_price":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"company_group":{"type":"string","default":"","maxLength":80},"package_quantity":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","list_price":10,"company_group":"group-a","package_quantity":1},{"date":"2026-10-02","row_id":"row-2","list_price":20,"company_group":"group-b","package_quantity":2},{"date":"2026-10-03","row_id":"row-3","list_price":15,"company_group":"group-a","package_quantity":3},{"date":"2026-10-04","row_id":"row-4","list_price":30,"company_group":"group-b","package_quantity":4}],"maxItems":200,"minItems":1},"field":{"enum":["list_price","package_quantity"],"type":"string","default":"list_price"}}},"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_frO9pacIktZvWtjGvOgzs","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":"Deduplicates exact rows and flags IQR-based outliers in supplied competitor price records (list_price or package_quantity) for up to 200 rows, producing 2 independent analytical reports.","exampleAgentPrompt":"Can you deduplicate and flag IQR outliers in this competitor pricing dataset? I have up to 50 rows with row_id, company_group, date, list_price, and package_quantity fields — please run the analysis on list_price and give me both the deduplication report and the outlier flags.","exampleUseCases":[{"title":"Cleaning competitor price feed before ingestion","prompt":"I've got a batch of competitor pricing records from our data supplier — can you deduplicate exact rows and flag any list_price values that look like IQR outliers? There are about 120 rows, each with a row_id, company_group, date, list_price, and package_quantity."},{"title":"Auditing package quantity anomalies across vendor groups","prompt":"Run an IQR outlier check and exact deduplication on this set of 80 competitor records for me — I want to analyze package_quantity specifically, so flag anything that falls outside the interquartile range and also remove duplicate rows."},{"title":"Validating competitor data before pricing model update","prompt":"Before I feed this competitor price data into our model, can you check for duplicate rows and any statistical outliers in the list_price column? I have 200 rows with row_id, company_group, date, list_price, and package_quantity — use IQR-based outlier detection and give me both reports."}],"resultDescription":"Returns 2 independent analytical reports: (1) an exact row deduplication report identifying repeated records across the supplied rows, and (2) an IQR outlier flags report identifying which rows have list_price or package_quantity values that fall outside the interquartile range. No external lookups or predictions are made — all analysis is performed locally on the supplied data.","failureModes":["Input array exceeds 200 rows — request will be rejected","Missing required fields (row_id, company_group, date, list_price, package_quantity) cause validation errors","Invalid date format (not YYYY-MM-DD) causes schema rejection","Field selector not one of 'list_price' or 'package_quantity' causes enum validation error","Empty rows array (minItems: 1 violated) causes rejection","All rows are unique — deduplication report returns no duplicates found","Insufficient data spread for IQR calculation if too few rows provided"],"whenToPreferThis":"Choose this endpoint when you need both exact duplicate detection and IQR-based statistical outlier flagging on competitor pricing data (list_price or package_quantity) in a single low-cost call. It is ideal for data quality pipelines that process competitor price feeds before ingestion, since it returns two focused reports without requiring live data lookups, external enrichment, or predictions. Prefer this over general-purpose analytics when your dataset is up to 200 rows and you specifically need the IQR outlier methodology on pricing or quantity fields.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:44:14.782Z","isFirstParty":false,"canonicalSlug":"competitor-supplied-prices-exact-row-deduplication-iqr-outlier-flags-48b03ee2"}