{"uid":"cap_D4BqmkVBEypRwE9gb2_C6","slug":"camera-coverage-grouped-numeric-summary-with-missing-value-fill-2a7268b4","name":"Camera Coverage Grouped Numeric Summary with Missing-Value Fill","description":"Camera coverage — Grouped numeric summary + Explicit missing-value fill: Grouped numeric summary + Explicit missing-value fill 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-099?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"},"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_qsPJfB2OwtklL-TE0uVrN","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":"Computes grouped numeric summaries (sum, mean, etc.) and fills missing values for camera coverage records (shot_count, coverage_seconds) across up to 200 rows.","exampleAgentPrompt":"I have 150 camera coverage records with asset groups like 'studio-a' and 'outdoor-b', dates in October 2026, and some null shot_count values — can you group them by asset group and summarize the shot_count field, filling any missing values using the median?","exampleUseCases":[{"title":"Film shoot daily coverage rollup","prompt":"I've got 80 rows of daily camera coverage data across three asset groups for a film shoot — can you group them by asset group and give me a numeric summary of coverage_seconds, filling any missing values with the mean?"},{"title":"Null imputation for shot count QA","prompt":"Some of our camera records have null shot_count values and I need them filled using zero before we run our pipeline — can you process these 50 rows and give me both the filled data report and the grouped summary?"},{"title":"Multi-group coverage comparison","prompt":"We tracked shot counts across four asset groups over the past two weeks with some gaps in the data — group the records and summarize the shot_count field using median fill for the missing entries, up to 200 rows."}],"resultDescription":"Returns two analytical reports: (1) a grouped numeric summary of the specified field (shot_count or coverage_seconds) broken down by asset_group, and (2) a missing-value fill report where nulls in the chosen field are replaced using the selected method (zero, mean, or median). Both reports are computed locally on the supplied data with no external lookups.","failureModes":["Input array is empty or exceeds 200 rows — validation error returned","Invalid date format (not YYYY-MM-DD) triggers schema validation failure","Unknown fill method or field enum value causes request rejection","All values in the target field are null, making mean/median fill undefined","Rows missing required fields (row_id, asset_group, date) are rejected","Numeric values outside the allowed range cause validation errors"],"whenToPreferThis":"Choose this endpoint when you have tabular camera coverage data with shot_count or coverage_seconds fields, need grouped aggregate statistics per asset group, and also need null/missing values imputed — all in a single low-cost call. Ideal for media production pipelines, daily coverage QA, or pre-processing steps before downstream analytics. Not suitable for live camera feeds, external data lookup, or prediction tasks.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-17T12:43:24.485Z","isFirstParty":false,"canonicalSlug":"camera-coverage-grouped-numeric-summary-with-missing-value-fill-2a7268b4"}