# Commercial Proposal Comparisons — Date×Category Pivot + Missing-Value Fill

> Commercial Proposal Comparisons — 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-17).

Pivots commercial proposal data by date and company category, then fills missing values, returning two analytical reports for up to 200 rows of quoted_amount or delivery_days data.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-company-24-189?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-17
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/commercial-proposal-comparisons-date-category-pivot-missing-value-fill-4ef1fd0a
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_zl6prO43l5GaNQAdfdoOX

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 commercial-proposal-comparisons-date-category-pivot-missing-value-fill-4ef1fd0a -d '<json body>'
```

Example prompt: I have 150 rows of commercial proposal data with company groups and dates — can you pivot it so rows are dates and columns are company categories, filling any missing quoted_amount values using the median, and give me both the pivot table and the filled dataset?

## When to prefer this

Choose this endpoint when you need to reshape commercial proposal or procurement comparison data into a date-by-category matrix and simultaneously handle missing values in a single paid call. It is purpose-built for quoted_amount and delivery_days fields and delivers two reports for $0.01 USDC with no external data lookup — ideal for offline batch analytical workflows on supplier bid datasets up to 200 rows.

## Known failure modes

- Input exceeds 200 rows — request will be rejected
- Missing required fields (row_id, company_group, date, quoted_amount, delivery_days) — validation error
- Date strings not in YYYY-MM-DD format — pattern validation failure
- Numeric values outside allowed range (±1,000,000,000,000) — schema rejection
- Empty rows array — minItems violation

## How this service works

Commercial proposal comparisons — Date by category pivot + Explicit missing-value fill: Date by category pivot + Explicit missing-value fill for supplied commercial proposal comparisons records (quoted_amount, delivery_days). 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

Two analytical reports: (1) a date-by-category pivot table of the selected field (quoted_amount or delivery_days) with rows as dates and columns as company groups, and (2) the same dataset with missing values explicitly filled using the chosen method (zero, mean, or median). 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",
     "quoted_amount",
     "delivery_days"
    ],
    "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
     },
     "delivery_days": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     },
     "quoted_amount": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     }
    },
    "additionalProperties": false
   },
   "default": [
    {
     "date": "2026-10-01",
     "row_id": "row-1",
     "company_group": "group-a",
     "delivery_days": 1,
     "quoted_amount": 10
    },
    {
     "date": "2026-10-02",
     "row_id": "row-2",
     "company_group": "group-b",
     "delivery_days": 2,
     "quoted_amount": 20
    },
    {
     "date": "2026-10-03",
     "row_id": "row-3",
     "company_group": "group-a",
     "delivery_days": 3,
     "quoted_amount": 15
    },
    {
     "date": "2026-10-04",
     "row_id": "row-4",
     "company_group": "group-b",
     "delivery_days": 4,
     "quoted_amount": 30
    }
   ],
   "maxItems": 200,
   "minItems": 1
  },
  "field": {
   "enum": [
    "quoted_amount",
    "delivery_days"
   ],
   "type": "string",
   "default": "quoted_amount"
  },
  "method": {
   "enum": [
    "zero",
    "mean",
    "median"
   ],
   "type": "string",
   "default": "median"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/commercial-proposal-comparisons-date-category-pivot-missing-value-fill-4ef1fd0a/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)