{"uid":"cap_8HBWWwgrFQhCzprR99050","slug":"duplicate-observations-iqr-outlier-flags-secondary-measure-weighted-f0301243","name":"Duplicate Observations IQR Outlier Flags + Secondary-Measure Weighted Mean","description":"Duplicate observations — IQR outlier flags + Secondary-measure weighted mean: IQR outlier flags + Secondary-measure weighted mean 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-177?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_LHPdSx6cQjjVJAPiXuJUN","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 to produce IQR-based outlier flags and a secondary-measure weighted mean across up to 200 rows in two independent reports.","exampleAgentPrompt":"Can you run IQR outlier flagging and a weighted mean report on my duplicate observation data? I have 4 rows: group-a had 10 duplicates out of 1 total on 2026-10-01, group-b had 20 out of 2 on 2026-10-02, group-a had 15 out of 3 on 2026-10-03, and group-b had 30 out of 4 on 2026-10-04 — analyze the duplicate_rows field.","exampleUseCases":[{"title":"Data pipeline duplicate audit","prompt":"I have a list of dataset partitions with their duplicate row counts and total rows recorded daily — can you flag any outlier duplicate counts using IQR and also give me a weighted mean for the duplicate_rows field? Here are 8 rows across two groups covering last week."},{"title":"ETL quality check for multiple groups","prompt":"We ran an ETL job across dataset groups alpha and beta over the past 5 days and tracked duplicate_rows and total_rows per run. Can you give me two reports: IQR outlier flags and a secondary-measure weighted mean on the duplicate_rows column so I can see which runs were anomalous?"},{"title":"Monitoring deduplication health over time","prompt":"I'm tracking deduplication health across my data warehouse — here are 50 daily records with duplicate_rows and total_rows per dataset group. Please flag IQR outliers and compute the weighted mean for total_rows so I can spot degradation trends."}],"resultDescription":"Returns two independent analytical reports: (1) IQR outlier flags identifying which rows have anomalous values in the selected field (duplicate_rows or total_rows) based on interquartile range analysis, and (2) a secondary-measure weighted mean computed across the supplied rows. Both reports are generated locally from the supplied data with no external lookups.","failureModes":["Fewer than 1 row supplied — request rejected","More than 200 rows supplied — exceeds maximum batch limit","Missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) — validation error","Invalid date format (not YYYY-MM-DD) — schema validation failure","Non-numeric values in duplicate_rows or total_rows where numbers are required — type error","Payment of 0.01 USDC not included or failed — 402 Payment Required"],"whenToPreferThis":"Choose this endpoint when you need both IQR-based outlier detection and a weighted mean computed together on duplicate observation records in a single paid call. It is well-suited for data quality workflows where you want to identify anomalous duplication counts across dated, grouped rows without sending data to an external model or live service. Prefer it over general statistics APIs when your data is specifically structured as duplicate_rows/total_rows per dataset group and you need two complementary reports for under $0.01.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-18T00:57:55.043Z","isFirstParty":false,"canonicalSlug":"duplicate-observations-iqr-outlier-flags-secondary-measure-weighted-f0301243"}