{"uid":"cap_GMHvRJgpp5-lAkW9Fh5VD","slug":"supplier-qualification-numeric-interval-filter-explicit-missing-value-aec47bda","name":"Supplier Qualification — Numeric Interval Filter + Explicit Missing-Value Fill","description":"Supplier qualification — Numeric interval filter + Explicit missing-value fill: Numeric interval filter + Explicit missing-value fill for supplied supplier qualification records (checked_criteria, met_criteria). 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-02-135?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","checked_criteria","met_criteria"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"met_criteria":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"company_group":{"type":"string","default":"","maxLength":80},"checked_criteria":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","met_criteria":1,"company_group":"group-a","checked_criteria":10},{"date":"2026-10-02","row_id":"row-2","met_criteria":2,"company_group":"group-b","checked_criteria":20},{"date":"2026-10-03","row_id":"row-3","met_criteria":3,"company_group":"group-a","checked_criteria":15},{"date":"2026-10-04","row_id":"row-4","met_criteria":4,"company_group":"group-b","checked_criteria":30}],"maxItems":200,"minItems":1},"field":{"enum":["checked_criteria","met_criteria"],"type":"string","default":"checked_criteria"},"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_k2jsrjhofD1RS1Sa4vA10","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 supplier qualification records by a numeric interval on checked_criteria or met_criteria and fills missing values using zero, mean, or median imputation, returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"Filter our supplier qualification records so only rows where checked_criteria is between 0 and 100 are kept, fill any missing checked_criteria values using the median method, and give me the two analytical reports — here are the rows: row-1 group-a 2026-10-01 checked=10 met=1, row-2 group-b 2026-10-02 checked=20 met=2.","exampleUseCases":[{"title":"Procurement team cleans qualification data","prompt":"I have 150 supplier qualification records with some null checked_criteria values — can you filter them to only rows where checked_criteria is between 5 and 500, fill in the missing values using the mean, and give me both reports? Here's the data as a list."},{"title":"Vendor audit with out-of-range score removal","prompt":"For our quarterly vendor audit, filter these supplier qualification rows to keep only those where met_criteria falls between 0 and 50, replace any null met_criteria values with zero, and run the two analytical reports on the cleaned dataset."},{"title":"Analyst imputes missing scores before dashboard export","prompt":"Before we export to the dashboard, take these supplier qualification records and fill any missing checked_criteria nulls using the median, then keep only the rows in the range 10 to 200 — I need both analytical reports back so I can verify the output."}],"resultDescription":"Two analytical reports generated from the supplied rows after applying the numeric interval filter (keeping rows where the selected field falls within [minimum, maximum]) and filling any null values in the target field using the chosen method (zero, mean, or median). Reports cover up to 200 input rows and are computed locally without external lookups.","failureModes":["Input array is empty or exceeds 200 rows — rejected by schema validation","Invalid date format (not YYYY-MM-DD) causes row-level rejection","Minimum value greater than maximum value may produce empty filtered result set","Field value specified is not one of the allowed enum values (checked_criteria, met_criteria)","Method value not in allowed enum (zero, mean, median) causes validation error","row_id missing or blank triggers required-field validation failure","Numeric values outside ±1,000,000,000,000 bounds rejected"],"whenToPreferThis":"Choose this endpoint when you have raw supplier qualification data with nullable numeric fields (checked_criteria or met_criteria) and need both range filtering and missing-value imputation in a single call, returning two bundled analytical reports. It is ideal for pre-processing small-to-medium supplier datasets (up to 200 rows) offline without external dependencies or live lookups. Prefer it over generic analytics tools when you want a fixed-cost ($0.01 USDC per call) deterministic data cleaning step within a procurement or vendor management workflow.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:39:50.843Z","isFirstParty":false,"canonicalSlug":"supplier-qualification-numeric-interval-filter-explicit-missing-value-aec47bda"}