{"uid":"cap_MmAvc9-b5lDiiBGONWBUh","slug":"pipeline-durations-deduplication-and-iqr-outlier-analysis-4fb27871","name":"Pipeline Durations Deduplication and IQR Outlier Analysis","description":"Pipeline durations — Exact row deduplication + IQR outlier flags: Exact row deduplication + IQR outlier flags for supplied pipeline durations records (run_seconds, processed_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-05-049?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","run_seconds","processed_rows"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"run_seconds":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"processed_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","run_seconds":10,"dataset_group":"group-a","processed_rows":1},{"date":"2026-10-02","row_id":"row-2","run_seconds":20,"dataset_group":"group-b","processed_rows":2},{"date":"2026-10-03","row_id":"row-3","run_seconds":15,"dataset_group":"group-a","processed_rows":3},{"date":"2026-10-04","row_id":"row-4","run_seconds":30,"dataset_group":"group-b","processed_rows":4}],"maxItems":200,"minItems":1},"field":{"enum":["run_seconds","processed_rows"],"type":"string","default":"run_seconds"}}},"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_tgpUD9Z1Em--_VpO8XjUE","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":"Deduplicates exact-duplicate rows and flags IQR-based outliers in pipeline duration records (run_seconds and processed_rows), returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"Can you check my pipeline duration records for exact duplicate rows and flag any IQR outliers in the run_seconds field? I have about 50 rows with row_id, dataset_group, date, run_seconds, and processed_rows columns.","exampleUseCases":[{"title":"ETL pipeline data quality audit","prompt":"I have 120 rows of ETL pipeline logs with run_seconds and processed_rows. Can you deduplicate any exact duplicate rows and flag statistical outliers in run_seconds using IQR so I can clean up the dataset before reporting?"},{"title":"Detecting anomalous batch job durations","prompt":"My batch processing logs have about 80 records with dates, dataset groups, and run times in seconds. Can you find any duplicate entries and flag which runs look like outliers based on their run_seconds values using IQR analysis?"},{"title":"Processed row count outlier detection","prompt":"I want to check my pipeline data for duplicate records and find any unusual processed_rows counts — can you run both an exact deduplication and an IQR outlier check on the processed_rows field across my 150 pipeline run records?"}],"resultDescription":"Returns two analytical reports: (1) an exact row deduplication report identifying which rows are duplicates across all five fields, and (2) an IQR outlier flagging report identifying which rows have run_seconds or processed_rows values that fall outside the interquartile range bounds, all computed locally without external lookups.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, date, run_seconds, processed_rows, dataset_group) cause validation errors","Invalid date format (not YYYY-MM-DD) causes schema rejection","All-null numeric field values may produce empty or degenerate IQR results","Single-row input may produce trivial or undefined IQR statistics","Payment failure or insufficient USDC balance prevents processing"],"whenToPreferThis":"Choose this endpoint when you need a combined, affordable ($0.01) data quality pass on pipeline duration records — specifically exact deduplication plus IQR-based outlier detection — without needing external data, predictions, or professional assessments. Ideal for agents that need to pre-process ETL logs or pipeline performance data before downstream reporting or dashboarding. Not suitable if you need ML-based anomaly detection, real-time streaming analysis, or more than 200 rows per call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T12:38:58.705Z","isFirstParty":false,"canonicalSlug":"pipeline-durations-deduplication-and-iqr-outlier-analysis-4fb27871"}