{"uid":"cap_tZKn0AHjgSGDKP3l9IC7Z","slug":"transport-ridership-keyed-dataset-comparison-with-missing-value-fill-f15dbd71","name":"Transport Ridership Keyed Dataset Comparison with Missing-Value Fill","description":"Transport ridership — Keyed dataset comparison + Explicit missing-value fill: Keyed dataset comparison + Explicit missing-value fill 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-190?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"},"other":{"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":21},{"date":"2026-10-03","region":"group-a","row_id":"row-3","service_count":3,"passenger_count":17},{"date":"2026-10-04","region":"group-b","row_id":"row-4","service_count":4,"passenger_count":33}],"maxItems":200,"minItems":0},"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_0ltFYVLFuY4yyUzdWInkD","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":"Compares two keyed transport ridership datasets (passenger_count or service_count) side by side and fills in explicit missing values, producing 2 analytical reports for up to 200 rows.","exampleAgentPrompt":"Compare these two sets of transit ridership records for me — I have a primary dataset and a comparison dataset, each with up to 200 rows of passenger_count and service_count by region and date, and I need a keyed comparison plus explicit missing-value fill for the passenger_count field.","exampleUseCases":[{"title":"Monthly ridership reconciliation across regions","prompt":"I have two versions of our October ridership data — one from our operations team and one from the ticketing system — each with up to 50 rows keyed by row_id, region, and date with passenger_count and service_count. Can you run a keyed comparison on passenger_count and fill in any missing values so I can see where they diverge?"},{"title":"Detecting service count gaps after data pipeline update","prompt":"Our data pipeline produced two versions of service_count records for our bus network this week — the before and after sets each have about 80 rows with region, date, and service_count. Run a keyed dataset comparison on service_count and explicitly fill any missing values so I can see what changed."},{"title":"Auditing transit data quality before board report","prompt":"Before I finalize our quarterly transit report, I need to compare our internal ridership records against the figures submitted to the regulator — both datasets have up to 150 rows with passenger_count by region and date. Can you do a keyed comparison with missing-value fill on passenger_count and give me 2 reports?"}],"resultDescription":"Two analytical reports covering: (1) a keyed row-by-row comparison of the primary and secondary ridership datasets highlighting differences in the selected field (passenger_count or service_count), and (2) explicit missing-value fill results showing which nulls were identified and how they were resolved — all computed locally with no external lookups.","failureModes":["Exceeding 200 rows causes validation rejection","Missing required fields (row_id, region, date) in any row causes schema rejection","Invalid date format (non-YYYY-MM-DD) causes parsing error","Numeric values outside ±1,000,000,000,000 range rejected","Empty rows array returns error","Mismatched row_ids between primary and comparison datasets may result in unmatched row reports"],"whenToPreferThis":"Choose this endpoint when you have two structured transport ridership datasets (keyed by row_id) that you want to compare field-by-field and audit for missing values — specifically for passenger_count or service_count metrics by region and date. Ideal for reconciliation tasks, data quality audits, or detecting changes between two dataset versions without needing live data, predictions, or external enrichment. Best suited for datasets up to 200 rows where a batch local computation is sufficient.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-29T12:54:28.273Z","isFirstParty":false,"canonicalSlug":"transport-ridership-keyed-dataset-comparison-with-missing-value-fill-f15dbd71"}