{"uid":"cap_xZvjcHCqgmMX3BzOWHl1-","slug":"sampling-observations-date-by-category-pivot-keyed-dataset-comparison-6a04c7a9","name":"Sampling Observations — Date-by-Category Pivot + Keyed Dataset Comparison","description":"Sampling observations — Date by category pivot + Keyed dataset comparison: Date by category pivot + Keyed dataset comparison for supplied sampling observations records (sample_value, sample_weight). 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-analytics-15-188?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","sample_value","sample_weight"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"sample_value":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"sample_weight":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","sample_value":10,"dataset_group":"group-a","sample_weight":1},{"date":"2026-10-02","row_id":"row-2","sample_value":20,"dataset_group":"group-b","sample_weight":2},{"date":"2026-10-03","row_id":"row-3","sample_value":15,"dataset_group":"group-a","sample_weight":3},{"date":"2026-10-04","row_id":"row-4","sample_value":30,"dataset_group":"group-b","sample_weight":4}],"maxItems":200,"minItems":1},"field":{"enum":["sample_value","sample_weight"],"type":"string","default":"sample_value"},"other":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","sample_value","sample_weight"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"sample_value":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80},"sample_weight":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","sample_value":10,"dataset_group":"group-a","sample_weight":1},{"date":"2026-10-02","row_id":"row-2","sample_value":21,"dataset_group":"group-b","sample_weight":2},{"date":"2026-10-03","row_id":"row-3","sample_value":17,"dataset_group":"group-a","sample_weight":3},{"date":"2026-10-04","row_id":"row-4","sample_value":33,"dataset_group":"group-b","sample_weight":4}],"maxItems":200,"minItems":0}}},"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_evu8F-hCkaMj_CCclmlIp","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 supplied sampling observation records: a date-by-category pivot table and a keyed dataset comparison between two datasets, for up to 200 rows.","exampleAgentPrompt":"I have two sets of sampling records — each row has a date, a category group, a sample_value, and a sample_weight — can you pivot the first dataset by date and category and also compare the two datasets row-by-row using sample_value?","exampleUseCases":[{"title":"A/B test sampling comparison","prompt":"I ran two rounds of a sampling study with up to 150 rows each. Both have row IDs, dates, group labels, and sample values. Can you pivot round one by date and category, and then compare round one versus round two to see where the values diverged?"},{"title":"Survey weight distribution pivot","prompt":"I have survey response data with dates, respondent groups, sample values, and weights for about 80 records. Can you build a date-by-category pivot using sample_weight and also compare it against last month's survey using the same structure?"},{"title":"Quality control dataset diff","prompt":"We have two versions of our weekly sampling dataset — both have row IDs, dates, category groups, and sample values. Please pivot the current version by date and group, and flag any rows where the sample_value differs between the two versions."}],"resultDescription":"Two independent analytical reports: (1) a date-by-category pivot table showing the chosen field (sample_value or sample_weight) broken down across date rows and dataset_group columns, and (2) a keyed dataset comparison that aligns rows from both supplied datasets by row_id and highlights differences in the selected numeric field between the two datasets.","failureModes":["Missing required fields (row_id, dataset_group, date, sample_value, sample_weight) cause validation errors","Date strings not matching YYYY-MM-DD pattern are rejected","Exceeding 200 rows per dataset returns an error","Invalid field enum value (not 'sample_value' or 'sample_weight') causes rejection","Empty rows array returns an error","Payment of 0.01 USDC not included causes 402 response"],"whenToPreferThis":"Choose this endpoint when you have structured sampling observation records with dates, category groups, and numeric values and need both a pivot-style cross-tabulation AND a keyed comparison between two datasets in a single call. It is ideal for survey data, A/B test results, quality-control diffs, or any scenario where you want to inspect category trends over time and simultaneously diff two dataset versions — all without external lookups or live data fetches.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T12:38:43.841Z","isFirstParty":false,"canonicalSlug":"sampling-observations-date-by-category-pivot-keyed-dataset-comparison-6a04c7a9"}