{"uid":"cap_r8MWYBAHvDBmT5ZwZk3QU","slug":"damaged-stock-exact-row-deduplication-secondary-measure-weighted-mean-62dacb8b","name":"Damaged Stock — Exact Row Deduplication + Secondary-Measure Weighted Mean","description":"Damaged stock — Exact row deduplication + Secondary-measure weighted mean: Exact row deduplication + Secondary-measure weighted mean for supplied damaged stock records (handled_units, damaged_units). 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-retail-18-051?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","store_group","date","handled_units","damaged_units"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"store_group":{"type":"string","default":"","maxLength":80},"damaged_units":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"handled_units":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","store_group":"group-a","damaged_units":1,"handled_units":10},{"date":"2026-10-02","row_id":"row-2","store_group":"group-b","damaged_units":2,"handled_units":20},{"date":"2026-10-03","row_id":"row-3","store_group":"group-a","damaged_units":3,"handled_units":15},{"date":"2026-10-04","row_id":"row-4","store_group":"group-b","damaged_units":4,"handled_units":30}],"maxItems":200,"minItems":1},"field":{"enum":["handled_units","damaged_units"],"type":"string","default":"handled_units"}}},"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_uER03LJVHqCN7_ifC56ef","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 computes a secondary-measure weighted mean across up to 200 damaged stock records (handled_units, damaged_units) in two bundled analytical reports.","exampleAgentPrompt":"I have up to 200 rows of damaged stock records with store_group, date, handled_units, and damaged_units — can you deduplicate exact rows and compute a weighted mean of handled_units across those records, giving me both reports?","exampleUseCases":[{"title":"Retail damage audit deduplication","prompt":"I've got 150 rows of damaged stock entries from our store groups over the past quarter, some rows are exact duplicates — can you deduplicate them and compute the weighted mean of damaged_units using handled_units as the weight?"},{"title":"Warehouse handled-units summary","prompt":"Here are my daily damaged stock logs for groups A and B across October — please remove any exact duplicate rows and give me the secondary-measure weighted mean for handled_units across the cleaned dataset."},{"title":"Multi-store damage rate reporting","prompt":"I need two clean analytical reports on this damaged inventory dataset: first deduplicate exact rows, then compute the weighted mean of damaged_units. I have about 80 rows covering several store groups."}],"resultDescription":"Returns two analytical reports: (1) a deduplicated row set with exact duplicate rows removed, and (2) a secondary-measure weighted mean of the specified field (handled_units or damaged_units), computed across the cleaned dataset. Both reports are generated locally without external lookups or predictions.","failureModes":["More than 200 rows submitted — exceeds maxItems limit, request rejected","Missing required fields (row_id, store_group, date, handled_units, damaged_units) — validation error","Date field does not match YYYY-MM-DD pattern — schema validation failure","All rows are duplicates leaving empty dataset for aggregation — edge case result","Numeric values outside allowed range (±1,000,000,000,000) — validation error"],"whenToPreferThis":"Choose this endpoint when you have up to 200 damaged stock records and need both exact row deduplication and a secondary-measure weighted mean in a single low-cost call ($0.01 USDC). It is ideal for retail or warehouse inventory pipelines that need lightweight, offline data cleaning and aggregation without external API dependencies, predictions, or live lookups. Prefer alternatives if you need more than 200 rows, real-time inventory data, or operations beyond deduplication and weighted mean.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T18:34:33.260Z","isFirstParty":false,"canonicalSlug":"damaged-stock-exact-row-deduplication-secondary-measure-weighted-mean-62dacb8b"}