{"uid":"cap_g0ynMTN-yL6rNYaLcnxXT","slug":"transformation-throughput-analytics-exact-row-deduplication-two-c3f4cea3","name":"Transformation Throughput Analytics: Exact Row Deduplication + Two-Measure Correlation","description":"Transformation throughput — Exact row deduplication + Two-measure correlation: Exact row deduplication + Two-measure correlation 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-050?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}}},"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_gSlZay87bMy0Yo0LaqFhr","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 rows and computes a correlation between processed_rows and duration_seconds for up to 200 transformation throughput records, returning two analytical reports.","exampleAgentPrompt":"I have a batch of ETL throughput records — each with a row ID, dataset group, date, number of processed rows, and duration in seconds — and I need two things: remove any exact duplicate rows, and tell me the correlation between processed_rows and duration_seconds. Can you run both analyses on my dataset of up to 200 records?","exampleUseCases":[{"title":"ETL pipeline duplicate audit","prompt":"I've got a list of transformation job records from our pipeline with columns for row_id, dataset_group, date, processed_rows, and duration_seconds — some runs look like they were logged twice. Can you deduplicate the exact repeated rows and also tell me how correlated the row count is with the processing time?"},{"title":"Throughput scaling correlation check","prompt":"I want to know if longer-running transformation jobs consistently process more rows — here are 150 records from our data warehouse ETL with processed_rows and duration_seconds per run. Can you compute the correlation between those two measures and also clean out any identical duplicate entries before analyzing?"},{"title":"Dataset group processing quality review","prompt":"We have throughput logs across multiple dataset groups and I suspect some entries are exact duplicates. Can you deduplicate the records and then give me a correlation between processed_rows and duration_seconds so I can see if processing time is proportional to data volume?"}],"resultDescription":"Returns two reports: (1) an exact row deduplication report identifying and removing fully duplicate records from the input, and (2) a two-measure correlation analysis quantifying the statistical relationship between processed_rows and duration_seconds across the supplied records.","failureModes":["Input array is empty or missing — validation error returned","More than 200 rows supplied — rejected with max items exceeded error","Row missing required fields (row_id, date, processed_rows, duration_seconds) — schema validation failure","Date field does not match YYYY-MM-DD pattern — format error","processed_rows or duration_seconds values outside allowed numeric range — range validation error","Insufficient non-null numeric data to compute correlation — correlation report may return null or undefined result"],"whenToPreferThis":"Choose this endpoint when you have transformation throughput records (processed_rows + duration_seconds per job run) and need both data deduplication and correlation analysis in a single call at low cost. It is purpose-built for ETL/pipeline analytics use cases with up to 200 rows, returning two bundled reports with no external lookups or predictions. Prefer alternatives if you need more than 200 rows, live data enrichment, grouped summaries, or analyses beyond deduplication and correlation.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-28T19:41:39.844Z","isFirstParty":false,"canonicalSlug":"transformation-throughput-analytics-exact-row-deduplication-two-c3f4cea3"}