{"uid":"cap_J_FemUsr1vF7yDRcnqj-9","slug":"wind-observations-exact-row-deduplication-explicit-missing-value-fill-d157ca3d","name":"Wind Observations — Exact Row Deduplication + Explicit Missing-Value Fill","description":"Wind observations — Exact row deduplication + Explicit missing-value fill: Exact row deduplication + Explicit missing-value fill for supplied wind observations records (wind_speed_ms, gust_speed_ms). 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-weather-03-054?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","station_group","date","wind_speed_ms","gust_speed_ms"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"gust_speed_ms":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"station_group":{"type":"string","default":"","maxLength":80},"wind_speed_ms":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","gust_speed_ms":1,"station_group":"group-a","wind_speed_ms":10},{"date":"2026-10-02","row_id":"row-2","gust_speed_ms":2,"station_group":"group-b","wind_speed_ms":20},{"date":"2026-10-03","row_id":"row-3","gust_speed_ms":3,"station_group":"group-a","wind_speed_ms":15},{"date":"2026-10-04","row_id":"row-4","gust_speed_ms":4,"station_group":"group-b","wind_speed_ms":30}],"maxItems":200,"minItems":1},"field":{"enum":["wind_speed_ms","gust_speed_ms"],"type":"string","default":"wind_speed_ms"},"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_XkEOH4fB0f_Pu8ZCMmFny","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 duplicate rows and fills missing values in wind observation records (wind_speed_ms, gust_speed_ms) for up to 200 rows, returning 2 analytical reports.","exampleAgentPrompt":"Clean up my wind observation dataset: remove any exact duplicate rows and fill missing wind_speed_ms values using the median method. Here are my records with row_id, station_group, date, wind_speed_ms, and gust_speed_ms fields — up to 200 rows.","exampleUseCases":[{"title":"Weather station data cleaning pipeline","prompt":"I have 150 rows of wind sensor readings from multiple station groups with some duplicate entries and a bunch of null wind_speed_ms values — can you deduplicate the exact duplicate rows and fill the missing wind speeds using median imputation?"},{"title":"Gust speed gap-filling for reporting","prompt":"My anemometer export has missing gust_speed_ms values scattered across dates. Please deduplicate the records and fill in those null gust speeds using the mean of available readings so I can generate a clean report."},{"title":"Pre-analysis wind data normalization","prompt":"Before I run my analysis, I need to clean this wind observation dataset: strip out any exact duplicate rows and replace any missing wind_speed_ms entries with zero. The data has row IDs, dates, station groups, wind speeds, and gust speeds."}],"resultDescription":"Two analytical reports per call covering: (1) exact row deduplication results identifying and removing duplicate wind observation records, and (2) explicit missing-value fill results showing which rows had null wind_speed_ms or gust_speed_ms values filled using the chosen method (zero, mean, or median). Reports are generated from the supplied data using local analytical engines — no external data or live lookups.","failureModes":["Exceeding 200 rows returns a validation error","Invalid date format (not YYYY-MM-DD) causes schema rejection","Missing required fields (row_id, station_group, date) causes row-level errors","Specifying an unsupported fill method or field enum value causes parameter rejection","Submitting an empty rows array (minItems:1 violated) returns a validation error","Payment failure via x402 protocol prevents processing"],"whenToPreferThis":"Choose this endpoint when you have wind observation data (with wind_speed_ms and/or gust_speed_ms fields) that requires both exact duplicate row removal and explicit missing-value imputation in a single call. It is ideal for preprocessing batches of up to 200 meteorological records before downstream analysis, reporting, or storage. Prefer it over general-purpose data cleaning tools when you specifically need wind-domain records cleaned with configurable fill strategies (zero, mean, or median) and want two focused analytical output reports at low cost ($0.01 USDC).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-30T19:11:13.842Z","isFirstParty":false,"canonicalSlug":"wind-observations-exact-row-deduplication-explicit-missing-value-fill-d157ca3d"}