{"uid":"cap_Wa1ShFxZPPsKZZnHkHlt1","slug":"duplicate-observations-analytics-duplicate-key-report-two-measure-17a1a183","name":"Duplicate Observations Analytics — Duplicate Key Report + Two-Measure Correlation","description":"Duplicate observations — Duplicate key report + Two-measure correlation: Duplicate key report + Two-measure correlation 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-066?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}}},"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_zD-HyNRKl_YHxrkBTokmP","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 rows of duplicate observation records to produce a duplicate key report and a two-measure correlation analysis between duplicate_rows and total_rows.","exampleAgentPrompt":"Run a duplicate key report and two-measure correlation on my dataset observations — I have 4 rows: group-a on 2026-10-01 with 10 duplicate rows out of 1 total, group-b on 2026-10-02 with 20 duplicates out of 2 total, group-a on 2026-10-03 with 15 duplicates out of 3 total, and group-b on 2026-10-04 with 30 duplicates out of 4 total.","exampleUseCases":[{"title":"Data pipeline deduplication audit","prompt":"I need a duplicate key report and correlation analysis for my ETL pipeline data — here are 5 dataset groups with their duplicate_rows and total_rows counts per day from last week. Tell me which groups have the worst duplication and whether duplicate count correlates with total size."},{"title":"Cross-group duplicate pattern comparison","prompt":"Analyze these 50 observation records across 3 dataset groups — I want to see a duplicate key report showing which row IDs have duplicate issues, plus a correlation between duplicate_rows and total_rows to see if larger datasets tend to have more duplicates."},{"title":"Monthly data quality summary report","prompt":"Generate a duplicate key report and two-measure correlation for my 150 rows of monthly data quality observations from January through June — each row has a date, a dataset group, duplicate row count, and total row count. I want to understand the duplication trend."}],"resultDescription":"Returns two analytical reports: (1) a duplicate key report identifying duplicate key occurrences and patterns within the supplied row data, and (2) a two-measure correlation analysis between the duplicate_rows and total_rows fields across the supplied records — all computed locally against the submitted data without external lookups.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) cause validation errors","Date field not matching YYYY-MM-DD pattern causes schema rejection","Payment of 0.01 USDC not attached or not processed via x402 protocol","Null values in duplicate_rows or total_rows may affect correlation computation"],"whenToPreferThis":"Choose this endpoint when you need both a duplicate key diagnostic report AND a statistical correlation between two numeric measures (duplicate_rows vs total_rows) in a single low-cost call. Best suited for data quality pipelines, ETL audits, or dataset health checks where up to 200 rows of grouped, dated observations are already available locally and no external data enrichment or live lookup is needed.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T07:19:41.635Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-analytics-duplicate-key-report-two-measure-17a1a183"}