{"uid":"cap_LvFgCwXKcJtQA9FOtY2_G","slug":"partnership-pipeline-exact-row-deduplication-explicit-missing-value-96cc18de","name":"Partnership Pipeline — Exact Row Deduplication + Explicit Missing-Value Fill","description":"Partnership pipeline — Exact row deduplication + Explicit missing-value fill: Exact row deduplication + 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-054?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"}}},"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_Sox9mgcIJU92FaR-4MCB4","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":"Deduplicates exact duplicate rows and fills missing values in partnership pipeline records (qualified_partners, active_partners) for up to 200 rows, returning two independent analytical reports.","exampleAgentPrompt":"Clean up my partnership pipeline data — deduplicate exact duplicate rows and fill any missing qualified_partners values using the median, for these records: row-1 (group-a, 2026-10-01, qualified=10, active=1), row-2 (group-b, 2026-10-02, qualified=20, active=2), row-3 (group-a, 2026-10-01, qualified=10, active=1), row-4 (group-b, 2026-10-03, qualified=null, active=4).","exampleUseCases":[{"title":"Deduplicating partner records before reporting","prompt":"I have 150 rows of partnership pipeline data with some exact duplicates — can you remove the duplicate rows and give me a clean deduplicated dataset? The rows include row_id, company_group, date, qualified_partners, and active_partners fields."},{"title":"Filling missing active partner counts","prompt":"My partnership pipeline export has some null active_partners values across several company groups. Can you fill those missing values using the mean and give me back a clean report? Here are my rows for groups A, B, and C from October 2026."},{"title":"Monthly partner data cleanup before CRM sync","prompt":"Before I sync this month's partner data into our CRM, I need to deduplicate it and fill any missing qualified_partners entries using zero for group-a and group-b records from 2026-10 — can you run both cleanup operations and give me the two reports?"}],"resultDescription":"Returns two independent analytical reports for the supplied partnership pipeline records: (1) an exact row deduplication report identifying and removing fully duplicated rows, and (2) an explicit missing-value fill report where null entries in the specified field (qualified_partners or active_partners) are replaced using the chosen method (zero, mean, or median). Both reports are based entirely on the supplied data with no external lookups.","failureModes":["Exceeds 200-row limit — request rejected","Invalid date format (non YYYY-MM-DD) — validation error","Missing required fields (row_id, company_group, date) — schema validation failure","Invalid fill method enum value — rejected","Numeric values outside allowed range — validation error","Empty rows array — rejected (minItems: 1)"],"whenToPreferThis":"Choose this endpoint when you have partnership pipeline records (with qualified_partners and active_partners columns) that need exact duplicate row removal and/or missing-value imputation in a single call, without requiring any external data lookups or predictions. It is best suited for batch data cleaning of up to 200 rows before downstream analysis or CRM sync, and supports three imputation strategies (zero, mean, median). Prefer it over general-purpose data tools when you want a deterministic, low-cost ($0.01 USDC) cleanup pass specifically scoped to partner pipeline metrics.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T06:40:52.661Z","isFirstParty":false,"canonicalSlug":"partnership-pipeline-exact-row-deduplication-explicit-missing-value-96cc18de"}