{"uid":"cap__6hM3FLxzVFeYAipZqdti","slug":"asset-revisions-string-normalisation-secondary-measure-weighted-mean-86c857b6","name":"Asset Revisions — String Normalisation + Secondary-Measure Weighted Mean","description":"Asset revisions — String normalisation + Secondary-measure weighted mean: String normalisation + Secondary-measure weighted mean for supplied asset revisions records (revision_count, rework_hours). 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-creative-14-034?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","asset_group","date","revision_count","rework_hours"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"asset_group":{"type":"string","default":"","maxLength":80},"rework_hours":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"revision_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","asset_group":"group-a","rework_hours":1,"revision_count":10},{"date":"2026-10-02","row_id":"row-2","asset_group":"group-b","rework_hours":2,"revision_count":20},{"date":"2026-10-03","row_id":"row-3","asset_group":"group-a","rework_hours":3,"revision_count":15},{"date":"2026-10-04","row_id":"row-4","asset_group":"group-b","rework_hours":4,"revision_count":30}],"maxItems":200,"minItems":1},"field":{"enum":["revision_count","rework_hours"],"type":"string","default":"revision_count"}}},"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_S9GH3Y6jVy5io2WTseywk","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 analytics on up to 200 rows of asset revision records (revision_count, rework_hours), returning two local reports per call.","exampleAgentPrompt":"Analyse these asset revision records — normalise the asset_group strings and compute the secondary-measure weighted mean for rework_hours across up to 200 rows, then give me both reports: [{'row_id':'r1','asset_group':'Group A','date':'2025-01-15','revision_count':12,'rework_hours':4.5}, ...]","exampleUseCases":[{"title":"Standardising messy asset group labels","prompt":"I have 150 rows of asset revision data with inconsistent asset_group names like 'grp-a', 'Group A', 'GROUP_A' — can you normalise those strings and also compute the weighted mean of rework_hours using revision_count as the secondary measure?"},{"title":"Weighted rework effort summary for engineering review","prompt":"Here are our Q1 asset revision records with revision_count and rework_hours for each row — please run the secondary-measure weighted mean on rework_hours and normalise the group labels so I can present a clean summary to the engineering team."},{"title":"Data quality check on revision tracking exports","prompt":"I've exported 80 rows from our revision tracking system into this dataset with fields row_id, asset_group, date, revision_count, and rework_hours — run string normalisation plus the weighted mean report on revision_count field for me."}],"resultDescription":"Two analytical reports per call: (1) string-normalised asset_group label output for each row, and (2) a secondary-measure weighted mean computed for the chosen field (revision_count or rework_hours) weighted by the other measure, covering up to 200 input rows. No external data is fetched; all computation is local.","failureModes":["More than 200 rows submitted — request rejected with validation error","Missing required fields (row_id, asset_group, date, revision_count, rework_hours) — row-level validation failure","Invalid date format (must match YYYY-MM-DD) — schema validation error","Numeric values outside allowed range (±1,000,000,000,000) — schema rejection","Empty rows array — minimum items constraint violation","Invalid field enum value (must be 'revision_count' or 'rework_hours') — enum validation error"],"whenToPreferThis":"Choose this endpoint when you need both string normalisation of categorical group labels and a secondary-measure weighted mean on asset revision data (revision_count, rework_hours) in a single low-cost call. It is purpose-built for asset revision datasets up to 200 rows and delivers two distinct local reports without any external lookup or live data dependency, making it suitable for batch analytics pipelines, data quality workflows, and offline reporting on revision tracking exports.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-30T19:08:28.659Z","isFirstParty":false,"canonicalSlug":"asset-revisions-string-normalisation-secondary-measure-weighted-mean-86c857b6"}