{"uid":"cap_FnfGcL0ukhOuIM1fg7bhG","slug":"water-service-coverage-data-cleaner-deduplication-missing-value-fill-1e07dc9b","name":"Water Service Coverage Data Cleaner — Deduplication & Missing-Value Fill","description":"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.","url":"https://market.datapackvibe.com/x402/assistant-ib26-economics-19-054?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"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"}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_ZEl-2MJ4KbB2RsvtedLMl","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Deduplicates exact duplicate rows and fills missing values in water service coverage datasets (served_households, total_households) using zero, mean, or median imputation.","exampleAgentPrompt":"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?","exampleUseCases":[{"title":"Municipal water access report prep","prompt":"I'm preparing a water access report and my dataset of 120 rows has duplicate entries and some null served_households values. Can you remove the exact duplicate rows and fill the missing served_households using median imputation so the data is clean for analysis?"},{"title":"Utility coverage data quality fix","prompt":"Our water utility tracking spreadsheet has rows where total_households is missing and there are duplicate records for some regions. Please deduplicate the data and fill in missing total_households values using mean imputation — I have about 80 rows total."},{"title":"NGO household coverage data cleanup","prompt":"We collected water service coverage data across 12 regions over 6 months and ended up with duplicate rows and zero-fill needed for any null served_households entries. Can you clean this up — remove exact duplicates and fill missing served_households with zero — across all 200 rows?"}],"resultDescription":"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.","failureModes":["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"],"whenToPreferThis":"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.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-29T12:53:20.729Z","isFirstParty":false,"canonicalSlug":"water-service-coverage-data-cleaner-deduplication-missing-value-fill-1e07dc9b"}