{"uid":"cap_808BUyr9oJdb7E27obeEZ","slug":"business-location-inventories-duplicate-key-report-explicit-missing-774e58a1","name":"Business Location Inventories — Duplicate Key Report + Explicit Missing-Value Fill","description":"Business location inventories — Duplicate key report + Explicit missing-value fill: Duplicate key report + Explicit missing-value fill for supplied business location inventories records (location_count, verified_locations). 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-05-070?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","location_count","verified_locations"],"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},"location_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"verified_locations":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_group":"group-a","location_count":10,"verified_locations":1},{"date":"2026-10-02","row_id":"row-2","company_group":"group-b","location_count":20,"verified_locations":2},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","location_count":15,"verified_locations":3},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","location_count":30,"verified_locations":4}],"maxItems":200,"minItems":1},"field":{"enum":["location_count","verified_locations"],"type":"string","default":"location_count"},"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_Xx_Mij-EnbflJZFhAVsl6","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 rows of business location inventory data to produce two reports: a duplicate key report and an explicit missing-value fill for location_count or verified_locations fields.","exampleAgentPrompt":"Can you run a duplicate key report and fill in any missing location_count values using the median across these business location inventory rows I'm uploading — I have about 50 rows with company_group, date, location_count, and verified_locations columns?","exampleUseCases":[{"title":"Cleaning multi-group location inventory data","prompt":"I have 120 rows of location inventory records across several company groups with some missing location_count values — can you find any duplicate row IDs and fill the blanks using the mean?"},{"title":"Auditing franchise location data before reporting","prompt":"Before I submit this quarter's location report, can you check these 80 franchise location records for duplicate keys and replace any null verified_locations entries with zero?"},{"title":"Preparing location data for dashboard ingestion","prompt":"I need to prep these 200 business location rows for our dashboard — run a duplicate key check and fill missing location_count fields using the median so the data is clean going in."}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying rows with repeated key values among the supplied records, and (2) an explicit missing-value fill report where null or missing values in the selected field (location_count or verified_locations) are replaced using the chosen method (zero, mean, or median). No external lookups or predictions are made; all analysis is performed locally on the supplied data.","failureModes":["Fewer than 1 row supplied — request rejected","More than 200 rows supplied — exceeds row limit, request rejected","Invalid date format (not YYYY-MM-DD) — schema validation error","row_id missing or empty — required field validation error","Invalid fill method or field enum value — schema validation error","Numeric values outside allowed range (±1,000,000,000,000) — validation error"],"whenToPreferThis":"Choose this endpoint when you need both duplicate detection and missing-value imputation on business location inventory data (location_count, verified_locations) in a single paid call. It is ideal for data cleaning pipelines where you want offline, deterministic analysis on up to 200 rows without any external API lookups or live data enrichment. Prefer this over general-purpose data tools when you need a structured two-report output covering deduplication and fill in one transaction at $0.01 USDC.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:46:32.084Z","isFirstParty":false,"canonicalSlug":"business-location-inventories-duplicate-key-report-explicit-missing-774e58a1"}