{"uid":"cap_oTZFDBsyWDnFXnNJQFFo4","slug":"partnership-pipeline-keyed-dataset-comparison-with-missing-value-fill-8b35ac66","name":"Partnership Pipeline Keyed Dataset Comparison with Missing Value Fill","description":"Partnership pipeline — Keyed dataset comparison + Explicit missing-value fill: Keyed dataset comparison + 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-190?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"},"other":{"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":21},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","active_partners":3,"qualified_partners":17},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","active_partners":4,"qualified_partners":33}],"maxItems":200,"minItems":0},"method":{"enum":["zero","mean","median"],"type":"string","default":"median"}}},"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_Qtu0BrxDFp7e1EWpxXIJS","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":"Compares two keyed partnership datasets (qualified_partners vs active_partners) and fills in explicit missing values, producing two analytical reports for up to 200 rows.","exampleAgentPrompt":"Compare my two partnership pipeline datasets for Q4 — rows with company groups 'group-a' and 'group-b' from 2026-10-01 through 2026-10-04 — and fill in any missing values for the qualified_partners field. I have up to 8 rows split between a primary and comparison set.","exampleUseCases":[{"title":"Quarterly partner pipeline reconciliation","prompt":"I have two snapshots of our partner pipeline from last quarter — a primary set and a reference set — each with company group, date, and counts for qualified and active partners. Can you compare them row by row and fill any nulls in the qualified_partners column?"},{"title":"Multi-group active partner gap analysis","prompt":"Run a keyed comparison on these two datasets for 'group-a' and 'group-b' partnership records and flag any rows where active_partners is missing, then fill those gaps so I can see the complete picture."},{"title":"Monthly partnership data audit across divisions","prompt":"I need to audit our partnership pipeline for October — here are two sets of records, up to 50 rows each, with qualified and active partner numbers by division. Compare them and produce two reports showing where values are missing and what the filled values should be."}],"resultDescription":"Two independent analytical reports: one keyed dataset comparison identifying differences between the two supplied partnership record sets, and one explicit missing-value fill report replacing nulls in the selected field (qualified_partners or active_partners) for up to 200 rows. Results are computed locally from supplied data with no external lookups.","failureModes":["Missing required fields (row_id, company_group, date, qualified_partners, active_partners) cause validation errors","Exceeding 200 rows in either dataset returns an error","Invalid date format (not YYYY-MM-DD) triggers schema validation failure","Invalid field selector (not 'qualified_partners' or 'active_partners') causes rejection","Empty rows array returns an error","Numeric values outside ±1,000,000,000,000 are rejected","Payment of 0.01 USDC must be included or request is rejected"],"whenToPreferThis":"Choose this endpoint when you need to compare two keyed partnership pipeline datasets (qualified_partners and active_partners) and simultaneously fill missing values, all from supplied data without any external lookups or live data sources. It is ideal for offline audits, reconciliation workflows, and data quality checks on partner records segmented by company group and date. Prefer it over generic data tools when you specifically need two simultaneous reports from a single call on partnership-domain data up to 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:39:41.540Z","isFirstParty":false,"canonicalSlug":"partnership-pipeline-keyed-dataset-comparison-with-missing-value-fill-8b35ac66"}