# Water Service Coverage Data Cleaner — Deduplication & Missing-Value Fill

> Water Service Coverage Data Cleaner — Deduplication & 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-29).

Deduplicates exact duplicate rows and fills missing values in water service coverage datasets (served_households, total_households) using zero, mean, or median imputation.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-economics-19-054?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-29
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/water-service-coverage-data-cleaner-deduplication-missing-value-fill-1e07dc9b
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_FnfGcL0ukhOuIM1fg7bhG

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 water-service-coverage-data-cleaner-deduplication-missing-value-fill-1e07dc9b -d '<json body>'
```

Example prompt: I have a water service coverage dataset with up to 150 rows — each row has a row_id, region, date, served_households, and total_households — and some rows are exact duplicates and some served_households values are null. Can you deduplicate the rows and fill missing served_households values using median imputation?

## When to prefer this

Choose this endpoint when you have tabular water service coverage data (served_households, total_households) that needs both exact duplicate row removal and null value imputation in a single call, for up to 200 rows, at very low cost ($0.01 USDC). It operates entirely on supplied data with no external API calls, making it suitable for sensitive or offline datasets. Prefer alternatives if you need predictive modeling, live data lookup, professional assessment, or datasets larger than 200 rows.

## Known failure modes

- Rows exceeding 200 items will be rejected (maxItems constraint)
- Missing required fields (row_id, region, date, served_households, total_households) cause validation failure
- Dates not matching YYYY-MM-DD pattern are rejected
- region or row_id strings exceeding 80 characters are rejected
- Numeric values outside ±1,000,000,000,000 are rejected
- Payment of 0.01 USDC must be provided via x402 protocol or request is rejected

## How this service works

Water service coverage — Exact row deduplication + Explicit missing-value fill: Exact row deduplication + Explicit missing-value fill for supplied water service coverage records (served_households, total_households). 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 for the submitted dataset: one covering exact row deduplication results (identifying and removing fully duplicate rows) and one covering explicit missing-value fill (replacing null values in the specified field with the chosen imputation method — zero, mean, or median). Both reports are generated from the supplied data using local analytical engines with no external lookups.

## Request schema (JSON Schema)

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

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/water-service-coverage-data-cleaner-deduplication-missing-value-fill-1e07dc9b/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)