{"uid":"cap_oosVEMJJ8o7CjCy1Elcun","slug":"warehouse-bins-exact-row-deduplication-two-measure-correlation-17806678","name":"Warehouse Bins — Exact Row Deduplication + Two-Measure Correlation","description":"Warehouse bins — Exact row deduplication + Two-measure correlation: Exact row deduplication + Two-measure correlation for supplied warehouse bins records (occupied_volume, available_volume). 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-13-050?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","store_group","date","occupied_volume","available_volume"],"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},"occupied_volume":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"available_volume":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","store_group":"group-a","occupied_volume":10,"available_volume":1},{"date":"2026-10-02","row_id":"row-2","store_group":"group-b","occupied_volume":20,"available_volume":2},{"date":"2026-10-03","row_id":"row-3","store_group":"group-a","occupied_volume":15,"available_volume":3},{"date":"2026-10-04","row_id":"row-4","store_group":"group-b","occupied_volume":30,"available_volume":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_IPM7YunWSA2mRgK3ot8MD","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 warehouse bin records exactly by row and computes Pearson correlation between occupied_volume and available_volume across up to 200 supplied rows, returning two analytical reports.","exampleAgentPrompt":"I have up to 200 rows of warehouse bin records with occupied_volume and available_volume fields — can you deduplicate the rows exactly and also run a correlation analysis between those two volume measures, giving me both reports?","exampleUseCases":[{"title":"Warehouse bin audit deduplication","prompt":"I've got 150 rows of warehouse bin data for our group-a and group-b stores, each with a row_id, date, occupied_volume, and available_volume — can you deduplicate the exact duplicate rows and tell me how many were removed?"},{"title":"Volume correlation check across store groups","prompt":"Can you take my warehouse bin records for October 2026 across store groups and compute the correlation between occupied_volume and available_volume so I can see if fuller bins tend to leave less space?"},{"title":"Dual-report analytics on bin occupancy data","prompt":"I need two reports on my warehouse bin dataset: one that deduplicates all exact duplicate rows by row_id, date, and store_group, and one that shows the correlation between occupied_volume and available_volume — it's 180 rows total."}],"resultDescription":"Two analytical reports: (1) an exact row deduplication report identifying and removing fully duplicate rows from the supplied warehouse bin records, and (2) a Pearson or equivalent correlation report between the occupied_volume and available_volume measures across all (de-duplicated) rows. No external data is fetched; all analysis is performed on the supplied rows only.","failureModes":["Input exceeds 200 rows — request rejected","Missing required fields (row_id, date, occupied_volume, available_volume) cause validation errors","Malformed date strings not matching YYYY-MM-DD pattern rejected","All rows are unique so deduplication report shows no duplicates removed","Insufficient numeric variance in measures may result in undefined or NaN correlation","Empty rows array (minItems:1 violated) returns error"],"whenToPreferThis":"Choose this endpoint when you have up to 200 warehouse bin records with occupied_volume and available_volume and need both exact row deduplication and a two-measure correlation analysis in a single low-cost call. It is ideal for retail or warehouse operations teams doing lightweight data quality checks on supplied data without needing live lookup, prediction, or external data enrichment. Prefer alternatives if you need more than 200 rows, more than two correlated measures, or analyses beyond deduplication and correlation.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T18:34:15.569Z","isFirstParty":false,"canonicalSlug":"warehouse-bins-exact-row-deduplication-two-measure-correlation-17806678"}