{"uid":"cap_cpS92hfeVQ57B3qshAMtj","slug":"wind-observations-duplicate-key-report-date-by-category-pivot-99905d92","name":"Wind Observations — Duplicate Key Report + Date by Category Pivot","description":"Wind observations — Duplicate key report + Date by category pivot: Duplicate key report + Date by category pivot 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-068?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"}}},"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_t7MyUdz3rPm_JNoPOa4Xw","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":"Analyzes up to 200 wind observation records to produce two local analytical reports: a duplicate key report and a date-by-category pivot table for wind_speed_ms or gust_speed_ms.","exampleAgentPrompt":"I have 150 wind observation records with row IDs, station groups, dates, wind speeds, and gust speeds — can you run a duplicate key report and a date-by-category pivot on the wind_speed_ms field for me?","exampleUseCases":[{"title":"Data quality check for wind sensor logs","prompt":"I've got a batch of wind sensor readings from multiple stations and I need to know if there are any duplicate row IDs or station-date combinations — can you run a duplicate key report on these records? There are about 80 rows with row_id, station_group, date, wind_speed_ms, and gust_speed_ms fields."},{"title":"Pivot gust speeds by station and date","prompt":"Can you create a date-by-category pivot table for my gust_speed_ms readings across different station groups? I have around 120 wind observation rows I'd like to summarize."},{"title":"Pre-processing audit before wind data ingestion","prompt":"Before I load these 200 wind observation records into our database, can you check for duplicate keys and also give me a pivot of wind_speed_ms by date and station_group so I can spot any anomalies?"}],"resultDescription":"Returns two analytical reports: (1) a duplicate key report identifying rows with repeated row_id or station_group/date combinations, and (2) a date-by-category pivot table cross-tabulating the selected numeric field (wind_speed_ms or gust_speed_ms) across dates and station groups. All computation is performed locally on the supplied data with no external lookups.","failureModes":["Input array is empty or missing — returns validation error","More than 200 rows submitted — rejected with maxItems error","Invalid date format (not YYYY-MM-DD) — schema validation failure","Field enum value not recognized — schema validation error","Null values in numeric fields may affect aggregation results","Malformed row objects missing required fields cause request rejection"],"whenToPreferThis":"Choose this endpoint when you need to simultaneously check for duplicate record keys and produce a date-by-category pivot table on wind observation data (wind_speed_ms or gust_speed_ms) in a single low-cost call. It is best suited for data quality auditing and exploratory summarization of up to 200 wind records without requiring any external data sources, live feeds, or predictions.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-29T12:53:39.113Z","isFirstParty":false,"canonicalSlug":"wind-observations-duplicate-key-report-date-by-category-pivot-99905d92"}