{"uid":"cap_aoWhOSqilRpRaUmEG05jI","slug":"camera-coverage-exact-deduplication-and-weighted-mean-28fceafe","name":"Camera Coverage Exact Deduplication and Weighted Mean","description":"Camera coverage — Exact row deduplication + Secondary-measure weighted mean: Exact row deduplication + Secondary-measure weighted mean for supplied camera coverage records (shot_count, coverage_seconds). 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-creative-12-051?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","asset_group","date","shot_count","coverage_seconds"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"shot_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"asset_group":{"type":"string","default":"","maxLength":80},"coverage_seconds":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","shot_count":10,"asset_group":"group-a","coverage_seconds":1},{"date":"2026-10-02","row_id":"row-2","shot_count":20,"asset_group":"group-b","coverage_seconds":2},{"date":"2026-10-03","row_id":"row-3","shot_count":15,"asset_group":"group-a","coverage_seconds":3},{"date":"2026-10-04","row_id":"row-4","shot_count":30,"asset_group":"group-b","coverage_seconds":4}],"maxItems":200,"minItems":1},"field":{"enum":["shot_count","coverage_seconds"],"type":"string","default":"shot_count"}}},"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_4Japd5W0FYtBNh2evp7Wk","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 camera coverage records by exact row matching and computes a secondary-measure weighted mean for shot_count or coverage_seconds across up to 200 rows.","exampleAgentPrompt":"I have a set of camera coverage records with shot counts and coverage seconds for different asset groups — can you deduplicate exact duplicate rows and compute the weighted mean of shot_count across up to 4 rows: row-1 on 2026-10-01 group-a shot_count 10 coverage_seconds 1, row-2 on 2026-10-02 group-b shot_count 20 coverage_seconds 2, row-3 on 2026-10-03 group-a shot_count 15 coverage_seconds 3, row-4 on 2026-10-04 group-b shot_count 30 coverage_seconds 4?","exampleUseCases":[{"title":"Cleaning duplicate footage log entries","prompt":"I have a camera shot log with possible exact duplicate rows across asset groups — can you run exact deduplication and give me a weighted mean of coverage_seconds for these records: row-1 2026-10-01 group-a shot_count 10 coverage_seconds 60, row-2 2026-10-01 group-a shot_count 10 coverage_seconds 60, row-3 2026-10-02 group-b shot_count 25 coverage_seconds 120?"},{"title":"Weighted shot count summary per asset group","prompt":"For these camera coverage records across two asset groups, please deduplicate any exact duplicate rows and then compute the weighted mean of shot_count: row-1 2026-11-01 group-alpha shot_count 50 coverage_seconds 300, row-2 2026-11-02 group-alpha shot_count 80 coverage_seconds 400, row-3 2026-11-03 group-beta shot_count 30 coverage_seconds 150."},{"title":"Auditing production camera data quality","prompt":"We're auditing our production camera coverage dataset for exact duplicates and need a weighted mean report on coverage_seconds — here are 5 rows: row-1 2026-09-01 group-x shot_count 12 coverage_seconds 90, row-2 2026-09-02 group-x shot_count 18 coverage_seconds 120, row-3 2026-09-02 group-x shot_count 18 coverage_seconds 120, row-4 2026-09-03 group-y shot_count 22 coverage_seconds 200, row-5 2026-09-04 group-y shot_count 35 coverage_seconds 250."}],"resultDescription":"Returns two independent analytical reports: (1) an exact row deduplication report listing which rows are duplicates and the deduplicated dataset, and (2) a secondary-measure weighted mean computation for the selected field (shot_count or coverage_seconds) across the supplied rows. All analysis is performed locally without external lookups.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, asset_group, date, shot_count, coverage_seconds) causes request rejection","Invalid date format (not YYYY-MM-DD) fails schema validation","Numeric values outside the allowed range (-1e12 to 1e12) are rejected","Invalid field enum value (not shot_count or coverage_seconds) causes an error","Empty rows array is rejected due to minItems:1 constraint"],"whenToPreferThis":"Choose this endpoint when you have up to 200 camera coverage records and need both exact duplicate row removal and a weighted mean computation in a single call without any external lookups or live data. It is ideal for batch data quality and aggregation tasks on camera shot or coverage data where you need two structured analytical reports cheaply at $0.01 USDC.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-17T12:42:25.817Z","isFirstParty":false,"canonicalSlug":"camera-coverage-exact-deduplication-and-weighted-mean-28fceafe"}