{"uid":"cap_hSamP0NLJHmcbg5U9Oumt","slug":"duplicate-observations-iqr-outlier-flags-and-keyed-dataset-comparison-e053dcb4","name":"Duplicate Observations IQR Outlier Flags and Keyed Dataset Comparison","description":"Duplicate observations — IQR outlier flags + Keyed dataset comparison: IQR outlier flags + 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-179?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_v-37zfY8ysPuMAE9e1VEi","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: IQR-based outlier detection and a keyed comparison between two supplied datasets, for up to 200 rows.","exampleAgentPrompt":"Can you run IQR outlier flagging and a keyed dataset comparison on my duplicate observation data? I have two sets of up to 50 rows each with duplicate_rows and total_rows counts per group, and I want to analyze the duplicate_rows field.","exampleUseCases":[{"title":"Flagging Anomalous Duplicate Counts in ETL Pipeline","prompt":"I've got daily duplicate_rows and total_rows counts from my ETL pipeline across two dataset groups for the past month — can you flag any outliers using IQR and also compare this month's data against last month's keyed by row_id? Analyze the duplicate_rows field."},{"title":"Data Quality Audit Across Two Dataset Versions","prompt":"We just re-processed a dataset and I want to compare the duplicate_rows counts before and after, keyed by row_id, and also flag any rows where the duplicate count is statistically unusual using IQR. Both datasets have about 80 rows each."},{"title":"Monitoring Duplicate Rate Spikes by Group","prompt":"Here are two batches of records — each with a dataset_group, date, duplicate_rows, and total_rows — can you run IQR outlier detection on the duplicate_rows field and give me a keyed comparison between the two batches so I can see which groups diverged?"}],"resultDescription":"Returns two independent analytical reports: (1) IQR outlier flags identifying which rows have duplicate_rows or total_rows values outside the interquartile range, and (2) a keyed dataset comparison highlighting differences between the primary and secondary supplied datasets, matched by row_id. All computation is performed locally with no external lookups.","failureModes":["Fewer than 1 row provided — validation error","More than 200 rows submitted — rejected, maxItems limit exceeded","Missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) — schema validation failure","Invalid date format (not YYYY-MM-DD) — pattern validation error","Non-numeric values in duplicate_rows or total_rows — type error","Insufficient data variance for meaningful IQR computation — may return degenerate outlier results","Payment not included or insufficient — x402 payment required error"],"whenToPreferThis":"Choose this endpoint when you have pre-collected duplicate observation records (up to 200 rows) and need both IQR-based outlier detection and a keyed cross-dataset comparison in a single call. It is best suited for data quality workflows, ETL monitoring, and dataset auditing where you supply your own data and need local statistical analysis without external lookups or predictions. Prefer it over single-report endpoints when you need both outlier flags and a comparison simultaneously at a low cost ($0.01 USDC for both reports).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T07:19:33.251Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-iqr-outlier-flags-and-keyed-dataset-comparison-e053dcb4"}