# Company Headcount Observations — Exact Row Deduplication + Explicit Missing-Value Fill

> Company Headcount Observations — 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-19).

Deduplicates exact rows and fills missing headcount or open_roles values in company headcount observation records using zero, mean, or median imputation.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-company-12-054?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-19
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/company-headcount-observations-exact-row-deduplication-explicit-fdaf93fd
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_u2LcKnBf8Ou6Cq9jSIOBm

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-headcount-observations-exact-row-deduplication-explicit-fdaf93fd -d '<json body>'
```

Example prompt: I have a list of up to 50 company headcount observations with some duplicate rows and missing headcount values — can you deduplicate them exactly and fill in the missing headcount numbers using the median?

## When to prefer this

Choose this endpoint when you have up to 200 company headcount or open_roles observation records that need exact duplicate removal and/or missing-value imputation in a single low-cost call. Ideal for lightweight data cleaning pipelines prior to analytics or reporting, where no external data lookup or prediction is needed and results must be reproducible from the supplied data alone.

## Known failure modes

- Input exceeds 200 rows — request rejected
- Invalid date format (non-YYYY-MM-DD) causes row rejection
- Missing required fields (row_id, company_group, date) causes validation error
- Invalid method enum value causes error
- Invalid field enum value causes error
- Empty rows array rejected (minItems: 1)

## How this service works

Company headcount observations — Exact row deduplication + Explicit missing-value fill: Exact row deduplication + Explicit missing-value fill for supplied company headcount observations records (headcount, open_roles). 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 covering: (1) exact duplicate row removal from the supplied headcount observations, and (2) explicit imputation of missing values in the specified field (headcount or open_roles) using the chosen method (zero, mean, or median). Results are based solely 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",
     "headcount",
     "open_roles"
    ],
    "properties": {
     "date": {
      "type": "string",
      "default": "",
      "pattern": "^\\d{4}-\\d{2}-\\d{2}$",
      "maxLength": 10
     },
     "row_id": {
      "type": "string",
      "default": "",
      "maxLength": 80,
      "minLength": 1
     },
     "headcount": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     },
     "open_roles": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     },
     "company_group": {
      "type": "string",
      "default": "",
      "maxLength": 80
     }
    },
    "additionalProperties": false
   },
   "default": [
    {
     "date": "2026-10-01",
     "row_id": "row-1",
     "headcount": 10,
     "open_roles": 1,
     "company_group": "group-a"
    },
    {
     "date": "2026-10-02",
     "row_id": "row-2",
     "headcount": 20,
     "open_roles": 2,
     "company_group": "group-b"
    },
    {
     "date": "2026-10-03",
     "row_id": "row-3",
     "headcount": 15,
     "open_roles": 3,
     "company_group": "group-a"
    },
    {
     "date": "2026-10-04",
     "row_id": "row-4",
     "headcount": 30,
     "open_roles": 4,
     "company_group": "group-b"
    }
   ],
   "maxItems": 200,
   "minItems": 1
  },
  "field": {
   "enum": [
    "headcount",
    "open_roles"
   ],
   "type": "string",
   "default": "headcount"
  },
  "method": {
   "enum": [
    "zero",
    "mean",
    "median"
   ],
   "type": "string",
   "default": "median"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/company-headcount-observations-exact-row-deduplication-explicit-fdaf93fd/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)