{"uid":"cap_ej8G4-d8eg7Y_IgUwB1sO","slug":"forecast-verification-inputs-exact-row-deduplication-duplicate-key-fd59b2f3","name":"Forecast Verification Inputs — Exact Row Deduplication + Duplicate Key Report","description":"Forecast verification inputs — Exact row deduplication + Duplicate key report: Exact row deduplication + Duplicate key report for supplied forecast verification inputs records (forecast_value, observed_value). 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-24-038?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","station_group","date","forecast_value","observed_value"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"station_group":{"type":"string","default":"","maxLength":80},"forecast_value":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"observed_value":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","station_group":"group-a","forecast_value":10,"observed_value":1},{"date":"2026-10-02","row_id":"row-2","station_group":"group-b","forecast_value":20,"observed_value":2},{"date":"2026-10-03","row_id":"row-3","station_group":"group-a","forecast_value":15,"observed_value":3},{"date":"2026-10-04","row_id":"row-4","station_group":"group-b","forecast_value":30,"observed_value":4}],"maxItems":200,"minItems":1}}},"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_dkPRm22yo4iO9AMGxp3_v","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 forecast verification rows and reports duplicate keys across up to 200 records containing forecast and observed values.","exampleAgentPrompt":"Can you deduplicate my forecast verification records and give me a duplicate key report? I have about 50 rows with station_group, date, forecast_value, and observed_value fields — I need to know which rows are exact duplicates and which row IDs share the same keys.","exampleUseCases":[{"title":"Weather model validation data cleanup","prompt":"I'm preparing forecast verification data for our weather model — can you scan these 120 rows of station_group, date, forecast_value, and observed_value records, remove any exact duplicate rows, and tell me which row IDs have duplicate keys?"},{"title":"Pre-analysis forecast dataset audit","prompt":"Before I run accuracy metrics on my forecast dataset, I need to check for duplicate entries — please deduplicate these forecast verification rows and give me a report of any repeated key combinations across my station groups and dates."},{"title":"Data pipeline quality gate for forecasts","prompt":"Our ingestion pipeline may have loaded some forecast records twice — can you take these forecast verification inputs with forecast_value and observed_value pairs and identify all exact row duplicates plus flag any duplicate row IDs so I can fix the pipeline?"}],"resultDescription":"Returns two independent reports: (1) an exact row deduplication report listing which rows are duplicates and the deduplicated dataset, and (2) a duplicate key report identifying which row IDs or key combinations (station_group + date) appear more than once, covering up to 200 input rows.","failureModes":["More than 200 rows submitted — exceeds maxItems limit","Missing required fields (row_id, station_group, date, forecast_value, observed_value) causes validation error","Invalid date format (not YYYY-MM-DD) rejected by pattern validation","Values outside ±1,000,000,000,000 range rejected","Empty rows array (minItems: 1) causes error","Payment not provided or insufficient USDC causes 402 response"],"whenToPreferThis":"Choose this endpoint when you need both exact row-level deduplication and a duplicate key report for forecast verification data (forecast_value + observed_value pairs) in a single call. It is purpose-built for weather or time-series forecast verification datasets with station_group and date dimensions. Prefer it over generic deduplication tools when your data is structured around forecast vs observed value comparisons and you need two complementary reports at low cost for up to 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T18:35:18.270Z","isFirstParty":false,"canonicalSlug":"forecast-verification-inputs-exact-row-deduplication-duplicate-key-fd59b2f3"}