{"uid":"cap_560QkoucPllfSLqbwSgZM","slug":"business-directory-coverage-duplicate-key-report-explicit-missing-a88a37d9","name":"Business Directory Coverage — Duplicate Key Report + Explicit Missing-Value Fill","description":"Business directory coverage — Duplicate key report + Explicit missing-value fill: Duplicate key report + Explicit missing-value fill for supplied business directory coverage records (listed_entities, verified_entities). 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-company-14-070?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","listed_entities","verified_entities"],"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},"listed_entities":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"verified_entities":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_group":"group-a","listed_entities":10,"verified_entities":1},{"date":"2026-10-02","row_id":"row-2","company_group":"group-b","listed_entities":20,"verified_entities":2},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","listed_entities":15,"verified_entities":3},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","listed_entities":30,"verified_entities":4}],"maxItems":200,"minItems":1},"field":{"enum":["listed_entities","verified_entities"],"type":"string","default":"listed_entities"},"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_YU1QNMQW7Zy5jpkHZtmaf","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":"Analyzes up to 200 business directory coverage rows to produce a duplicate key report and fill missing values in listed_entities or verified_entities using zero, mean, or median imputation.","exampleAgentPrompt":"Can you run a duplicate key report and fill any missing listed_entities values using median imputation on these business directory coverage rows: row-1 for group-a on 2026-10-01 with listed_entities=10 and verified_entities=1, row-2 for group-b on 2026-10-02 with listed_entities=null and verified_entities=2, row-3 for group-a on 2026-10-01 with listed_entities=15 and verified_entities=3?","exampleUseCases":[{"title":"Audit directory coverage for duplicate entries","prompt":"I have 150 rows of business directory coverage data with company_group and date fields — can you run a duplicate key report to find any rows that share the same row_id or date/company_group combination?"},{"title":"Fill missing verified entity counts with mean","prompt":"My business directory dataset has some null verified_entities values across about 80 rows — please fill those missing values using mean imputation and give me the corrected dataset."},{"title":"Validate and clean coverage data before reporting","prompt":"Before I send this business directory coverage report to the team, can you check for duplicate keys and replace any missing listed_entities values with zero across these 120 rows?"}],"resultDescription":"Returns two independent reports: (1) a duplicate key report identifying rows with repeated row_id or matching key combinations, and (2) a missing-value fill report showing the original nulls replaced by the chosen imputation method (zero, mean, or median) for the specified field (listed_entities or verified_entities). No external data is fetched; all analysis uses local analytical engines on the supplied rows.","failureModes":["Fewer than 1 or more than 200 rows submitted returns a validation error","Invalid date format (not YYYY-MM-DD) causes schema rejection","Non-numeric or out-of-range values for listed_entities or verified_entities trigger validation failure","Unsupported imputation method or field enum value causes a 400-level error","Empty rows array or missing required fields (row_id, company_group, date) result in rejection"],"whenToPreferThis":"Choose this endpoint when you have business directory coverage data (with listed_entities and verified_entities fields) and need both a duplicate key audit and missing-value imputation in a single low-cost call. It is ideal for lightweight, offline data cleaning on batches up to 200 rows where no live lookup or external enrichment is required. Prefer this over generic data tools when you specifically need the dual-report format (duplicates + fill) on directory coverage data with the built-in zero/mean/median imputation options.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T12:48:36.595Z","isFirstParty":false,"canonicalSlug":"business-directory-coverage-duplicate-key-report-explicit-missing-a88a37d9"}