{"uid":"cap_n3IpOFbcn-wNmneilDV3A","slug":"sampling-observations-exact-row-deduplication-daily-sum-series-3e7eb9c4","name":"Sampling Observations — Exact Row Deduplication + Daily Sum Series","description":"Sampling observations — Exact row deduplication + Daily sum series: Exact row deduplication + Daily sum series 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-044?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"}}},"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_TOEgJybxeu4Uz2NSy5yBd","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 rows and computes daily sum time series for up to 200 sampling observation records with sample_value and sample_weight fields.","exampleAgentPrompt":"I have a batch of sampling observations with row IDs, dates, groups, sample values, and sample weights — can you deduplicate exact duplicate rows and then give me a daily sum series for the sample_value field? Here's my data: row-1, group-a, 2026-10-01, value 10, weight 1; row-2, group-b, 2026-10-02, value 20, weight 2; row-3, group-a, 2026-10-01, value 10, weight 1 (duplicate of row-1).","exampleUseCases":[{"title":"Cleaning duplicated survey records","prompt":"I collected survey samples and suspect some rows were submitted twice — can you run exact row deduplication on my dataset of up to 200 records (with row IDs, dates, dataset groups, sample values, and weights) and also show me the daily sum series for sample_value so I can see totals per day after deduplication?"},{"title":"Daily aggregation for sensor readings","prompt":"I have sensor sampling data with dates, group labels, sample values, and weights for about 150 rows — please deduplicate any exact repeats and compute the daily sum series for the sample_weight field so I can track total weight captured each day."},{"title":"Validating ETL pipeline output","prompt":"Our ETL pipeline output a batch of sampling observation records and I need to check for exact row duplicates and also see a daily sum of sample_value — can you run both reports on my 80-row dataset with row IDs, dates, dataset_group, sample_value, and sample_weight?"}],"resultDescription":"Two analytical reports: (1) a deduplicated record set with exact duplicate rows identified and removed, and (2) a daily sum time series for the selected field (sample_value or sample_weight), computed from the supplied rows. No external data is fetched; all analysis is performed locally on the provided rows.","failureModes":["Missing required fields (row_id, date, dataset_group) returns a validation error","Date strings not matching YYYY-MM-DD pattern are rejected","Exceeding 200 rows returns an error about the row limit","Null values in sample_value or sample_weight may affect sum calculations","Empty rows array is rejected (minItems: 1)","Invalid field enum value (not 'sample_value' or 'sample_weight') causes an error"],"whenToPreferThis":"Choose this endpoint when you have up to 200 sampling observation rows and need both exact row deduplication AND a daily sum series in a single low-cost call ($0.01 USDC). It is ideal for data pipeline QA, survey data cleaning, or sensor data validation where you need two complementary analytical views on the same dataset without external lookups or predictions.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T12:39:04.752Z","isFirstParty":false,"canonicalSlug":"sampling-observations-exact-row-deduplication-daily-sum-series-3e7eb9c4"}