{"uid":"cap_ZVupe0eSLsXjM0KR8qoDZ","slug":"duplicate-observations-daily-sum-series-keyed-dataset-comparison-63d45d98","name":"Duplicate Observations — Daily Sum Series + Keyed Dataset Comparison","description":"Duplicate observations — Daily sum series + Keyed dataset comparison: Daily sum series + Keyed dataset comparison for supplied duplicate observations records (duplicate_rows, total_rows). 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-04-144?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","duplicate_rows","total_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"total_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"duplicate_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","total_rows":1,"dataset_group":"group-a","duplicate_rows":10},{"date":"2026-10-02","row_id":"row-2","total_rows":2,"dataset_group":"group-b","duplicate_rows":20},{"date":"2026-10-03","row_id":"row-3","total_rows":3,"dataset_group":"group-a","duplicate_rows":15},{"date":"2026-10-04","row_id":"row-4","total_rows":4,"dataset_group":"group-b","duplicate_rows":30}],"maxItems":200,"minItems":1},"field":{"enum":["duplicate_rows","total_rows"],"type":"string","default":"duplicate_rows"},"other":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","duplicate_rows","total_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"total_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"duplicate_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","total_rows":1,"dataset_group":"group-a","duplicate_rows":10},{"date":"2026-10-02","row_id":"row-2","total_rows":2,"dataset_group":"group-b","duplicate_rows":21},{"date":"2026-10-03","row_id":"row-3","total_rows":3,"dataset_group":"group-a","duplicate_rows":17},{"date":"2026-10-04","row_id":"row-4","total_rows":4,"dataset_group":"group-b","duplicate_rows":33}],"maxItems":200,"minItems":0}}},"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_yxLgG-2kQdbg_WMlgVbg_","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 duplicate observation records by generating a daily sum time series and a keyed dataset comparison report for up to 200 rows of supplied data.","exampleAgentPrompt":"I have two sets of duplicate observation records (up to 200 rows each) with date, row_id, dataset_group, duplicate_rows, and total_rows fields — can you run a daily sum series and a keyed dataset comparison on the duplicate_rows field for both datasets?","exampleUseCases":[{"title":"Daily duplicate trend audit","prompt":"I have 150 records from our data pipeline with fields date, row_id, dataset_group, duplicate_rows, and total_rows — please generate a daily sum time series and a keyed comparison against our reference dataset for the duplicate_rows field so I can spot which days had the most duplication."},{"title":"Cross-dataset duplication discrepancy check","prompt":"We have two versions of our dataset — the original and a reprocessed version — both with row_id, date, dataset_group, duplicate_rows, and total_rows. Can you compare them using a keyed dataset comparison on total_rows and also show me a daily sum series to see where counts diverge?"},{"title":"Data quality monitoring for ETL outputs","prompt":"Our ETL job produces daily logs of duplicate_rows and total_rows per dataset_group. I want to upload two batches of up to 200 rows each and get back a daily sum series plus a side-by-side keyed comparison of duplicate_rows between this week's run and last week's."}],"resultDescription":"Returns two independent analytical reports: (1) a daily sum series aggregating the selected field (duplicate_rows or total_rows) by date across the supplied records, and (2) a keyed dataset comparison report showing differences between the primary rows dataset and the secondary other dataset, matched by row_id. Both reports are computed locally with no external lookups.","failureModes":["Fewer than 1 row supplied — rejected by minItems constraint","More than 200 rows supplied — rejected by maxItems constraint","Missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) — validation error","Date values not matching YYYY-MM-DD format — pattern validation failure","row_id exceeding 80 characters — field length validation error","field enum value not one of 'duplicate_rows' or 'total_rows' — rejected","Numeric values outside ±1,000,000,000,000 range — rejected","Payment not fulfilled — 402 Payment Required response"],"whenToPreferThis":"Choose this endpoint when you need both a daily aggregated time series and a row-keyed comparison between two datasets of duplicate observation records in a single call at minimal cost ($0.01 USDC for both reports). Ideal for data quality auditing pipelines where you want to track duplication trends over time and simultaneously diff two versions of the same dataset without relying on external data sources or live lookups.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T07:19:31.141Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-daily-sum-series-keyed-dataset-comparison-63d45d98"}