{"uid":"cap_FZT7896ESTWBkeOy_WqTD","slug":"travel-administration-duplicate-key-report-and-missing-value-fill-aa77c9ca","name":"Travel Administration Duplicate Key Report and Missing Value Fill","description":"Travel administration — Duplicate key report + Explicit missing-value fill: Duplicate key report + Explicit missing-value fill for supplied travel administration records (trip_count, recorded_cost). 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-operations-14-070?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","team_group","date","trip_count","recorded_cost"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"team_group":{"type":"string","default":"","maxLength":80},"trip_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"recorded_cost":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","team_group":"group-a","trip_count":10,"recorded_cost":1},{"date":"2026-10-02","row_id":"row-2","team_group":"group-b","trip_count":20,"recorded_cost":2},{"date":"2026-10-03","row_id":"row-3","team_group":"group-a","trip_count":15,"recorded_cost":3},{"date":"2026-10-04","row_id":"row-4","team_group":"group-b","trip_count":30,"recorded_cost":4}],"maxItems":200,"minItems":1},"field":{"enum":["trip_count","recorded_cost"],"type":"string","default":"trip_count"},"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_P-c9-F-p9QdPaSUg-UP7X","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 travel administration records to detect duplicate row keys and fill missing numeric values using zero, mean, or median imputation","exampleAgentPrompt":"Check my travel records for duplicate row IDs and fill any missing trip_count values using the median — here are the rows: row-1, group-a, 2026-10-01, 10 trips, $1; row-2, group-b, 2026-10-02, null trips, $2; row-1, group-c, 2026-10-03, 15 trips, $3.","exampleUseCases":[{"title":"Expense report deduplication check","prompt":"I have 150 travel expense records with row IDs, team groups, dates, trip counts, and recorded costs — can you scan them for any duplicate row keys and give me a report of which ones are repeated?"},{"title":"Missing trip count imputation","prompt":"Some of my travel admin rows are missing trip_count values. Run a missing-value fill on the trip_count field using the median method across all my submitted rows and return the filled dataset."},{"title":"Pre-analysis travel data cleanup","prompt":"Before I run my quarterly analysis, I need to clean up my travel records — check for duplicate row IDs and fill any null recorded_cost entries with zeros. I have about 80 rows to process."}],"resultDescription":"Returns two independent reports: (1) a duplicate key report identifying which row_ids appear more than once across the submitted records, and (2) a filled dataset where null or missing values in the specified numeric field (trip_count or recorded_cost) have been replaced using the chosen imputation method (zero, mean, or median). Both reports are computed locally without any external lookup or live data.","failureModes":["Submitting more than 200 rows returns an error — batch must be split","Invalid date format (not YYYY-MM-DD) causes row rejection","Missing required fields (row_id, team_group, date) causes validation failure","Unsupported imputation method enum value returns an error","Empty rows array is rejected as minItems is 1"],"whenToPreferThis":"Choose this endpoint when you need lightweight, offline data quality checks on travel administration records — specifically duplicate key detection and numeric missing-value imputation — for up to 200 rows at low cost ($0.01 USDC for both reports). Prefer this over general ETL tools when your data is already structured with the expected fields and you only need these two specific analytical outputs without live lookups or external integrations.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T18:50:53.556Z","isFirstParty":false,"canonicalSlug":"travel-administration-duplicate-key-report-and-missing-value-fill-aa77c9ca"}