{"uid":"cap_tv-Oa59SkFHrKEqVW3jH_","slug":"transport-ridership-data-quality-audit-deduplication-and-adjacent-row-8e8a6b9c","name":"Transport Ridership Data Quality Audit, Deduplication, and Adjacent Row Changes","description":"Transport ridership — Record quality audit + Exact row deduplication + Adjacent row changes: Record quality audit + Exact row deduplication + Adjacent row changes for supplied transport ridership records (passenger_count, service_count). Up to 200 rows; 3 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 3 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-economics-05-217?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_dOy-Gb2Ekh5OsbcRxhprR","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":"Runs three local analytical reports on transport ridership data: record quality audit, exact row deduplication, and adjacent row change detection — all in a single call for up to 200 rows.","exampleAgentPrompt":"Can you run a quality audit, exact deduplication check, and adjacent row change detection on my transport ridership records? Here are the rows — I want to analyze the passenger_count field across regions like 'north-line' and 'south-line' for dates in October 2025.","exampleUseCases":[{"title":"Pre-analysis ridership data cleanup","prompt":"I've got a batch of daily transit ridership records from our regional lines and I need to check them for data quality issues, duplicate rows, and spot any big jumps between consecutive days — can you run all three checks on the passenger_count field?"},{"title":"Service count anomaly detection","prompt":"Before I load this service count dataset into our dashboard, can you audit it for record quality problems, flag any exact duplicate entries, and show me where adjacent rows change significantly? There are about 150 rows covering multiple regions."},{"title":"Monthly ridership report validation","prompt":"I'm preparing our monthly ridership report and want to make sure the data is clean — please run a quality audit, deduplication, and adjacent row change report on these passenger_count records for our bus network across 12 regions."}],"resultDescription":"Three independent analytical reports returned together: (1) a record quality audit flagging nulls, type mismatches, or out-of-range values in the specified field; (2) an exact row deduplication report identifying fully duplicated rows; (3) an adjacent row changes report showing value differences between consecutive rows for the chosen field (passenger_count or service_count). No external data is fetched — all analysis is performed locally on the supplied rows.","failureModes":["More than 200 rows submitted — request will be rejected or truncated","Missing required fields (row_id, region, date, passenger_count, service_count) cause validation errors","Invalid date format (not YYYY-MM-DD) causes schema rejection","Field selector not in allowed enum ['passenger_count','service_count'] causes error","Empty rows array rejected due to minItems:1 constraint","Payment failure via x402 protocol prevents execution"],"whenToPreferThis":"Choose this endpoint when you need three standard data quality operations — quality audit, exact deduplication, and adjacent row change detection — on transport ridership data in a single low-cost call. It is ideal for pre-processing pipelines that validate transit datasets before downstream analysis or reporting. Prefer this over separate tools when your dataset fits within 200 rows and you want all three reports bundled for $0.01 USDC. Not suitable if you need live ridership lookups, predictive analytics, or processing beyond 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T12:31:21.006Z","isFirstParty":false,"canonicalSlug":"transport-ridership-data-quality-audit-deduplication-and-adjacent-row-8e8a6b9c"}