{"uid":"cap_muolvm3rAyfYnIyhsDNz7","slug":"thesis-milestones-string-normalisation-date-by-category-pivot-3faceb82","name":"Thesis Milestones — String Normalisation + Date by Category Pivot","description":"Thesis milestones — String normalisation + Date by category pivot: String normalisation + Date by category pivot for supplied thesis milestones records (completed_milestones, planned_milestones). 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-21-035?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","course_group","date","completed_milestones","planned_milestones"],"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},"planned_milestones":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"completed_milestones":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","course_group":"group-a","planned_milestones":1,"completed_milestones":10},{"date":"2026-10-02","row_id":"row-2","course_group":"group-b","planned_milestones":2,"completed_milestones":20},{"date":"2026-10-03","row_id":"row-3","course_group":"group-a","planned_milestones":3,"completed_milestones":15},{"date":"2026-10-04","row_id":"row-4","course_group":"group-b","planned_milestones":4,"completed_milestones":30}],"maxItems":200,"minItems":1},"field":{"enum":["completed_milestones","planned_milestones"],"type":"string","default":"completed_milestones"}}},"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_upwVmAbZsDEfHU4Yj_5Tv","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":"Runs two analytical reports on thesis milestone data: string normalisation and a date-by-category pivot for completed and planned milestones across course groups.","exampleAgentPrompt":"Can you run the string normalisation and date-by-category pivot reports on my thesis milestone data? I have rows for group-a and group-b with dates from 2026-10-01 to 2026-10-04, tracking completed_milestones — here are the records.","exampleUseCases":[{"title":"Track thesis progress by department","prompt":"I have milestone records for two course groups over the past month — can you normalise the strings and pivot the completed_milestones data by date and course group so I can see progress at a glance?"},{"title":"Compare planned vs completed milestones","prompt":"Run the date-by-category pivot on my thesis dataset using the planned_milestones field — I have about 80 rows across group-a, group-b, and group-c with weekly dates, and I need to see how planning breaks down by group."},{"title":"Clean messy milestone records before reporting","prompt":"My thesis milestone spreadsheet has inconsistent string formatting across course groups and I need both a normalised version and a pivot table of completed_milestones by date — can you process these 150 rows for me?"}],"resultDescription":"Two analytical reports: (1) a string-normalised version of the submitted milestone records, and (2) a date-by-category pivot table showing the selected milestone field (completed_milestones or planned_milestones) broken down by course_group across dates — all computed locally with no external lookups.","failureModes":["Rows exceeding 200 items will be rejected","Missing required fields (row_id, course_group, date, completed_milestones, planned_milestones) will cause validation errors","Dates not matching YYYY-MM-DD pattern will fail schema validation","Invalid field enum value (must be completed_milestones or planned_milestones) will error","Numeric values outside the allowed range will be rejected"],"whenToPreferThis":"Choose this endpoint when you need both string normalisation and a date-by-category pivot on thesis milestone data in a single low-cost call ($0.01 USDC for both reports). It is best suited for small batch analysis (up to 200 rows) of academic milestone records with course group segmentation, where no live data lookup or external prediction is required.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-24T12:53:08.452Z","isFirstParty":false,"canonicalSlug":"thesis-milestones-string-normalisation-date-by-category-pivot-3faceb82"}