{"uid":"cap_cHqAa7X7C8D1wfyCLCiG1","slug":"third-party-reviews-numeric-interval-filter-explicit-missing-value-fill-9ab068f1","name":"Third Party Reviews — Numeric Interval Filter + Explicit Missing-Value Fill","description":"Third party reviews — Numeric interval filter + Explicit missing-value fill: Numeric interval filter + Explicit missing-value fill for supplied third party reviews records (vendors_reviewed, outstanding_actions). 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-security-24-135?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","control_group","date","vendors_reviewed","outstanding_actions"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"control_group":{"type":"string","default":"","maxLength":80},"vendors_reviewed":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"outstanding_actions":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","control_group":"group-a","vendors_reviewed":10,"outstanding_actions":1},{"date":"2026-10-02","row_id":"row-2","control_group":"group-b","vendors_reviewed":20,"outstanding_actions":2},{"date":"2026-10-03","row_id":"row-3","control_group":"group-a","vendors_reviewed":15,"outstanding_actions":3},{"date":"2026-10-04","row_id":"row-4","control_group":"group-b","vendors_reviewed":30,"outstanding_actions":4}],"maxItems":200,"minItems":1},"field":{"enum":["vendors_reviewed","outstanding_actions"],"type":"string","default":"vendors_reviewed"},"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_HkSl72Z6TX0-FECmWkSTI","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 third-party review records (vendors_reviewed, outstanding_actions) to a numeric interval and fills missing values using zero, mean, or median imputation; returns up to 2 analytical reports for up to 200 rows.","exampleAgentPrompt":"I have up to 150 rows of third-party review data with some null values in vendors_reviewed — can you filter the records to only keep rows where vendors_reviewed is between 5 and 500, and fill in any missing values using median imputation?","exampleUseCases":[{"title":"Vendor review range cleanup","prompt":"I've got a dataset of third-party vendor reviews with null entries in the vendors_reviewed column — please filter it to rows between 10 and 200 and replace any nulls with the median so I can work with clean data."},{"title":"Outstanding actions zero-fill report","prompt":"My review tracking spreadsheet has missing outstanding_actions values for some rows — can you fill those nulls with zero and filter out any records outside the range of 0 to 50?"},{"title":"Dual-field audit report for review records","prompt":"I need two analytical reports on my third-party review records: one filtering vendors_reviewed between 0 and 100 with mean imputation, and one filtering outstanding_actions with the same settings — can you run both?"}],"resultDescription":"Returns up to 2 analytical reports on the supplied third-party review records, with rows filtered to the specified numeric interval [minimum, maximum] and null values in the chosen field replaced using the selected imputation method (zero, mean, or median). Reports cover up to 200 input rows and are generated entirely from the supplied data using local analytical engines with no external lookups.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, date, vendors_reviewed, outstanding_actions) in one or more rows — validation error","Invalid date format (must match YYYY-MM-DD) — schema rejection","Minimum value greater than maximum value — undefined or empty filter result","All values null with mean/median imputation on empty set — possible NaN or error output","Payment of 0.01 USDC not completed — request blocked by x402 paywall"],"whenToPreferThis":"Choose this endpoint when you have a batch of up to 200 third-party vendor review records and need both numeric range filtering and missing-value imputation in a single call. It is specifically suited for vendors_reviewed and outstanding_actions fields. Prefer this over general ETL tools when you want a lightweight, pay-per-use analytical report without setting up infrastructure, and when you need two reports from a shared local engine in one request.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T18:50:44.529Z","isFirstParty":false,"canonicalSlug":"third-party-reviews-numeric-interval-filter-explicit-missing-value-fill-9ab068f1"}