{"uid":"cap_nRAwFCWoEV2RqUVMhLzoG","slug":"transport-ridership-record-quality-audit-and-string-normalisation-a0697bb1","name":"Transport Ridership Record Quality Audit and String Normalisation","description":"Transport ridership — Record quality audit + String normalisation: Record quality audit + String normalisation 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-001?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}}},"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_UainffEs26hA2AYTEnCjF","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":"Audits transport ridership records for data quality issues and normalises string fields, producing two independent analytical reports for up to 200 rows.","exampleAgentPrompt":"Can you run a data quality audit and string normalisation on these transport ridership records — I have rows with row_id, region, date, passenger_count, and service_count fields, up to 50 rows — and give me two reports flagging any bad records and cleaning up the region strings?","exampleUseCases":[{"title":"Pre-ingestion ridership data validation","prompt":"Before I load this week's transit ridership export into our data warehouse, can you audit these 120 rows for quality issues and normalise the region name strings? Each row has a row_id, region, date, passenger_count, and service_count."},{"title":"Detecting dirty records in passenger counts","prompt":"I've got a batch of 80 ridership records from different transit zones and I'm worried some passenger_count or service_count values might be null, negative, or out of range — can you run a record quality audit and string normalisation on them?"},{"title":"Cleaning regional labels in transit dataset","prompt":"Our regional labels in the ridership data are inconsistent — some have extra spaces, mixed case, or odd characters. Can you normalise the region strings and give me a quality report for these 45 rows with passenger and service counts?"}],"resultDescription":"Two independent analytical reports: (1) a record quality audit flagging issues such as nulls, out-of-range values, or malformed dates across the supplied rows; (2) a string normalisation report detailing standardised forms of region and other string fields. Reports are generated locally without external lookups or predictions.","failureModes":["Exceeding 200 rows returns a validation error","Rows missing required fields (row_id, region, date, passenger_count, service_count) are rejected","Dates not matching YYYY-MM-DD format fail schema validation","Numeric values outside ±1,000,000,000,000 are rejected","Empty rows array returns an error","Payment failure (insufficient USDC balance) blocks the request"],"whenToPreferThis":"Choose this endpoint when you need a lightweight, low-cost ($0.01 USDC) offline audit of transport ridership records — specifically passenger_count and service_count fields — combined with string normalisation for region labels, for batches up to 200 rows. It is ideal when no live data lookup, external enrichment, or predictive modelling is needed, just structured data quality reports on supplied records.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T12:31:24.666Z","isFirstParty":false,"canonicalSlug":"transport-ridership-record-quality-audit-and-string-normalisation-a0697bb1"}