# Partnership Pipeline — Exact Row Deduplication + Explicit Missing-Value Fill

> Partnership Pipeline — Exact Row Deduplication + Explicit Missing-Value Fill is a paid API for AI agents from market.datapackvibe.com, paid per call via x402, $0.01/call, status unknown (last checked 2026-10-15).

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.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-company-09-054?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-15
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/partnership-pipeline-exact-row-deduplication-explicit-missing-value-96cc18de
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_LvFgCwXKcJtQA9FOtY2_G

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability partnership-pipeline-exact-row-deduplication-explicit-missing-value-96cc18de -d '<json body>'
```

Example prompt: 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).

## When to prefer this

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.

## Known failure modes

- 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)

## How this service works

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.

## Output

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.

## Request schema (JSON Schema)

```json
{
 "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"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/partnership-pipeline-exact-row-deduplication-explicit-missing-value-96cc18de/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from market.datapackvibe.com](https://www.zero.xyz/host/market.datapackvibe.com/llms.txt)