{"uid":"cap_EzLTImU52dLIdNixwW7_7","slug":"lab-observations-string-normalisation-exact-row-deduplication-608310a4","name":"Lab Observations — String Normalisation + Exact Row Deduplication","description":"Lab observations — String normalisation + Exact row deduplication: String normalisation + Exact row deduplication for supplied lab observations records (measurement, replicate_count). 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-06-020?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","course_group","date","measurement","replicate_count"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"measurement":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"course_group":{"type":"string","default":"","maxLength":80},"replicate_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","measurement":10,"course_group":"group-a","replicate_count":1},{"date":"2026-10-02","row_id":"row-2","measurement":20,"course_group":"group-b","replicate_count":2},{"date":"2026-10-03","row_id":"row-3","measurement":15,"course_group":"group-a","replicate_count":3},{"date":"2026-10-04","row_id":"row-4","measurement":30,"course_group":"group-b","replicate_count":4}],"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_zAkdN0Zq8GVSlRvXmeWOo","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":"Normalises strings and removes exact duplicate rows from lab observation records containing measurement and replicate_count fields, returning 2 independent analytical reports for up to 200 rows.","exampleAgentPrompt":"Can you clean up my lab observation data by normalising all the string fields and removing any exact duplicate rows? I have about 150 records, each with a row_id, course_group like 'group-a', a date, a measurement value, and a replicate_count.","exampleUseCases":[{"title":"Deduplicating student lab experiment records","prompt":"I have 120 lab observation rows from student experiments, each with a row_id, course_group, date, measurement, and replicate_count — can you normalise the string fields and strip out any exact duplicate rows before I run my analysis?"},{"title":"Cleaning measurement data before statistical reporting","prompt":"Before I hand off my lab data to the stats team, can you run string normalisation and exact deduplication on these 80 observation records? They have measurement values and replicate counts that might have duplicate entries from data entry errors."},{"title":"Auditing course group lab records for data quality","prompt":"I've got lab observations from multiple course groups with about 60 rows — can you normalise the course_group strings and remove any completely duplicate rows so the dataset is clean?"}],"resultDescription":"Returns 2 independent analytical reports covering: (1) string normalisation results showing standardised values for string fields (course_group, date, row_id), and (2) exact row deduplication results identifying and removing fully duplicate records from the supplied lab observation dataset of up to 200 rows.","failureModes":["More than 200 rows submitted — request exceeds maxItems limit and will be rejected","Missing required fields (row_id, course_group, date, measurement, replicate_count) on any row causes validation failure","Invalid date format (not YYYY-MM-DD) triggers schema validation error","measurement or replicate_count values outside [-1000000000000, 1000000000000] range rejected","Empty rows array (minItems: 1 not met) causes rejection","row_id exceeding 80 characters or empty string causes validation error"],"whenToPreferThis":"Choose this endpoint when you have lab observation data (with measurement and replicate_count fields) that needs both string normalisation and exact duplicate removal in a single pass, and your dataset is 200 rows or fewer. It is suited for educational or scientific lab data pipelines where course group labels and row identifiers may have inconsistent capitalisation or whitespace, and where exact duplicate records need to be identified and removed prior to downstream analysis. It performs no external lookups, predictions, or live data access — ideal when you want a deterministic, local data-cleaning step.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T12:41:58.042Z","isFirstParty":false,"canonicalSlug":"lab-observations-string-normalisation-exact-row-deduplication-608310a4"}