{"uid":"cap_-vZGKRDH664c8HLbYXYRW","slug":"tutoring-sessions-duplicate-key-report-date-by-category-pivot-8bb63a81","name":"Tutoring Sessions Duplicate Key Report + Date by Category Pivot","description":"Tutoring sessions — Duplicate key report + Date by category pivot: Duplicate key report + Date by category pivot for supplied tutoring sessions records (session_minutes, session_count). 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-16-068?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","course_group","date","session_minutes","session_count"],"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},"session_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"session_minutes":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","course_group":"group-a","session_count":1,"session_minutes":10},{"date":"2026-10-02","row_id":"row-2","course_group":"group-b","session_count":2,"session_minutes":20},{"date":"2026-10-03","row_id":"row-3","course_group":"group-a","session_count":3,"session_minutes":15},{"date":"2026-10-04","row_id":"row-4","course_group":"group-b","session_count":4,"session_minutes":30}],"maxItems":200,"minItems":1},"field":{"enum":["session_minutes","session_count"],"type":"string","default":"session_minutes"}}},"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_Io3fyxyXqRmjf391tzBYi","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 tutoring session records to produce two reports: a duplicate key report and a date-by-category pivot for session_minutes or session_count.","exampleAgentPrompt":"I have a list of tutoring session records with row IDs, course groups, dates, session minutes, and session counts — can you run a duplicate key report and a date-by-category pivot on session_minutes for me? Here's the data: row-1, group-a, 2026-10-01, 10 minutes, 1 session; row-2, group-b, 2026-10-02, 20 minutes, 2 sessions; row-3, group-a, 2026-10-03, 15 minutes, 3 sessions.","exampleUseCases":[{"title":"Audit tutoring records for duplicates","prompt":"I've got up to 150 tutoring session rows with row IDs and course groups — can you run a duplicate key report on them and also give me a date-by-category pivot on session_minutes? Here's the data: row-1, group-a, 2026-10-01, 45 minutes, 1 session; row-2, group-a, 2026-10-01, 30 minutes, 2 sessions; row-3, group-b, 2026-10-02, 60 minutes, 3 sessions."},{"title":"Pivot session counts by course group","prompt":"Can you take my tutoring session dataset and produce a date-by-category pivot on session_count broken down by course group, plus flag any duplicate row IDs? The records are: row-1, group-math, 2026-11-01, 60, 4 sessions; row-2, group-science, 2026-11-02, 45, 2 sessions; row-3, group-math, 2026-11-01, 30, 1 session."},{"title":"Cross-tabulate weekly tutoring minutes","prompt":"I want to see how session_minutes break down by date and course group across my weekly tutoring records, and also get a duplicate key report — here are my rows: row-1, group-a, 2026-12-01, 90, 3 sessions; row-2, group-b, 2026-12-02, 60, 2 sessions; row-3, group-a, 2026-12-03, 45, 1 session; row-4, group-b, 2026-12-01, 75, 4 sessions."}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying any row_id values that appear more than once in the input data, and (2) a date-by-category pivot table cross-tabulating the selected metric (session_minutes or session_count) across dates and course groups. Both reports are derived purely from the supplied input rows with no external data access.","failureModes":["Input exceeds 200 rows — request will be rejected or truncated","Missing required fields (row_id, course_group, date, session_minutes, session_count) cause validation errors","Invalid date format (not YYYY-MM-DD) triggers schema validation failure","Numeric values outside allowed range (-1,000,000,000,000 to 1,000,000,000,000) are rejected","Empty rows array returns an error","Invalid field enum value (not session_minutes or session_count) causes rejection","Payment of 0.01 USDC not provided or rejected blocks request"],"whenToPreferThis":"Choose this endpoint when you need two specific analytical operations on tutoring session data in a single call: duplicate key detection and a date-by-category pivot. It is ideal for education analytics workflows where you want to audit data quality (duplicates) and summarize session metrics (minutes or count) by course group and date, all without sending data to an external live service. At $0.01 for both reports on up to 200 rows, it is cost-effective for batch education record analysis.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T18:51:21.712Z","isFirstParty":false,"canonicalSlug":"tutoring-sessions-duplicate-key-report-date-by-category-pivot-8bb63a81"}