{"uid":"cap_m0XlTWjqAsVbAbw6CkVsv","slug":"duplicate-observations-analytics-grouped-summary-dataset-comparison-2fc5dc5d","name":"Duplicate Observations Analytics: Grouped Summary + Dataset Comparison","description":"Duplicate observations — Grouped numeric summary + Keyed dataset comparison: Grouped numeric summary + 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-098?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_feW_L-Eh70rX6EvbqS5qm","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":"Runs two offline analytical reports on duplicate_rows/total_rows data: a grouped numeric summary and a keyed dataset comparison between two supplied datasets (up to 200 rows each).","exampleAgentPrompt":"Can you run a grouped numeric summary and a keyed dataset comparison on my duplicate observation data? I have two datasets of up to 50 rows each, with fields row_id, dataset_group, date, duplicate_rows, and total_rows — focus the analysis on the duplicate_rows field.","exampleUseCases":[{"title":"ETL pipeline duplicate rate audit","prompt":"I have two ETL run snapshots with up to 100 rows each, tracking duplicate_rows and total_rows by dataset_group and date. Can you give me a grouped numeric summary across groups and then compare the two runs row by row to see where duplicate counts changed?"},{"title":"Data quality report by dataset group","prompt":"Run a grouped numeric summary on this set of 80 duplicate observation records — I want to see the stats broken down by dataset_group using the duplicate_rows field, and also compare it against last week's snapshot with the same row keys."},{"title":"Cross-team dataset deduplication comparison","prompt":"We have two teams each submitting duplicate observation logs (about 60 rows each) with the same row_id keys. Can you analyze the total_rows field with a grouped summary and then do a keyed comparison between the two team datasets to spot discrepancies?"}],"resultDescription":"Returns two independent analytical reports: (1) a grouped numeric summary aggregating duplicate_rows or total_rows statistics by dataset_group, and (2) a keyed dataset comparison matching records by row_id across the primary and secondary datasets to highlight differences. No external lookups or predictions are made; all analysis uses locally supplied data.","failureModes":["Input array exceeds 200 rows — request will be rejected or truncated","Missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) cause validation errors","Invalid date format (not YYYY-MM-DD) fails schema validation","Null numeric values may affect aggregation results in the summary report","Non-matching row_ids between primary and secondary datasets reduce keyed comparison coverage","Both rows arrays must each individually comply with the 200-row limit"],"whenToPreferThis":"Choose this endpoint when you have already-collected duplicate observation records (with duplicate_rows and total_rows counts) and need both a grouped statistical summary across dataset groups and a direct row-keyed comparison between two datasets in a single paid call. Ideal for data quality monitoring, ETL audit workflows, or comparing deduplication results across pipeline runs. Not suitable when you need live data fetching, predictions, or more than 200 rows per dataset.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-18T00:57:57.397Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-analytics-grouped-summary-dataset-comparison-2fc5dc5d"}