{"uid":"cap_SZTvS8YeGkebSCPt7qiYE","slug":"transformation-throughput-analytics-exact-row-deduplication-secondary-20349267","name":"Transformation Throughput Analytics — Exact Row Deduplication + Secondary-Measure Weighted Mean","description":"Transformation throughput — Exact row deduplication + Secondary-measure weighted mean: Exact row deduplication + Secondary-measure weighted mean for supplied transformation throughput records (processed_rows, duration_seconds). 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-13-051?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","processed_rows","duration_seconds"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"dataset_group":{"type":"string","default":"","maxLength":80},"processed_rows":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"duration_seconds":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","dataset_group":"group-a","processed_rows":10,"duration_seconds":1},{"date":"2026-10-02","row_id":"row-2","dataset_group":"group-b","processed_rows":20,"duration_seconds":2},{"date":"2026-10-03","row_id":"row-3","dataset_group":"group-a","processed_rows":15,"duration_seconds":3},{"date":"2026-10-04","row_id":"row-4","dataset_group":"group-b","processed_rows":30,"duration_seconds":4}],"maxItems":200,"minItems":1},"field":{"enum":["processed_rows","duration_seconds"],"type":"string","default":"processed_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_LhF67viA-dF7kiWCVrFFt","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 transformation throughput records and computes a secondary-measure weighted mean on processed_rows and duration_seconds data, returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"Can you deduplicate these transformation throughput records and compute the weighted mean for processed_rows? I have 50 rows across two dataset groups with row IDs, dates, processed_rows, and duration_seconds — I need both the deduplication report and the weighted average.","exampleUseCases":[{"title":"ETL pipeline performance deduplication","prompt":"I have 120 ETL job records with row IDs, dates, dataset groups, processed_rows, and duration_seconds, and I suspect there are duplicates. Can you deduplicate them and compute the weighted mean for processed_rows so I can get a clean performance summary?"},{"title":"Data warehouse throughput audit","prompt":"Deduplicate my 80 transformation throughput records and give me the secondary-measure weighted mean for duration_seconds — here are the rows with their row IDs, dates, and dataset groups."},{"title":"Batch processing metrics rollup","prompt":"I need to clean up these 150 pipeline throughput records by removing exact duplicates, then compute a weighted mean on processed_rows. The data has row IDs, dates, dataset_group labels, processed_rows counts, and duration_seconds values."}],"resultDescription":"Returns two analytical reports: (1) a deduplicated set of transformation throughput records with exact duplicate rows removed, and (2) a secondary-measure weighted mean computed over the specified field (processed_rows or duration_seconds), both derived from the supplied input data using local analytical engines without any external lookups.","failureModes":["Input exceeds 200 rows — request rejected","Missing required fields (row_id, date, dataset_group, processed_rows, duration_seconds) — validation error","Invalid date format (must be YYYY-MM-DD) — schema validation failure","Numeric values outside allowed range (-1e12 to 1e12) — rejected","Empty rows array — minimum 1 item required","All rows are null for the selected field — weighted mean may be undefined"],"whenToPreferThis":"Choose this endpoint when you need both exact row deduplication and a secondary-measure weighted mean computed together in a single call on transformation throughput data (processed_rows, duration_seconds). Ideal for ETL pipeline audits, data engineering reporting, and batch processing analytics where you have up to 200 structured throughput records and need two distinct analytical outputs at very low cost ($0.01 USDC per call). Not suitable for live data lookups, predictions, or datasets exceeding 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:47:05.708Z","isFirstParty":false,"canonicalSlug":"transformation-throughput-analytics-exact-row-deduplication-secondary-20349267"}