{"uid":"cap_vyDtSiLNV907WpEd0KrYz","slug":"warehouse-bins-numeric-interval-filter-explicit-missing-value-fill-6ee6089e","name":"Warehouse Bins — Numeric Interval Filter + Explicit Missing-Value Fill","description":"Warehouse bins — Numeric interval filter + Explicit missing-value fill: Numeric interval filter + Explicit missing-value fill 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-135?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},"field":{"enum":["occupied_volume","available_volume"],"type":"string","default":"occupied_volume"},"method":{"enum":["zero","mean","median"],"type":"string","default":"median"},"maximum":{"type":"number","default":100,"maximum":1000000000000,"minimum":-1000000000000},"minimum":{"type":"number","default":0,"maximum":1000000000000,"minimum":-1000000000000}}},"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_BTrBg6GdDoNxIFShcOHi6","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":"Filters warehouse bin records by a numeric interval on occupied_volume or available_volume, then fills missing values using zero, mean, or median imputation — returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"I have 150 warehouse bin records with some null occupied_volume entries — can you fill the missing values using median imputation and then filter to only the rows where occupied_volume is between 0 and 500, targeting the occupied_volume field?","exampleUseCases":[{"title":"Retail warehouse capacity audit","prompt":"I've got 120 warehouse bin rows for our retail stores and some occupied_volume values are missing — fill those nulls with the mean and then show me only the bins where occupied_volume falls between 50 and 300."},{"title":"Available space anomaly filtering","prompt":"Can you take these 80 bin records, fill any null available_volume values with zero, and then filter down to only rows where available_volume is between 10 and 200? I need two reports on what's left."},{"title":"Multi-store bin data cleanup","prompt":"Here are 200 warehouse bin entries across groups A and B — several have null available_volume. Please fill them using median and keep only the records where available_volume is between 5 and 150 so I can review storage health."}],"resultDescription":"Two analytical reports derived from the submitted warehouse bin records: one reflecting the interval-filtered rows (where the chosen field falls within the specified minimum and maximum), and one with missing values in the target field replaced using the chosen fill method (zero, mean, or median). Results are computed locally without external lookup.","failureModes":["Empty or missing rows array returns a validation error","Row count exceeding 200 items triggers a max-items rejection","Invalid date format (not YYYY-MM-DD) causes schema validation failure","Minimum value greater than maximum value may produce zero matching rows","Unrecognized method value outside zero/mean/median enum causes rejection","Missing required fields (row_id, store_group, date) per row cause item-level validation errors"],"whenToPreferThis":"Choose this endpoint when you have up to 200 warehouse bin records with occupied_volume or available_volume data and need both numeric interval filtering and missing-value imputation in a single call at low cost ($0.01 USDC for two reports). It is ideal for batch preprocessing of warehouse bin data before downstream reporting, when no live data lookup or prediction is needed and the analysis can run on supplied data alone.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-31T00:43:37.775Z","isFirstParty":false,"canonicalSlug":"warehouse-bins-numeric-interval-filter-explicit-missing-value-fill-6ee6089e"}