# Join Coverage Analytics: Category Frequencies + Missing-Value Fill

> Join Coverage Analytics: Category Frequencies + 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).

Analyzes join coverage records (matched_rows, source_rows) by computing category frequencies and filling missing values using zero, mean, or median imputation — returns 2 analytical reports for up to 200 rows.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-09-112?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/join-coverage-analytics-category-frequencies-missing-value-fill-e8b17758
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_AQkq5RjZm62obfjzkMtiZ

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 join-coverage-analytics-category-frequencies-missing-value-fill-e8b17758 -d '<json body>'
```

Example prompt: Analyze my join coverage data — I have up to 50 rows with matched_rows and source_rows fields grouped by dataset category — give me category frequencies and fill any missing matched_rows values using median imputation.

## When to prefer this

Choose this endpoint when you need both category frequency profiling AND missing-value imputation for join coverage data (matched_rows, source_rows) in a single $0.01 call covering up to 200 rows. Prefer it over separate analytics tools when you want two coordinated reports on the same dataset without external data lookups or live API calls. Ideal for lightweight, local, deterministic analysis of dataset join quality metrics.

## Known failure modes

- Rows array empty or missing — minItems:1 required
- More than 200 rows submitted — maxItems limit exceeded
- Invalid date format — must match YYYY-MM-DD pattern
- row_id missing or empty — minLength:1 required
- Invalid field enum value — must be 'matched_rows' or 'source_rows'
- Invalid method enum — must be 'zero', 'mean', or 'median'
- Numeric values out of range (±1,000,000,000,000)
- Payment failure — 0.01 USDC x402 payment required

## How this service works

Join coverage — Category frequencies + Explicit missing-value fill: Category frequencies + Explicit missing-value fill for supplied join coverage records (matched_rows, source_rows). 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 category frequency distribution showing how often each dataset_group value appears across the supplied rows, and (2) a missing-value fill report for the selected field (matched_rows or source_rows) where nulls are replaced using the chosen method (zero, mean, or median). Results are computed locally with no external lookups.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "rows": {
   "type": "array",
   "items": {
    "type": "object",
    "required": [
     "row_id",
     "dataset_group",
     "date",
     "matched_rows",
     "source_rows"
    ],
    "properties": {
     "date": {
      "type": "string",
      "default": "",
      "pattern": "^\\d{4}-\\d{2}-\\d{2}$",
      "maxLength": 10
     },
     "row_id": {
      "type": "string",
      "default": "",
      "maxLength": 80,
      "minLength": 1
     },
     "source_rows": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     },
     "matched_rows": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     },
     "dataset_group": {
      "type": "string",
      "default": "",
      "maxLength": 80
     }
    },
    "additionalProperties": false
   },
   "default": [
    {
     "date": "2026-10-01",
     "row_id": "row-1",
     "source_rows": 1,
     "matched_rows": 10,
     "dataset_group": "group-a"
    },
    {
     "date": "2026-10-02",
     "row_id": "row-2",
     "source_rows": 2,
     "matched_rows": 20,
     "dataset_group": "group-b"
    },
    {
     "date": "2026-10-03",
     "row_id": "row-3",
     "source_rows": 3,
     "matched_rows": 15,
     "dataset_group": "group-a"
    },
    {
     "date": "2026-10-04",
     "row_id": "row-4",
     "source_rows": 4,
     "matched_rows": 30,
     "dataset_group": "group-b"
    }
   ],
   "maxItems": 200,
   "minItems": 1
  },
  "field": {
   "enum": [
    "matched_rows",
    "source_rows"
   ],
   "type": "string",
   "default": "matched_rows"
  },
  "method": {
   "enum": [
    "zero",
    "mean",
    "median"
   ],
   "type": "string",
   "default": "median"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/join-coverage-analytics-category-frequencies-missing-value-fill-e8b17758/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)