{"uid":"cap_QOFea4bBsKebaRr9c8BC6","slug":"transformation-throughput-analytics-string-normalisation-secondary-f56d5c3a","name":"Transformation Throughput Analytics — String Normalisation + Secondary-Measure Weighted Mean","description":"Transformation throughput — String normalisation + Secondary-measure weighted mean: String normalisation + 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-034?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_i2A-JPS-EKuCgFHutz7Ez","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 string normalisation and secondary-measure weighted mean analysis on up to 200 transformation throughput records (processed_rows, duration_seconds), returning 2 bundled analytical reports.","exampleAgentPrompt":"Can you run string normalisation and a secondary-measure weighted mean on these 150 transformation throughput records — the primary field is processed_rows — and give me the two reports? Here are the rows with row_id, dataset_group, date, processed_rows, and duration_seconds.","exampleUseCases":[{"title":"ETL pipeline duration analysis","prompt":"I have 80 rows of ETL job logs with row_id, dataset_group, date, processed_rows, and duration_seconds. Can you normalise the string fields and give me the weighted mean of duration_seconds, weighted by processed_rows, grouped by dataset_group?"},{"title":"Data warehouse throughput audit","prompt":"Here are 200 transformation throughput records from last month's data warehouse loads. Run string normalisation on the group labels and compute a weighted mean for the processed_rows field, then give me both reports."},{"title":"Pipeline performance benchmarking","prompt":"I want to compare throughput across my three dataset groups — group-a, group-b, and group-c. I have 60 records with processed_rows and duration_seconds. Can you normalise the names and compute a secondary-measure weighted mean with processed_rows as the primary field?"}],"resultDescription":"Returns two bundled analytical reports: (1) string-normalised versions of the text fields (dataset_group labels cleaned and standardised), and (2) a secondary-measure weighted mean computed over the selected primary numeric field (processed_rows or duration_seconds), covering all submitted rows (up to 200). No external lookups or live data are involved — all computation is performed locally on the supplied records.","failureModes":["Fewer than 1 row submitted — minimum of 1 row required","More than 200 rows submitted — exceeds maxItems limit","Missing required fields (row_id, date, processed_rows, duration_seconds) on any row — validation error","Date field not in YYYY-MM-DD format — pattern mismatch error","Null values in both numeric fields may reduce weighted mean accuracy","Invalid field enum value (must be 'processed_rows' or 'duration_seconds') — rejected input"],"whenToPreferThis":"Choose this endpoint when you need both string normalisation and a weighted mean computed together on transformation throughput records (processed_rows, duration_seconds) in a single paid call, and your dataset has up to 200 rows. It is particularly useful for ETL/pipeline analytics workflows where you want to clean categorical labels and compute weighted performance statistics simultaneously without separate API calls. Prefer alternatives if you need only one of the two analyses, live data lookups, predictions, or more than 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T12:39:06.758Z","isFirstParty":false,"canonicalSlug":"transformation-throughput-analytics-string-normalisation-secondary-f56d5c3a"}