# Contract Renewal Inventories — Date×Category Pivot + Missing-Value Fill

> Contract Renewal Inventories — Date×Category Pivot + 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-20).

Pivots contract renewal inventory data (expiring and renewed contracts) by date and category, then fills missing values using zero, mean, or median imputation — returning two analytical reports for up to 200 rows.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-company-20-189?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-20
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/contract-renewal-inventories-date-category-pivot-missing-value-fill-ff5e159f
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_uoUKQY4FYymCoC3_vX2Qi

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 contract-renewal-inventories-date-category-pivot-missing-value-fill-ff5e159f -d '<json body>'
```

Example prompt: I have a set of contract renewal records with company groups like 'group-a' and 'group-b', dates, and expiring/renewed contract counts — some values are missing. Can you pivot this data by date and category for the expiring_contracts field, filling in the blanks using median imputation, and give me the two analytical reports?

## When to prefer this

Choose this endpoint when you have pre-collected contract renewal inventory records and need a structured pivot by date and company group, plus explicit missing-value imputation, all in a single low-cost call. It is ideal for offline or batch analytical workflows where no live data lookup, prediction, or external enrichment is needed. Best suited for datasets up to 200 rows needing two complementary views of the same data.

## Known failure modes

- Missing required fields (row_id, date, company_group) cause row rejection or validation error
- Dates not matching YYYY-MM-DD pattern are rejected
- More than 200 rows submitted exceeds the row limit and may be truncated or rejected
- Invalid enum values for field (must be expiring_contracts or renewed_contracts) or method (must be zero, mean, median) cause request failure
- Empty rows array returns an error
- Numeric values outside ±1,000,000,000,000 are rejected

## How this service works

Contract renewal inventories — Date by category pivot + Explicit missing-value fill: Date by category pivot + Explicit missing-value fill for supplied contract renewal inventories records (expiring_contracts, renewed_contracts). 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 derived from the supplied contract renewal rows: (1) a date-by-category pivot table for the selected field (expiring_contracts or renewed_contracts), and (2) a version of that same data with missing values explicitly filled using the chosen method (zero, mean, or median). All processing is local with no external lookups. Covers up to 200 input rows.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "rows": {
   "type": "array",
   "items": {
    "type": "object",
    "required": [
     "row_id",
     "company_group",
     "date",
     "expiring_contracts",
     "renewed_contracts"
    ],
    "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
     },
     "renewed_contracts": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     },
     "expiring_contracts": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     }
    },
    "additionalProperties": false
   },
   "default": [
    {
     "date": "2026-10-01",
     "row_id": "row-1",
     "company_group": "group-a",
     "renewed_contracts": 1,
     "expiring_contracts": 10
    },
    {
     "date": "2026-10-02",
     "row_id": "row-2",
     "company_group": "group-b",
     "renewed_contracts": 2,
     "expiring_contracts": 20
    },
    {
     "date": "2026-10-03",
     "row_id": "row-3",
     "company_group": "group-a",
     "renewed_contracts": 3,
     "expiring_contracts": 15
    },
    {
     "date": "2026-10-04",
     "row_id": "row-4",
     "company_group": "group-b",
     "renewed_contracts": 4,
     "expiring_contracts": 30
    }
   ],
   "maxItems": 200,
   "minItems": 1
  },
  "field": {
   "enum": [
    "expiring_contracts",
    "renewed_contracts"
   ],
   "type": "string",
   "default": "expiring_contracts"
  },
  "method": {
   "enum": [
    "zero",
    "mean",
    "median"
   ],
   "type": "string",
   "default": "median"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/contract-renewal-inventories-date-category-pivot-missing-value-fill-ff5e159f/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)