{"uid":"cap_2vu6u6u7BbNqROER6kM-L","slug":"duplicate-observations-analytics-two-measure-correlation-date-by-ff662b6f","name":"Duplicate Observations Analytics: Two-Measure Correlation + Date-by-Category Pivot","description":"Duplicate observations — Two-measure correlation + Date by category pivot: Two-measure correlation + Date by category pivot 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-182?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"}}},"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_hxky309xnLH6BgkDwbfKl","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 local analytical reports on duplicate-observation records: a correlation between duplicate_rows and total_rows, plus a date-by-category pivot table, for up to 200 rows.","exampleAgentPrompt":"I have up to 200 duplicate observation records with fields row_id, dataset_group, date, duplicate_rows, and total_rows — can you run a two-measure correlation between duplicate_rows and total_rows AND generate a date-by-category pivot for my dataset groups?","exampleUseCases":[{"title":"Data quality audit across pipeline stages","prompt":"I've got 150 records from our ETL pipeline audit, each with a dataset_group, date, duplicate_rows, and total_rows — please run the correlation between duplicate_rows and total_rows, and pivot the duplicate counts by date and group so I can see where duplicates are clustering."},{"title":"Monthly deduplication trend review","prompt":"Here are my monthly deduplication logs for groups 'group-a' and 'group-b' from October 2026 — analyze the correlation between total_rows and duplicate_rows, and give me a date-by-category pivot to spot which month and group had the worst duplicate rate."},{"title":"Dataset group comparison for duplicate spikes","prompt":"I have 80 records across three dataset groups with dates and duplicate counts — run both the two-measure correlation report and the date-by-category pivot on duplicate_rows so I can compare duplicate spikes across groups over time."}],"resultDescription":"Returns two independent analytical reports: (1) a Pearson or equivalent correlation result between the duplicate_rows and total_rows measures across supplied records, and (2) a pivot table crossing dates against dataset_group categories showing aggregated duplicate observation values — all computed locally with no external lookups, covering up to 200 input rows.","failureModes":["Fewer than 1 row submitted returns a validation error","More than 200 rows submitted exceeds the row limit and is rejected","Missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) cause schema validation failure","Invalid date format (not YYYY-MM-DD) triggers pattern mismatch error","Null values in both numeric fields may degrade or break correlation computation","Payment of 0.01 USDC must be included; missing payment returns a 402 response"],"whenToPreferThis":"Choose this endpoint when you need both a statistical correlation between two data-quality measures (duplicate_rows vs total_rows) AND a date-by-category pivot in a single low-cost call on up to 200 rows. It is ideal for data quality workflows, ETL audits, or deduplication monitoring where you want two complementary views of the same dataset without external data access or predictions.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T07:19:33.252Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-analytics-two-measure-correlation-date-by-ff662b6f"}