{"uid":"cap_faN9KkhXYlP4EVs9zi8ir","slug":"training-assessments-exact-row-deduplication-secondary-measure-17270e2f","name":"Training Assessments — Exact Row Deduplication + Secondary-Measure Weighted Mean","description":"Training assessments — Exact row deduplication + Secondary-measure weighted mean: Exact row deduplication + Secondary-measure weighted mean for supplied training assessments records (pre_score, post_score). 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-education-11-051?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","course_group","date","pre_score","post_score"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"pre_score":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"post_score":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"course_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","pre_score":10,"post_score":1,"course_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","pre_score":20,"post_score":2,"course_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","pre_score":15,"post_score":3,"course_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","pre_score":30,"post_score":4,"course_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["pre_score","post_score"],"type":"string","default":"pre_score"}}},"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_EEXwaMzGzMcfQg_RnA4t6","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":"Deduplicates training assessment rows and computes a secondary-measure weighted mean for pre_score or post_score across up to 200 records, returning two analytical reports.","exampleAgentPrompt":"I have up to 200 training assessment rows with pre_score and post_score fields — can you deduplicate the records exactly and compute a weighted mean on post_score, giving me two analytical reports?","exampleUseCases":[{"title":"Course effectiveness scoring after deduplication","prompt":"I have a CSV of training assessments with row IDs, course groups, dates, pre_score and post_score — there may be duplicate rows. Can you deduplicate them exactly and compute a weighted mean on post_score so I can see how effective each course group was?"},{"title":"Pre-score baseline summary for L&D team","prompt":"My L&D team exported 150 rows of assessment records with pre_score and post_score. Please deduplicate them and give me a weighted mean report focused on pre_score so we can establish our baseline."},{"title":"Data hygiene report for training records","prompt":"We've collected training assessment data across multiple course groups and dates, but I suspect there are exact duplicate rows. Can you run deduplication and compute a weighted mean on post_score — I need two separate analytical reports from the same dataset?"}],"resultDescription":"Returns two analytical reports for the supplied training assessment records: (1) an exact row deduplication report identifying and removing duplicate entries, and (2) a secondary-measure weighted mean report computed over the chosen field (pre_score or post_score), both derived locally from the submitted data without external lookups.","failureModes":["Input array is empty or exceeds 200 rows — validation error","Missing required fields (row_id, course_group, date, pre_score, post_score) on any row — schema validation failure","Date field does not match YYYY-MM-DD pattern — rejected with format error","All rows are duplicates, leaving no data for weighted mean computation","pre_score or post_score values are null for all rows, making weighted mean undefined","Payment of 0.01 USDC not received — request rejected with 402 status"],"whenToPreferThis":"Choose this endpoint when you need both exact row deduplication and a weighted mean computation on training assessment data (pre_score/post_score) in a single paid call, getting two reports for the price of one. Prefer it over manual deduplication when you have up to 200 assessment rows with course group and date dimensions and need clean, aggregated results quickly without setting up a local analytics pipeline.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T18:51:10.345Z","isFirstParty":false,"canonicalSlug":"training-assessments-exact-row-deduplication-secondary-measure-17270e2f"}