{"uid":"cap_PQC7m2t7KAJU8Fp_3bpwl","slug":"time-series-completeness-exact-row-deduplication-grouped-numeric-e9c81b14","name":"Time Series Completeness — Exact Row Deduplication + Grouped Numeric Summary","description":"Time series completeness — Exact row deduplication + Grouped numeric summary: Exact row deduplication + Grouped numeric summary for supplied time series completeness records (observed_points, expected_points). 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-analytics-16-040?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","observed_points","expected_points"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"dataset_group":{"type":"string","default":"","maxLength":80},"expected_points":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"observed_points":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","dataset_group":"group-a","expected_points":1,"observed_points":10},{"date":"2026-10-02","row_id":"row-2","dataset_group":"group-b","expected_points":2,"observed_points":20},{"date":"2026-10-03","row_id":"row-3","dataset_group":"group-a","expected_points":3,"observed_points":15},{"date":"2026-10-04","row_id":"row-4","dataset_group":"group-b","expected_points":4,"observed_points":30}],"maxItems":200,"minItems":1},"field":{"enum":["observed_points","expected_points"],"type":"string","default":"observed_points"}}},"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_xLG3q0PRy_imHquUXZ7cY","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 rows and produces grouped numeric summary statistics for time series completeness records (observed_points, expected_points) across up to 200 rows.","exampleAgentPrompt":"I have up to 200 rows of time series completeness records with observed_points and expected_points per date and dataset_group — can you deduplicate exact duplicate rows and give me a grouped numeric summary of the observed_points field across all groups?","exampleUseCases":[{"title":"Daily completeness audit by pipeline group","prompt":"I've got completeness records for my data pipelines — each row has a date, a dataset_group like 'sales' or 'inventory', and the observed vs expected point counts. Can you deduplicate any exact duplicate rows and then give me a grouped numeric summary of observed_points broken down by dataset_group?"},{"title":"Identifying data gaps in sensor feeds","prompt":"Here are 150 rows of completeness logs for our sensor feeds, each with a date, group name, observed_points, and expected_points. Run exact deduplication on them and summarize the expected_points field by group so I can see where we have coverage gaps."},{"title":"QA check on ingestion completeness reports","prompt":"Before we archive these completeness reports, I want to make sure there are no exact duplicate entries and get a quick grouped numeric summary of observed_points by dataset_group — can you process these rows for me?"}],"resultDescription":"Returns two analytical reports: (1) an exact row deduplication report identifying and removing duplicate entries from the submitted rows, and (2) a grouped numeric summary of the chosen field (observed_points or expected_points) aggregated by dataset_group, including descriptive statistics such as counts, totals, and averages per group.","failureModes":["Exceeding 200 rows results in rejection or truncation","Missing required fields (row_id, dataset_group, date, observed_points, expected_points) causes validation errors","Invalid date format (non-YYYY-MM-DD) triggers schema validation failure","Numeric values outside the allowed range (-1e12 to 1e12) are rejected","Submitting fewer than 1 row causes a minItems validation error"],"whenToPreferThis":"Choose this endpoint when you need both exact duplicate row removal and grouped numeric summaries for time series completeness data in a single call at minimal cost ($0.01 USDC for both reports). It is ideal for data quality pipelines that track observed vs expected data point counts across groups and dates, and need lightweight local analytics without any external lookups or predictions.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-28T19:42:30.220Z","isFirstParty":false,"canonicalSlug":"time-series-completeness-exact-row-deduplication-grouped-numeric-e9c81b14"}