{"uid":"cap_qMcSavRuGMzUvLYsQH5au","slug":"transport-ridership-duplicate-key-report-secondary-measure-weighted-180fef62","name":"Transport Ridership — Duplicate Key Report + Secondary-Measure Weighted Mean","description":"Transport ridership — Duplicate key report + Secondary-measure weighted mean: Duplicate key report + Secondary-measure weighted mean for supplied transport ridership records (passenger_count, service_count). 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-economics-05-067?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","region","date","passenger_count","service_count"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"region":{"type":"string","default":"","maxLength":80},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"service_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"passenger_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","region":"group-a","row_id":"row-1","service_count":1,"passenger_count":10},{"date":"2026-10-02","region":"group-b","row_id":"row-2","service_count":2,"passenger_count":20},{"date":"2026-10-03","region":"group-a","row_id":"row-3","service_count":3,"passenger_count":15},{"date":"2026-10-04","region":"group-b","row_id":"row-4","service_count":4,"passenger_count":30}],"maxItems":200,"minItems":1},"field":{"enum":["passenger_count","service_count"],"type":"string","default":"passenger_count"}}},"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_9p7AawxPmSRKxyzmSX-n8","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 transport ridership records to produce a duplicate key report and a secondary-measure weighted mean, using local analytical engines with no external lookups.","exampleAgentPrompt":"Check my transit ridership data for duplicate row IDs and compute the weighted mean of passenger_count weighted by service_count — here are my records: row-1, group-a, 2026-10-01, passenger_count=10, service_count=1; row-2, group-b, 2026-10-02, passenger_count=20, service_count=2; row-3, group-a, 2026-10-03, passenger_count=15, service_count=3.","exampleUseCases":[{"title":"Transit data integrity check","prompt":"I have 150 ridership records from our regional bus network — can you scan them for any duplicate row IDs and also give me the weighted mean of passenger_count using service_count as the weight?"},{"title":"Monthly ridership weighted average","prompt":"Run a weighted mean calculation on this month's passenger_count data across all our transit zones, weighted by service_count, and flag any rows that share the same row ID — I have about 80 records to process."},{"title":"Multi-region duplicate audit","prompt":"Before I merge these two regional datasets into one, can you check for duplicate keys and compute a service_count-weighted mean for passenger_count? I'll pass you all 200 rows now."}],"resultDescription":"Returns two independent reports: (1) a duplicate key report listing any row_id values that appear more than once in the submitted records, and (2) a secondary-measure weighted mean for the selected field (passenger_count or service_count), weighted by the other measure — all computed locally without external data access.","failureModes":["Fewer than 1 row submitted — returns validation error","More than 200 rows submitted — request rejected, exceeds limit","Invalid date format (not YYYY-MM-DD) — schema validation failure","Missing required fields (row_id, region, date) — rejected with error","Null values for both passenger_count and service_count — weighted mean may be undefined or NaN","Invalid field enum value (not passenger_count or service_count) — schema error"],"whenToPreferThis":"Choose this endpoint when you need to simultaneously audit a transport ridership dataset for duplicate row keys AND compute a secondary-measure weighted mean in a single call, without sending data to external systems. Best suited for batch sizes up to 200 rows where offline, local computation is preferred and both data quality checking and statistical aggregation are needed together.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-25T12:33:22.402Z","isFirstParty":false,"canonicalSlug":"transport-ridership-duplicate-key-report-secondary-measure-weighted-180fef62"}