{"uid":"cap_2rtYroit6Wael6U7wp-a0","slug":"vendor-evaluation-category-frequencies-date-by-category-pivot-0cea4b0d","name":"Vendor Evaluation — Category Frequencies + Date by Category Pivot","description":"Vendor evaluation — Category frequencies + Date by category pivot: Category frequencies + Date by category pivot for supplied vendor evaluation records (supplied_score, maximum_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-company-10-110?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","supplied_score","maximum_score"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"company_group":{"type":"string","default":"","maxLength":80},"maximum_score":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"supplied_score":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_group":"group-a","maximum_score":1,"supplied_score":10},{"date":"2026-10-02","row_id":"row-2","company_group":"group-b","maximum_score":2,"supplied_score":20},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","maximum_score":3,"supplied_score":15},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","maximum_score":4,"supplied_score":30}],"maxItems":200,"minItems":1},"field":{"enum":["supplied_score","maximum_score"],"type":"string","default":"supplied_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_AC381GIiAKCQWfyh7cVCd","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":"Computes category frequency counts and a date-by-category pivot table for vendor evaluation records with supplied_score and maximum_score fields.","exampleAgentPrompt":"Can you analyze my vendor evaluation data and give me two reports — one showing how often each company group appears (category frequencies) and one pivoting scores by date and company group? Here are up to 200 rows with row_id, company_group, date, supplied_score, and maximum_score fields, and I want to analyze the supplied_score column.","exampleUseCases":[{"title":"Vendor category distribution audit","prompt":"I have 150 vendor evaluation records with company groups like 'APAC Suppliers', 'EMEA Vendors', and 'Domestic Contractors' — can you run a category frequency report and a date-by-category pivot on the supplied_score field so I can see which groups dominate and how scores shift over time?"},{"title":"Quarterly supplier score pivot","prompt":"Can you take my Q3 vendor evaluation dataset — up to 180 rows with row_id, company_group, date, supplied_score, and maximum_score — and produce a category frequency table plus a date-by-company-group pivot for supplied_score so I can spot any scoring patterns by month?"},{"title":"Procurement team vendor ranking summary","prompt":"I need two reports on my vendor evaluation records: first, how frequently each company group shows up, and second, a pivot of maximum_score by date and company group — I have about 90 rows I want to pass in."}],"resultDescription":"Two independent analytical reports: (1) a category frequency table showing how many records exist per company_group, and (2) a date-by-category pivot table showing the specified numeric field (supplied_score or maximum_score) broken down by date and company_group. Both reports are computed locally from the supplied rows with no external lookups.","failureModes":["Missing required fields (row_id, company_group, date, supplied_score, maximum_score) cause validation errors","Date fields not matching YYYY-MM-DD pattern are rejected","Exceeding 200 rows results in rejection","Null or out-of-range numeric values may affect aggregation outputs","Empty rows array is not accepted (minItems: 1)"],"whenToPreferThis":"Choose this endpoint when you need two quick analytical reports — category frequency counts and a date-by-category pivot — on vendor evaluation data with scored records, without requiring any external data enrichment, predictions, or professional assessments. It is ideal for procurement analysts wanting fast, local computation on up to 200 rows at very low cost ($0.01 USDC for both reports).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T18:51:27.039Z","isFirstParty":false,"canonicalSlug":"vendor-evaluation-category-frequencies-date-by-category-pivot-0cea4b0d"}