{"uid":"cap_0f9TIlTqhLR3FIppU9jXI","slug":"rubric-scoring-string-normalisation-date-by-category-pivot-72a754f3","name":"Rubric Scoring — String Normalisation + Date by Category Pivot","description":"Rubric scoring — String normalisation + Date by category pivot: String normalisation + Date by category pivot for supplied rubric scoring records (awarded_points, available_points). 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-17-035?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","course_group","date","awarded_points","available_points"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"course_group":{"type":"string","default":"","maxLength":80},"awarded_points":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"available_points":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","course_group":"group-a","awarded_points":10,"available_points":1},{"date":"2026-10-02","row_id":"row-2","course_group":"group-b","awarded_points":20,"available_points":2},{"date":"2026-10-03","row_id":"row-3","course_group":"group-a","awarded_points":15,"available_points":3},{"date":"2026-10-04","row_id":"row-4","course_group":"group-b","awarded_points":30,"available_points":4}],"maxItems":200,"minItems":1},"field":{"enum":["awarded_points","available_points"],"type":"string","default":"awarded_points"}}},"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_kxup9figZDS_tqScsGuCJ","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":"Applies string normalisation and a date-by-category pivot analysis to up to 200 rubric scoring rows (awarded_points, available_points), returning two local analytical reports.","exampleAgentPrompt":"I have 150 rubric scoring records with course_group, date, awarded_points, and available_points columns — can you run string normalisation on the text fields and produce a date-by-category pivot for awarded_points across all rows?","exampleUseCases":[{"title":"Course group performance pivot","prompt":"I've got rubric scores for two course groups — group-a and group-b — across October 2026, with awarded_points and available_points for each row. Can you normalise the string fields and give me a pivot of awarded_points broken down by date and course group?"},{"title":"Multi-week assessment trend analysis","prompt":"Here are 180 rubric scoring records from our semester assessments, each tagged with a course_group and a date. Please run string normalisation and generate a date-by-category pivot on available_points so I can see trends across groups week by week."},{"title":"Grader data cleanup and summary","prompt":"Our graders submitted rubric data with inconsistent course group labels and dates ranging from 2026-09-01 to 2026-11-30. Can you normalise the strings and pivot awarded_points by date and category so I can review scoring patterns across the term?"}],"resultDescription":"Two analytical reports: (1) a string-normalised version of the supplied rubric scoring rows with cleaned course_group and text fields, and (2) a date-by-category pivot table showing the selected field (awarded_points or available_points) aggregated across course groups and dates. Both reports are computed locally from supplied data with no external lookups.","failureModes":["More than 200 rows submitted — request rejected, reduce batch size","Missing required fields (row_id, date, awarded_points, available_points) — validation error","Invalid date format (not YYYY-MM-DD) — schema validation failure","Null values in awarded_points or available_points may affect pivot aggregation","Empty rows array — minItems:1 constraint violation"],"whenToPreferThis":"Use this endpoint when you have up to 200 rubric scoring records and need both string normalisation of categorical fields and a date-by-category pivot in a single low-cost call ($0.01 USDC for both reports). Prefer this over general analytics tools when your data is already structured with row_id, course_group, date, awarded_points, and available_points fields and you want offline, deterministic analytical output with no external data dependencies.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T00:38:58.815Z","isFirstParty":false,"canonicalSlug":"rubric-scoring-string-normalisation-date-by-category-pivot-72a754f3"}