{"uid":"cap_PcflmuKBACenHF2Mv1-sV","slug":"training-compliance-string-normalisation-and-missing-value-fill-feccd2b3","name":"Training Compliance String Normalisation and Missing-Value Fill","description":"Training compliance — String normalisation + Explicit missing-value fill: String normalisation + Explicit missing-value fill for supplied training compliance records (completed_courses, assigned_courses). 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-10-037?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","team_group","date","completed_courses","assigned_courses"],"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},"assigned_courses":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"completed_courses":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","team_group":"group-a","assigned_courses":1,"completed_courses":10},{"date":"2026-10-02","row_id":"row-2","team_group":"group-b","assigned_courses":2,"completed_courses":20},{"date":"2026-10-03","row_id":"row-3","team_group":"group-a","assigned_courses":3,"completed_courses":15},{"date":"2026-10-04","row_id":"row-4","team_group":"group-b","assigned_courses":4,"completed_courses":30}],"maxItems":200,"minItems":1},"field":{"enum":["completed_courses","assigned_courses"],"type":"string","default":"completed_courses"},"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_ReT7mNJ5vbzxxAdyeWIu_","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":"Normalises string fields and fills missing values in training compliance records (completed_courses, assigned_courses) for up to 200 rows, producing 2 analytical reports per call.","exampleAgentPrompt":"Can you clean up my training compliance data — normalise the string fields and fill in any missing completed_courses values using median imputation? I have 4 rows: row-1 for group-a on 2026-10-01 with 10 completed and 1 assigned, row-2 for group-b on 2026-10-02 with null completed and 2 assigned, row-3 for group-a on 2026-10-03 with 15 completed and 3 assigned, row-4 for group-b on 2026-10-04 with 30 completed and null assigned.","exampleUseCases":[{"title":"Fill missing completed_courses for HR report","prompt":"I have a training compliance export with some null completed_courses values across my team groups — can you fill the gaps using median imputation and normalise the string fields? Here are my 5 rows: row-1 group-alpha 2026-09-01 completed=null assigned=5, row-2 group-beta 2026-09-02 completed=8 assigned=10, row-3 group-alpha 2026-09-03 completed=6 assigned=5, row-4 group-beta 2026-09-04 completed=null assigned=10, row-5 group-gamma 2026-09-05 completed=12 assigned=8."},{"title":"Standardise compliance records before dashboard load","prompt":"Before I push our training compliance data into the dashboard, can you normalise the string fields and fill any missing assigned_courses values using zero fill? I've got 3 rows: row-A team-north 2026-11-01 completed=20 assigned=null, row-B team-south 2026-11-02 completed=15 assigned=25, row-C team-north 2026-11-03 completed=null assigned=30."},{"title":"Mean imputation for L&D compliance audit","prompt":"Our L&D audit needs clean data — please normalise strings and fill missing completed_courses using mean imputation across these 6 compliance records: row-1 dept-eng 2026-08-01 completed=50 assigned=60, row-2 dept-eng 2026-08-02 completed=null assigned=60, row-3 dept-sales 2026-08-03 completed=40 assigned=50, row-4 dept-sales 2026-08-04 completed=45 assigned=null, row-5 dept-ops 2026-08-05 completed=55 assigned=70, row-6 dept-ops 2026-08-06 completed=null assigned=70."}],"resultDescription":"Two analytical reports: one covering string normalisation of team_group and date fields, and one covering explicit missing-value fill for the specified numeric field (completed_courses or assigned_courses) using the chosen method (zero, mean, or median). Results are derived entirely from the supplied rows with no external lookups.","failureModes":["More than 200 rows submitted — request rejected with validation error","Invalid date format (not YYYY-MM-DD) — row rejected or error returned","Unknown fill method value outside zero/mean/median enum — validation failure","Empty rows array — minimum 1 row required","Numeric values outside allowed range (-1e12 to 1e12) — validation error","Missing required fields (row_id, team_group, date) — schema validation failure"],"whenToPreferThis":"Choose this endpoint when you need lightweight, local data cleaning on training compliance records — specifically string normalisation and missing-value imputation for completed_courses or assigned_courses — without any external API calls, predictions, or professional assessments. Ideal for preprocessing compliance data before loading into dashboards or reports, when the dataset is under 200 rows and you need two bundled cleaning reports for a flat $0.01 fee.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T12:30:46.386Z","isFirstParty":false,"canonicalSlug":"training-compliance-string-normalisation-and-missing-value-fill-feccd2b3"}