{"uid":"cap_VNLpMyGD-fgVkDuS7MuqX","slug":"commercial-proposal-comparisons-numeric-interval-filter-missing-value-88d56fe7","name":"Commercial Proposal Comparisons — Numeric Interval Filter + Missing-Value Fill","description":"Commercial proposal comparisons — Numeric interval filter + Explicit missing-value fill: Numeric interval filter + Explicit missing-value fill for supplied commercial proposal comparisons records (quoted_amount, delivery_days). 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-24-135?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","quoted_amount","delivery_days"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"company_group":{"type":"string","default":"","maxLength":80},"delivery_days":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"quoted_amount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_group":"group-a","delivery_days":1,"quoted_amount":10},{"date":"2026-10-02","row_id":"row-2","company_group":"group-b","delivery_days":2,"quoted_amount":20},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","delivery_days":3,"quoted_amount":15},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","delivery_days":4,"quoted_amount":30}],"maxItems":200,"minItems":1},"field":{"enum":["quoted_amount","delivery_days"],"type":"string","default":"quoted_amount"},"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_HbJVEh3XsH9WP5wBxNmA1","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 commercial proposal comparison rows by a numeric range and fills missing values in quoted_amount or delivery_days fields, producing two analytical reports for up to 200 rows.","exampleAgentPrompt":"I have 150 vendor proposal rows with quoted_amount and delivery_days — some values are missing. Can you filter proposals where quoted_amount is between 500 and 5000, and fill any missing quoted_amount values using the median? Run both the interval filter and the missing-value fill reports on this data.","exampleUseCases":[{"title":"Clean and filter RFP bids by budget range","prompt":"I've got 80 rows of RFP responses with quoted_amount and delivery_days. Some quoted amounts are null. Can you filter proposals where quoted_amount falls between 1000 and 8000, and fill the missing quoted_amount values using the mean? I need both reports."},{"title":"Normalize delivery days across supplier proposals","prompt":"Here are 120 supplier proposal rows — some delivery_days entries are blank. Please fill in missing delivery_days using the median, and also filter to only keep rows where delivery_days is between 5 and 30. Give me both the interval filter and fill reports."},{"title":"Prepare vendor quote data for procurement review","prompt":"I'm comparing 60 vendor quotes and a few quoted_amount fields are missing. Run your interval filter to keep only quotes between 200 and 3000, and zero-fill any missing quoted_amount values so I can do a clean comparison. I need both analytical reports."}],"resultDescription":"Returns two reports: one showing rows passing the numeric interval filter (where the selected field falls within the specified minimum and maximum bounds), and one showing the dataset with missing values in the chosen field replaced by the specified fill method (zero, mean, or median). Up to 200 input rows are supported per call.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id) cause validation errors","Invalid date format (not YYYY-MM-DD) causes schema rejection","Minimum greater than maximum produces empty filtered result set","Unsupported fill method enum value causes error","No rows with missing values results in unchanged fill report"],"whenToPreferThis":"Choose this endpoint when you need to simultaneously filter commercial proposal comparison records by a numeric range AND impute missing numeric values in quoted_amount or delivery_days fields, getting both results in a single API call for up to 200 rows. It is ideal for lightweight, local data cleaning and preparation steps in procurement workflows where no external data, live lookups, or predictions are required.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-17T12:43:29.404Z","isFirstParty":false,"canonicalSlug":"commercial-proposal-comparisons-numeric-interval-filter-missing-value-88d56fe7"}