{"uid":"cap_butLAtN2v4tRW1uJXniaa","slug":"tourism-observations-two-measure-correlation-date-by-category-pivot-eec67396","name":"Tourism Observations — Two-Measure Correlation + Date-by-Category Pivot","description":"Tourism observations — Two-measure correlation + Date by category pivot: Two-measure correlation + Date by category pivot for supplied tourism observations records (visitor_count, overnight_stays). 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-economics-14-182?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","region","date","visitor_count","overnight_stays"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"region":{"type":"string","default":"","maxLength":80},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"visitor_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"overnight_stays":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","region":"group-a","row_id":"row-1","visitor_count":10,"overnight_stays":1},{"date":"2026-10-02","region":"group-b","row_id":"row-2","visitor_count":20,"overnight_stays":2},{"date":"2026-10-03","region":"group-a","row_id":"row-3","visitor_count":15,"overnight_stays":3},{"date":"2026-10-04","region":"group-b","row_id":"row-4","visitor_count":30,"overnight_stays":4}],"maxItems":200,"minItems":1},"field":{"enum":["visitor_count","overnight_stays"],"type":"string","default":"visitor_count"}}},"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_jA4rW1fgCeho6HYeV2DlT","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 a two-measure Pearson/rank correlation and a date-by-category pivot table for up to 200 rows of tourism observation data (visitor_count, overnight_stays).","exampleAgentPrompt":"Run a two-measure correlation between visitor_count and overnight_stays, plus a date-by-region pivot, on my tourism dataset — I have 4 rows: row-1 on 2026-10-01 region group-a with 10 visitors and 1 overnight stay, row-2 on 2026-10-02 region group-b with 20 visitors and 2 stays, row-3 on 2026-10-03 region group-a with 15 visitors and 3 stays, and row-4 on 2026-10-04 region group-b with 30 visitors and 4 stays.","exampleUseCases":[{"title":"Seasonal visitor-stay correlation check","prompt":"I have monthly tourism data for 8 regions over the past year — can you compute the correlation between visitor_count and overnight_stays across all those rows, and also give me a pivot table showing overnight_stays broken down by date and region?"},{"title":"Regional campaign impact pivot","prompt":"After our summer tourism campaign we collected visitor and overnight stay figures for 5 regions across 40 dates. Can you run a date-by-region pivot on the overnight_stays field and also tell me how strongly visitor_count correlates with overnight_stays in this dataset?"},{"title":"Hotel capacity planning analysis","prompt":"I'm trying to understand whether higher visitor counts reliably translate to more overnight stays across our resort zones — here are 150 rows of observations with row IDs, dates, region names, visitor counts, and overnight stay figures. Please run the two-measure correlation and a date-by-category pivot using visitor_count as the main field."}],"resultDescription":"Returns two statistical reports: (1) a Pearson or rank correlation coefficient between visitor_count and overnight_stays across all supplied rows, and (2) a pivot table cross-tabulating the specified field (visitor_count or overnight_stays) by date and region/category — all computed locally on the supplied data with no external lookups.","failureModes":["Fewer than 1 row supplied — request rejected","More than 200 rows supplied — exceeds maxItems limit","Missing required fields (row_id, region, date, visitor_count, overnight_stays) on any row — validation error","Date strings not matching YYYY-MM-DD pattern — schema validation failure","All values for one measure are null — correlation cannot be computed","Invalid field enum value (not visitor_count or overnight_stays) — schema rejection"],"whenToPreferThis":"Choose this endpoint when you have structured tourism observation records with visitor_count and overnight_stays columns and need both a cross-measure correlation and a date-by-category pivot in a single low-cost call. It is ideal for offline/batch analytical needs on datasets up to 200 rows where no live data lookup, prediction, or external enrichment is required. Prefer it over general-purpose analytics tools when you want a cheap, deterministic, self-contained computation on data you already hold.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-28T06:48:23.959Z","isFirstParty":false,"canonicalSlug":"tourism-observations-two-measure-correlation-date-by-category-pivot-eec67396"}