{"uid":"cap_Row_bYUfo_EacIJVsNILH","slug":"office-supplies-string-normalisation-secondary-measure-weighted-mean-53a61ac5","name":"Office Supplies — String Normalisation + Secondary-Measure Weighted Mean","description":"Office supplies — String normalisation + Secondary-measure weighted mean: String normalisation + Secondary-measure weighted mean for supplied office supplies records (issued_units, received_units). 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-operations-24-034?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","team_group","date","issued_units","received_units"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"team_group":{"type":"string","default":"","maxLength":80},"issued_units":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"received_units":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","team_group":"group-a","issued_units":10,"received_units":1},{"date":"2026-10-02","row_id":"row-2","team_group":"group-b","issued_units":20,"received_units":2},{"date":"2026-10-03","row_id":"row-3","team_group":"group-a","issued_units":15,"received_units":3},{"date":"2026-10-04","row_id":"row-4","team_group":"group-b","issued_units":30,"received_units":4}],"maxItems":200,"minItems":1},"field":{"enum":["issued_units","received_units"],"type":"string","default":"issued_units"}}},"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_bsVOODn5LN5ARRdxFOzfi","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":"Normalises string fields and computes a secondary-measure weighted mean for office supplies records containing issued_units and received_units, across up to 200 rows.","exampleAgentPrompt":"I have a batch of office supply records with issued_units and received_units across team groups — can you run string normalisation and compute a secondary-measure weighted mean on the issued_units field for these rows?","exampleUseCases":[{"title":"Department supply usage comparison","prompt":"I have 150 office supply records across our teams from last quarter — each row has a team group, date, and both issued and received unit counts. Can you normalise the string fields and give me the secondary-measure weighted mean for issued_units so I can compare usage across departments?"},{"title":"Monthly stock reconciliation analytics","prompt":"Here are our October office supply logs for group-a and group-b — I need two reports: string normalisation across the records and a weighted mean calculated using received_units as the secondary measure. Can you process all 80 rows?"},{"title":"Supplies data quality and statistics cleanup","prompt":"Our office supplies dataset has inconsistent string formatting in the team_group column. Can you normalise those strings and also compute the secondary-measure weighted mean for received_units across all the rows so we get clean, reliable stats?"}],"resultDescription":"Returns two analytical reports for the submitted office supplies rows: (1) a string normalisation report cleaning text fields such as team_group, and (2) a secondary-measure weighted mean computed for the specified numeric field (issued_units or received_units), using the other measure as the weight. Both reports are computed locally with no external lookups.","failureModes":["Submitting more than 200 rows returns a validation error","Missing required fields (row_id, date, issued_units, received_units) causes row-level rejection","Invalid date format (not YYYY-MM-DD) triggers a pattern validation failure","Null values in both numeric fields may produce undefined weighted mean results","Payment of 0.01 USDC not included or declined results in a 402 Payment Required response"],"whenToPreferThis":"Choose this endpoint when you have office supplies records (up to 200 rows) with issued_units and received_units and need both string normalisation of categorical fields and a secondary-measure weighted mean computed in a single call. It is ideal for lightweight batch analytics on structured inventory or operations data without needing a live data connection or external prediction service. At $0.01 USDC per call covering two reports, it is cost-effective for routine data quality and statistical summarisation tasks.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T18:38:05.970Z","isFirstParty":false,"canonicalSlug":"office-supplies-string-normalisation-secondary-measure-weighted-mean-53a61ac5"}