{"uid":"cap_J8KDBCgPheDAyxUgSvSu6","slug":"vendor-evaluation-exact-row-deduplication-date-by-category-pivot-b6171d41","name":"Vendor Evaluation — Exact Row Deduplication + Date by Category Pivot","description":"Vendor evaluation — Exact row deduplication + Date by category pivot: Exact row deduplication + 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-052?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_3fYgt0pxxH9kbAQpkC-hK","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 exact duplicate rows and generates a date-by-category pivot report for vendor evaluation records containing supplied_score and maximum_score fields.","exampleAgentPrompt":"Can you clean up my vendor evaluation data by removing exact duplicate rows and then build a pivot table of supplied_score grouped by company group across dates? I have up to 50 rows with fields like row_id, company_group, date, supplied_score, and maximum_score.","exampleUseCases":[{"title":"Procurement team deduplication report","prompt":"I have 120 vendor evaluation records with company_group, date, supplied_score, and maximum_score — some rows are exact duplicates. Can you deduplicate them and also give me a pivot of supplied_score by company group and date so I can see which vendors scored highest each month?"},{"title":"Quarterly supplier scorecard pivot","prompt":"Our supplier scoring dataset for Q3 has entries for about 80 vendors across groups like 'group-a' and 'group-b' with dates ranging from 2026-07-01 to 2026-09-30. Can you remove any exact duplicate rows and then pivot the maximum_score values by category and date for our scorecard review?"},{"title":"Data quality check before vendor review meeting","prompt":"Before our vendor review meeting I need to make sure our evaluation spreadsheet has no duplicate rows — it has fields row_id, company_group, date, supplied_score, and maximum_score across about 60 entries. Run deduplication and give me a date-by-category pivot on supplied_score so I can spot any gaps."}],"resultDescription":"Returns two analytical reports: (1) an exact row deduplication report identifying and removing duplicate vendor evaluation records, and (2) a date-by-category pivot table showing the selected score field (supplied_score or maximum_score) broken down by company_group across dates. Covers up to 200 input rows with no external lookups or live data.","failureModes":["Input exceeds 200 rows — request rejected with validation error","Missing required fields (row_id, date, company_group, supplied_score, maximum_score) cause row rejection","Invalid date format (non-YYYY-MM-DD) fails pattern validation","Numeric values outside allowed range (-1e12 to 1e12) are rejected","Empty rows array returns error","Field enum value other than 'supplied_score' or 'maximum_score' is rejected"],"whenToPreferThis":"Choose this endpoint when you have vendor evaluation records with supplied_score and maximum_score and need both exact-duplicate removal and a date-by-category pivot in one low-cost call (up to 200 rows for $0.01 USDC). It is ideal for offline batch data cleaning and reporting workflows where no live lookup, prediction, or external action is needed. Prefer it over generic analytics tools when you specifically need the dual-report output (dedup + pivot) tailored to vendor evaluation schemas.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T18:50:10.036Z","isFirstParty":false,"canonicalSlug":"vendor-evaluation-exact-row-deduplication-date-by-category-pivot-b6171d41"}