{"uid":"cap_zLV0Eifa06_X_QmQd7iUy","slug":"survey-participation-exact-row-deduplication-category-frequencies-d9a05e30","name":"Survey Participation — Exact Row Deduplication + Category Frequencies","description":"Survey participation — Exact row deduplication + Category frequencies: Exact row deduplication + Category frequencies for supplied survey participation records (respondents, invitations). 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-10-041?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","course_group","date","respondents","invitations"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"invitations":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"respondents":{"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","invitations":1,"respondents":10,"course_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","invitations":2,"respondents":20,"course_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","invitations":3,"respondents":15,"course_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","invitations":4,"respondents":30,"course_group":"group-b"}],"maxItems":200,"minItems":1}}},"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_8RlxkHccVXNVevMco6xiW","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 survey participation records and computes category-level frequency distributions across course groups, returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"Can you deduplicate these survey participation records and give me a frequency breakdown by course group? I have about 150 rows with columns for row_id, course_group, date, respondents, and invitations — I need both an exact duplicate report and category frequency counts.","exampleUseCases":[{"title":"Clean duplicate survey response exports","prompt":"I exported our weekly survey participation data and I think there are duplicate rows. Can you deduplicate these records and tell me how many times each course group appears? I have 120 rows with row_id, course_group, date, respondents, and invitations fields."},{"title":"Course group frequency audit","prompt":"I need a frequency count of how many survey records belong to each course group in this dataset — I have 80 participation rows with course_group, date, respondents, and invitations. Also flag any exact duplicate rows while you're at it."},{"title":"Survey data quality check before reporting","prompt":"Before I submit our education survey report, can you run a deduplication check and compute category frequencies on these 60 participation records? Each row has a row_id, course_group, date, respondent count, and invitation count."}],"resultDescription":"Returns two reports: (1) an exact row deduplication report identifying which of the up to 200 input rows are duplicates and providing a deduplicated record set, and (2) a category frequency report showing how often each distinct course_group value appears across the supplied rows.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, course_group, date, respondents, invitations) cause rejection","Invalid date format (non-YYYY-MM-DD) triggers a pattern validation error","Numeric values outside the allowed range cause schema rejection","Empty rows array is rejected due to minItems:1 constraint"],"whenToPreferThis":"Choose this endpoint when you have survey participation data (with respondents, invitations, course groups) and need two quick offline analytical reports — exact row deduplication and category frequency counts — without requiring any external lookup, live data, or prediction. Ideal for education survey data pipelines where dataset size is under 200 rows and cost-efficiency ($0.01 for both reports) matters.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T12:36:13.262Z","isFirstParty":false,"canonicalSlug":"survey-participation-exact-row-deduplication-category-frequencies-d9a05e30"}