{"uid":"cap_J4UXL1gp-lCSSiH-2TPTZ","slug":"partnership-pipeline-numeric-interval-filter-explicit-missing-value-68af652e","name":"Partnership Pipeline — Numeric Interval Filter + Explicit Missing-Value Fill","description":"Partnership pipeline — Numeric interval filter + Explicit missing-value fill: Numeric interval filter + Explicit missing-value fill for supplied partnership pipeline records (qualified_partners, active_partners). 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-09-135?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","qualified_partners","active_partners"],"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},"active_partners":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"qualified_partners":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_group":"group-a","active_partners":1,"qualified_partners":10},{"date":"2026-10-02","row_id":"row-2","company_group":"group-b","active_partners":2,"qualified_partners":20},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","active_partners":3,"qualified_partners":15},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","active_partners":4,"qualified_partners":30}],"maxItems":200,"minItems":1},"field":{"enum":["qualified_partners","active_partners"],"type":"string","default":"qualified_partners"},"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_29F5Yq8-fa1t0hW_GHh22","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 partnership pipeline records (qualified_partners, active_partners) to a numeric interval and fills missing values using zero, mean, or median imputation — returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"I have partner pipeline data for groups A and B across October — can you filter the qualified_partners column to only values between 0 and 50, and fill any missing values using median imputation? Here are up to 200 rows with row_id, company_group, date, qualified_partners, and active_partners.","exampleUseCases":[{"title":"Cleaning null partner counts before reporting","prompt":"I've got a CSV of partnership records with some null active_partners values — can you fill those nulls using the mean and also filter the column to only rows between 1 and 500? I have about 150 rows with row_id, company_group, and date fields."},{"title":"Filtering outlier qualified partners from pipeline","prompt":"Some of our qualified_partners numbers look way off — can you filter out anything outside the range 5 to 200 and fill any missing entries with zero? I'll send you the full 200-row dataset with company groups and dates."},{"title":"Preparing partner data for dashboard ingestion","prompt":"Before we push our partnership pipeline data to the dashboard, can you run both an interval filter (min 0, max 1000) and a median fill on the active_partners field? We have about 80 rows across multiple company groups."}],"resultDescription":"Returns two analytical reports derived from the supplied rows: one applying the numeric interval filter (keeping only rows where the selected field falls within [minimum, maximum]) and one applying explicit missing-value imputation (replacing nulls in the selected field using zero, mean, or median). Both reports operate on the same submitted dataset of up to 200 rows using local analytical engines with no external lookups.","failureModes":["Rows array is empty or exceeds 200 items — validation error","date field does not match YYYY-MM-DD pattern — schema rejection","minimum greater than maximum — may produce empty filtered result set","field enum value not recognized — schema rejection","method enum value not one of zero/mean/median — schema rejection","numeric values outside ±1,000,000,000,000 bounds — schema rejection","Payment not fulfilled via x402 protocol — request blocked"],"whenToPreferThis":"Choose this endpoint when you have up to 200 partnership pipeline records (with qualified_partners and/or active_partners columns) and need both range-based outlier filtering and null imputation in a single paid call. It is purpose-built for partner data with company_group and date dimensions, and delivers two independent reports cheaply ($0.01 USDC). Prefer alternatives if you need live data lookup, predictive modeling, more than 200 rows, or fields beyond qualified_partners and active_partners.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:40:10.120Z","isFirstParty":false,"canonicalSlug":"partnership-pipeline-numeric-interval-filter-explicit-missing-value-68af652e"}