{"uid":"cap_fWCFixyG35YO2QHghLeIL","slug":"time-series-completeness-exact-row-deduplication-adjacent-row-changes-dcdf9ade","name":"Time Series Completeness — Exact Row Deduplication + Adjacent Row Changes","description":"Time series completeness — Exact row deduplication + Adjacent row changes: Exact row deduplication + Adjacent row changes 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-046?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_USTQAq_eZtrCCtWAgzaYJ","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 time series completeness records to produce two reports: exact duplicate row detection and adjacent-row change detection for observed_points or expected_points.","exampleAgentPrompt":"Can you run exact row deduplication and adjacent row change detection on my completeness data? I have rows with row_id, dataset_group, date, observed_points, and expected_points — up to about 50 rows — and I want to analyze the observed_points field.","exampleUseCases":[{"title":"Audit duplicate completeness records","prompt":"I have a time series completeness log with row_id, date, dataset_group, observed_points, and expected_points for the past 30 days — can you run exact row deduplication on it to find any repeated entries and also show me where adjacent rows changed in the observed_points field?"},{"title":"Day-over-day change tracking for sensor data","prompt":"Here's my sensor completeness dataset with observed_points and expected_points across multiple dataset groups — can you detect where consecutive rows show changes in expected_points and also flag any exact duplicate rows?"},{"title":"Data quality check before pipeline ingestion","prompt":"Before I ingest this completeness time series into our pipeline, can you run the deduplication and adjacent-change reports on the observed_points field? I'll provide the rows with row_id, dataset_group, date, observed_points, and expected_points — about 120 rows total."}],"resultDescription":"Two analytical reports: (1) an exact row deduplication report identifying rows with identical field values across the supplied records, and (2) an adjacent row change report highlighting where consecutive rows differ in the selected field (observed_points or expected_points). Both reports are computed locally from supplied data with no external lookups.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, dataset_group, date, observed_points, expected_points) causes rejection","Invalid date format (not YYYY-MM-DD) triggers a pattern validation error","Numeric values outside the allowed range cause schema validation failure","Empty rows array (minItems:1 not met) results in an error"],"whenToPreferThis":"Choose this endpoint when you need simultaneous exact-duplicate detection and adjacent-row change analysis on a time series completeness dataset of up to 200 rows, at a fixed cost of $0.01 USDC for both reports together. It is ideal for data quality audits, pipeline pre-ingestion checks, or monitoring completeness logs where both deduplication and change detection are needed in one call without any external dependencies or live lookups.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T12:38:53.302Z","isFirstParty":false,"canonicalSlug":"time-series-completeness-exact-row-deduplication-adjacent-row-changes-dcdf9ade"}