{"uid":"cap_CBjqCGq15W4af5vPFfXdk","slug":"time-series-completeness-exact-row-deduplication-category-frequencies-9b40c5cf","name":"Time Series Completeness — Exact Row Deduplication + Category Frequencies","description":"Time series completeness — Exact row deduplication + Category frequencies: Exact row deduplication + Category frequencies 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-041?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}}},"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_sIKBuls13fAr1HSJVnHoZ","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 time series completeness records (observed vs expected data points) by deduplicating exact duplicate rows and computing category frequencies across dataset groups, returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"Can you deduplicate and compute category frequencies for my time series completeness records? I have rows with row_id, dataset_group, date, observed_points, and expected_points — here are my entries: row-1 for group-a on 2026-10-01 with 10 observed and 1 expected, row-2 for group-b on 2026-10-02 with 20 observed and 2 expected, and row-1 for group-a on 2026-10-01 with 10 observed and 1 expected (a duplicate).","exampleUseCases":[{"title":"Audit pipeline completeness logs for duplicates","prompt":"I have 150 rows from my daily data pipeline completeness log — each row has a row_id, dataset_group, date, observed_points, and expected_points. Can you deduplicate exact repeated rows and also tell me the frequency of each dataset group across all records?"},{"title":"Compare group coverage in sensor data","prompt":"I'm tracking sensor data completeness across three sensor groups over the past quarter. I have up to 180 rows with observed and expected point counts per day per group. Please run exact row deduplication and give me category frequency counts by dataset_group."},{"title":"Clean ETL completeness records before reporting","prompt":"Before I finalize my weekly ETL report, I need to strip exact duplicate rows from my completeness data and see how many entries belong to each dataset group. Can you run the deduplication and frequency analysis on my 90 rows of observed vs expected point counts?"}],"resultDescription":"Returns two independent analytical reports: (1) an exact row deduplication report identifying and removing fully duplicate rows from the submitted completeness records, and (2) a category frequency report showing how often each dataset_group value appears across the submitted rows — all computed locally against the supplied data with no external lookups.","failureModes":["Fewer than 1 row submitted — validation error","More than 200 rows submitted — rejected, exceeds max item limit","Missing required fields (row_id, dataset_group, date, observed_points, expected_points) — schema validation failure","Malformed date format (not YYYY-MM-DD) — pattern validation error","observed_points or expected_points outside allowed numeric range — validation error","Payment not provided or insufficient — 402 payment required"],"whenToPreferThis":"Choose this endpoint when you need two specific analyses on time series completeness data in a single call: exact duplicate row detection/removal and category frequency distribution by dataset group. Ideal for data quality audits, ETL validation pipelines, or completeness reporting workflows where you have up to 200 rows of observed vs expected point counts keyed by date and group. Prefer this over general-purpose analytics tools when you want a lightweight, paid-per-call micro-service that combines both deduplication and frequency reporting without requiring infrastructure setup.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-28T19:42:27.820Z","isFirstParty":false,"canonicalSlug":"time-series-completeness-exact-row-deduplication-category-frequencies-9b40c5cf"}