# Company Filing Inventories — Date-by-Category Pivot + Missing-Value Fill

> Company Filing Inventories — Date-by-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 company filing inventory data (available_filings, expected_filings) by date and category, and 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-17-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/company-filing-inventories-date-by-category-pivot-missing-value-fill-77abaa29
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_Ab5GuLQFbae7NyzHydd6K

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 company-filing-inventories-date-by-category-pivot-missing-value-fill-77abaa29 -d '<json body>'
```

Example prompt: Take my company filing inventory rows — each has a row_id, company_group, date, available_filings, and expected_filings — and give me a date-by-category pivot table plus fill any missing available_filings values using the median method.

## When to prefer this

Choose this endpoint when you have pre-collected company filing inventory records (available_filings and/or expected_filings) in row format and need both a date-by-category pivot transformation and missing-value imputation in a single call, without any live data fetching or external API dependencies. It is best suited for offline analytical preparation of tabular datasets up to 200 rows where reproducibility and local computation matter.

## Known failure modes

- Fewer than 1 row or more than 200 rows submitted — request rejected
- Invalid date format (not YYYY-MM-DD) causes row-level validation failure
- Field value outside ±1,000,000,000,000 range rejected by schema
- Missing required fields (row_id, company_group, date) cause processing errors
- Unknown fill method or field enum value causes parameter rejection
- Payment not included or insufficient USDC causes x402 payment-required error

## How this service works

Company filing inventories — Date by category pivot + Explicit missing-value fill: Date by category pivot + Explicit missing-value fill for supplied company filing inventories records (available_filings, expected_filings). 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 analytical reports: (1) a date-by-category pivot table showing the selected field (available_filings or expected_filings) broken down by date rows and company_group columns, and (2) the same dataset with missing values explicitly filled using the chosen method (zero, mean, or median). Both reports are computed locally without any external data lookup.

## Request schema (JSON Schema)

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

## More

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