{"uid":"cap_2SXjS1QLbt5EKeLLaTCri","slug":"validator-uptime-string-normalisation-and-missing-value-fill-850b3c4a","name":"Validator Uptime String Normalisation and Missing-Value Fill","description":"Validator uptime — String normalisation + Explicit missing-value fill: String normalisation + Explicit missing-value fill for supplied validator uptime records (online_minutes, observed_minutes). 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-finance-12-037?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","instrument_group","date","online_minutes","observed_minutes"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"online_minutes":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"instrument_group":{"type":"string","default":"","maxLength":80},"observed_minutes":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","online_minutes":10,"instrument_group":"group-a","observed_minutes":1},{"date":"2026-10-02","row_id":"row-2","online_minutes":20,"instrument_group":"group-b","observed_minutes":2},{"date":"2026-10-03","row_id":"row-3","online_minutes":15,"instrument_group":"group-a","observed_minutes":3},{"date":"2026-10-04","row_id":"row-4","online_minutes":30,"instrument_group":"group-b","observed_minutes":4}],"maxItems":200,"minItems":1},"field":{"enum":["online_minutes","observed_minutes"],"type":"string","default":"online_minutes"},"method":{"enum":["zero","mean","median"],"type":"string","default":"median"}}},"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_Fxq3RfA_XChz9U8YJh4cr","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 fills missing values (online_minutes or observed_minutes) in up to 200 validator uptime records using zero, mean, or median imputation, returning 2 analytical reports.","exampleAgentPrompt":"I have 150 rows of validator uptime records with some missing online_minutes values — can you normalise the string fields and fill those missing values using median imputation, then give me the two analysis reports?","exampleUseCases":[{"title":"Imputing gaps in staking uptime logs","prompt":"I have 80 rows of daily validator uptime records for two groups and several online_minutes values are null — please fill them using median imputation and normalise the string fields so I can use the data downstream."},{"title":"Zero-filling missing observed minutes","prompt":"My validator dataset has missing observed_minutes across about 40 rows — can you apply zero-fill and run the string normalisation report so I know what was cleaned?"},{"title":"Mean imputation for validator performance audit","prompt":"I'm auditing validator performance across 3 instrument groups for October 2026. I have 120 rows but some online_minutes entries are missing — fill them with the mean and normalise the group labels, then show me both reports."}],"resultDescription":"Two analytical reports covering: (1) string normalisation details for text fields such as instrument_group, and (2) explicit missing-value fill results for the selected numeric field (online_minutes or observed_minutes), showing what values were imputed and by which method (zero, mean, or median). Reports are based purely on the supplied rows with no external lookups.","failureModes":["Input array is empty or exceeds 200 rows — request rejected","Missing required fields (row_id, date, online_minutes, observed_minutes, instrument_group) in any row","Date field does not match YYYY-MM-DD pattern — validation error","Invalid enum value for field or method parameters","Payment of 0.01 USDC not completed — 402 response returned","Numeric values outside allowed range (±1,000,000,000,000) rejected"],"whenToPreferThis":"Choose this endpoint when you have a batch of up to 200 validator uptime rows that need both string normalisation and numeric missing-value imputation in a single call at low cost. It is ideal when you need two structured analytical reports on data quality and filling without any external data lookups, predictions, or live network queries. Prefer it over general-purpose data-cleaning pipelines when your domain is specifically validator/staking uptime with online_minutes and observed_minutes fields.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T12:32:19.972Z","isFirstParty":false,"canonicalSlug":"validator-uptime-string-normalisation-and-missing-value-fill-850b3c4a"}