Please refer this note for Athena Data Import. 日本語版はこちらのノートを参照してください。
Was this page helpful?
{"docsConfig":{"theme":"aspen","$schema":"https://mintlify.com/docs.json","name":"Exploratory","description":"Documentation for Exploratory Desktop, Exploratory Server, MCP and CLI.","colors":{"primary":"#00ab6d","light":"#00ab6d","dark":"#00ab6d"},"logo":{"light":"https://mintcdn.com/exploratory-inc/t8wulpy3B474-b7T/en/markdown/images/logo_top.png?fit=max\u0026auto=format\u0026n=t8wulpy3B474-b7T\u0026q=85\u0026s=370661a35e27b492bc5d04396b5573fd","dark":"https://mintcdn.com/exploratory-inc/t8wulpy3B474-b7T/en/markdown/images/logo_top.png?fit=max\u0026auto=format\u0026n=t8wulpy3B474-b7T\u0026q=85\u0026s=370661a35e27b492bc5d04396b5573fd"},"favicon":"https://mintcdn.com/exploratory-inc/-5HxVvjEaUz0PUYx/images/favicon.png?fit=max\u0026auto=format\u0026n=-5HxVvjEaUz0PUYx\u0026q=85\u0026s=cfad2e8089c2c5293daafa43ede7e311","appearance":{"default":"light","strict":true},"seo":{"metatags":{"canonical":"https://docs.exploratory.io"}},"styling":{"latex":false},"navigation":{"languages":[{"language":"en","default":true,"href":"en"},{"language":"ja","href":"ja"}]}},"deployment":{"deploymentMetadataValue":{"subdomain":"exploratory-inc","hasAudioNarration":false,"actualSubdomain":"exploratory-inc","customDomains":["docs.exploratory.io"],"gitSource":{"type":"github","owner":"exploratory-io","repo":"book","deployBranch":"master","contentDirectory":"","isPrivate":false,"mountPath":"","label":"","_id":"6afd1e9171d298464993c5e4"},"feedback":{"thumbs":true},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6afd65cb9b4313a2fa6fa015","clientVersion":"0.0.4177","searchFilterCounts":[{"language":"en","tag":"Exploratory","count":327},{"language":"ja","tag":"Exploratory","count":79},{"language":"en","tag":"Visualization","count":56},{"language":"en","tag":"Data Import","count":53},{"language":"en","tag":"Data Wrangling","count":48},{"language":"en","tag":"Analytics","count":37},{"language":"en","tag":"Exploratory CLI","count":33},{"language":"ja","tag":"Exploratory CLI","count":33},{"language":"en","tag":"Features","count":31},{"language":"en","tag":"Server","count":30},{"language":"ja","tag":"Server","count":30},{"language":"en","tag":"Machine Learning","count":26},{"language":"en","tag":"Product Features","count":25},{"language":"ja","tag":"Desktop","count":24},{"language":"ja","tag":"Exploratory MCP","count":21},{"language":"ja","tag":"リファレンス","count":17},{"language":"ja","tag":"はじめる","count":16},{"language":"ja","tag":"使い方","count":15},{"language":"ja","tag":"製品の機能","count":12},{"language":"ja","tag":"AI ツールから追加する","count":8}],"searchSettings":{"showContentSnippets":true}},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableContextualStarterQuestions":false,"enableAskAiSearchBar":true},"basePath":"","hasChatPermissions":true,"hasWebMcpPermissions":true,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"starter-pricing","enabled":true,"variant":{"name":"control","enabled":true,"payload":{"type":"string","value":"control"},"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"wildcard-email-auth","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[{"filePath":"en/styles/website.css","content":""},{"filePath":"style.css","content":"@media (min-width: 1024px){#navbar div:has(>#localization-select-trigger){position:absolute;right:1.5rem;top:50%;transform:translateY(-50%)}}#navbar a:has(>.nav-logo)::before,#navbar a:has(.nav-logo)::before{content:\"\";display:inline-block;flex:none;width:24px;height:24px;margin-right:8px;vertical-align:middle;background:url(\"/images/favicon.png\") center / contain no-repeat}#navbar a:has(.nav-logo){display:inline-flex;align-items:center}#navbar .nav-logo{height:20px}#sidebar-content .sidebar-title{display:none}#sidebar-content ul ul{margin-left:16px;padding-left:4px;border-left:1px solid #e5e9e7}#sidebar-content ul ul a,#sidebar-content ul ul button{padding-left:12px!important}.mdx-content a.link,.mdx-content a.link code{color:#00ab6d}.mdx-content a.link:hover{text-decoration:underline}.mdx-content table{border-collapse:separate;border-spacing:0;border:1px solid #e5e9e7;border-radius:8px;overflow:hidden}.mdx-content table thead,.mdx-content table tr{border:0}.mdx-content table th{padding:10px 12px!important;background:#f5f7f6;border-bottom:1px solid #e5e9e7}.mdx-content table td{padding:10px 12px!important;border-bottom:1px solid #eef1f0}.mdx-content table th+th,.mdx-content table td+td{border-left:1px solid #eef1f0}.mdx-content table tbody tr:last-child td{border-bottom:0}"}],"page":{"pagePath":"en/import/athena","slug":"/en/import/athena","pageMetadata":{"title":"Athena Data Import","sidebarTitle":"Amazon Athena","description":null,"href":"/en/import/athena"},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={a:`a`,p:`p`,..._provideComponents(),...props.components};return _jsxs(_Fragment,{children:[_jsxs(_components.p,{children:[`Please refer `,_jsx(_components.a,{href:`https://exploratory.io/note/2ac8ae888097/Connect-to-Amazon-Athena-with-Exploratory-with-ODBC-Data-Source-9617908787989852`,children:`this note`}),` for Athena Data Import.`]}),`\n`,_jsx(`br`,{}),`\n`,_jsxs(_components.p,{children:[`日本語版は`,_jsx(_components.a,{href:`https://exploratory.io/note/exploratory/Exploratory-Amazon-Athena-aIA9wSL1`,children:`こちらのノート`}),`を参照してください。`]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Athena Data Import","sidebarTitle":"Amazon Athena","description":null,"href":"/en/import/athena"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[],"codeExamples":{}},"jsLinks":[],"subdomain":"exploratory-inc","siteName":"Exploratory","title":"Athena Data Import - Exploratory","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{"en":{"href":"/en/import/athena","matchLevel":0},"ja":{"href":"/ja","matchLevel":3}}},"lastModified":"2026-11-18T05:10:16.803Z","originalFileLocation":"en/import/athena.md","locale":"en"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=\"light\";if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"light\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"application-name\" content=\"Exploratory\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/exploratory-inc/9mPjptrIZN2icevd/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/exploratory-inc/9mPjptrIZN2icevd/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/exploratory-inc/9mPjptrIZN2icevd/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/exploratory-inc/9mPjptrIZN2icevd/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/exploratory-inc/9mPjptrIZN2icevd/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/exploratory-inc/9mPjptrIZN2icevd/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/exploratory-inc/9mPjptrIZN2icevd/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/exploratory-inc/9mPjptrIZN2icevd/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/exploratory-inc/9mPjptrIZN2icevd/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Athena Data Import - Exploratory\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Exploratory\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.exploratory.io/en/import/athena\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://exploratory-inc.mintlify.site/_mintlify/api/og/v2?division=Database+Data\u0026amp;title=Athena+Data+Import\u0026amp;theme=d875c51dedd76fd973af8cde\u0026amp;signature=32ae76187809f2bb64dab9cfe18ffe7f0e6a5b4a27cbf8ec010d9db10d3af57b\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Athena Data Import - Exploratory\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://exploratory-inc.mintlify.site/_mintlify/api/og/v2?division=Database+Data\u0026amp;title=Athena+Data+Import\u0026amp;theme=d875c51dedd76fd973af8cde\u0026amp;signature=32ae76187809f2bb64dab9cfe18ffe7f0e6a5b4a27cbf8ec010d9db10d3af57b\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/exploratory-inc/9mPjptrIZN2icevd/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Exploratory\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#00ab6d\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.exploratory.io/en/import/athena\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/en/import/athena.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.exploratory.io/#organization\",\"name\":\"Exploratory\",\"url\":\"https://docs.exploratory.io\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/exploratory-inc/t8wulpy3B474-b7T/en/markdown/images/logo_top.png?fit=max\u0026auto=format\u0026n=t8wulpy3B474-b7T\u0026q=85\u0026s=370661a35e27b492bc5d04396b5573fd\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.exploratory.io#website\",\"name\":\"Exploratory\",\"url\":\"https://docs.exploratory.io\",\"publisher\":{\"@id\":\"https://docs.exploratory.io/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.exploratory.io/en/import/athena#webpage\",\"url\":\"https://docs.exploratory.io/en/import/athena\",\"name\":\"Athena Data Import\",\"dateModified\":\"2026-11-18T05:10:16.803Z\",\"isPartOf\":{\"@id\":\"https://docs.exploratory.io#website\"},\"breadcrumb\":{\"@id\":\"https://docs.exploratory.io/en/import/athena#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.exploratory.io/en/import/athena#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Exploratory\",\"item\":\"https://docs.exploratory.io/en\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Import\",\"item\":\"https://docs.exploratory.io/en/data_import\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Database Data\",\"item\":\"https://docs.exploratory.io/en/database-data\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Athena Data Import\",\"item\":\"https://docs.exploratory.io/en/import/athena\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.exploratory.io/en/import/athena#article\",\"headline\":\"Athena Data Import\",\"name\":\"Athena Data Import\",\"url\":\"https://docs.exploratory.io/en/import/athena\",\"mainEntityOfPage\":{\"@id\":\"https://docs.exploratory.io/en/import/athena#webpage\"},\"dateModified\":\"2026-11-18T05:10:16.803Z\",\"publisher\":{\"@id\":\"https://docs.exploratory.io/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.exploratory.io#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Exploratory\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"Exploratory\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/en/import/athena.md","siteName":"Exploratory","nav":{"global":null,"languages":[{"language":"en","default":true,"groups":[{"group":"Exploratory","pages":[{"title":"Exploratory Documentation","sidebarTitle":"Introduction","href":"/en"},{"group":"Exploratory MCP","root":{"title":"Exploratory MCP","href":"/en/mcp"},"pages":[{"group":"Server","root":{"title":"Exploratory MCP: Server","sidebarTitle":"Server","href":"/en/mcp/server"},"pages":[{"group":"Get started","root":{"title":"Get started","href":"/en/mcp/server/get-started"},"pages":[{"group":"Add from an AI tool","root":{"title":"Add from an AI tool","href":"/en/mcp/server/clients/apps"},"pages":[{"title":"Connect the Claude app","sidebarTitle":"Claude app","href":"/en/mcp/server/clients/claude"},{"title":"Connect the ChatGPT app","sidebarTitle":"ChatGPT app","href":"/en/mcp/server/clients/chatgpt"},{"title":"Connect Antigravity","sidebarTitle":"Antigravity","href":"/en/mcp/server/clients/antigravity"},{"title":"Connect Grok Bot","sidebarTitle":"Grok Bot","href":"/en/mcp/server/clients/grok-bot"},{"title":"Connect Claude Code","sidebarTitle":"Claude Code","href":"/en/mcp/server/clients/claude-code"},{"title":"Connect Codex","sidebarTitle":"Codex","href":"/en/mcp/server/clients/codex"},{"title":"Connect Cursor","sidebarTitle":"Cursor","href":"/en/mcp/server/clients/cursor"},{"title":"Connect other clients","sidebarTitle":"Other clients","href":"/en/mcp/server/clients/other"}]},{"title":"Authentication and API keys","href":"/en/mcp/server/auth"}]},{"title":"Use","href":"/en/mcp/server/use"},{"group":"Reference","root":{"title":"Reference","href":"/en/mcp/server/reference"},"pages":[{"title":"Tools","href":"/en/mcp/server/tools"},{"title":"Limits and errors","href":"/en/mcp/server/limits"},{"title":"Data and permissions","href":"/en/mcp/server/data"}]},{"title":"Troubleshooting","href":"/en/mcp/server/troubleshooting"}]},{"group":"Desktop","root":{"title":"Exploratory MCP: Desktop","sidebarTitle":"Desktop","href":"/en/mcp/desktop"},"pages":[{"group":"Get started","root":{"title":"Get started","href":"/en/mcp/desktop/get-started"},"pages":[{"title":"Install the plugin","href":"/en/mcp/desktop/install"},{"title":"Permissions and settings","href":"/en/mcp/desktop/permissions"}]},{"title":"Use","href":"/en/mcp/desktop/use"},{"group":"Reference","root":{"title":"Reference","href":"/en/mcp/desktop/reference"},"pages":[{"title":"Tools","href":"/en/mcp/desktop/tools"},{"title":"Limits and errors","href":"/en/mcp/desktop/limits"},{"title":"Data and permissions","href":"/en/mcp/desktop/data"}]},{"title":"Troubleshooting","href":"/en/mcp/desktop/troubleshooting"}]}]},{"group":"Exploratory CLI","root":{"title":"Exploratory CLI","href":"/en/cli"},"pages":[{"group":"Server","root":{"title":"Exploratory CLI: Server","sidebarTitle":"Server","href":"/en/cli/server"},"pages":[{"group":"Get started","root":{"title":"Get started","href":"/en/cli/server/get-started"},"pages":[{"title":"Installation","href":"/en/cli/server/install"},{"title":"Sign in","href":"/en/cli/server/login"},{"title":"API keys","href":"/en/cli/server/token"}]},{"group":"Use","root":{"title":"Use","href":"/en/cli/server/use"},"pages":[{"title":"Find data","href":"/en/cli/server/guides/find-data"},{"title":"Read notes","href":"/en/cli/server/guides/read-notes"},{"title":"Query data","href":"/en/cli/server/guides/query-data"},{"title":"Get chart numbers","href":"/en/cli/server/guides/dashboard-charts"},{"title":"Get analytics results","href":"/en/cli/server/guides/analytics"},{"title":"Save results to a file","href":"/en/cli/server/guides/export"},{"title":"Automation","href":"/en/cli/server/guides/automation"},{"title":"Use from AI agents","href":"/en/cli/server/guides/agents"}]},{"group":"Reference","root":{"title":"Reference","href":"/en/cli/server/reference"},"pages":[{"title":"All commands","href":"/en/cli/server/commands"},{"title":"Global flags","href":"/en/cli/server/global-flags"},{"title":"Exit codes and errors","href":"/en/cli/server/exit-codes"},{"title":"Data and permissions","href":"/en/cli/server/data"}]},{"title":"Troubleshooting","href":"/en/cli/server/troubleshooting"}]},{"group":"Desktop","root":{"title":"Exploratory CLI: Desktop","sidebarTitle":"Desktop","href":"/en/cli/desktop"},"pages":[{"group":"Get started","root":{"title":"Get started","href":"/en/cli/desktop/get-started"},"pages":[{"title":"Installation","href":"/en/cli/desktop/install"},{"title":"Choose a project","href":"/en/cli/desktop/guides/projects"}]},{"group":"Use","root":{"title":"Use","href":"/en/cli/desktop/use"},"pages":[{"title":"Import and wrangle data","href":"/en/cli/desktop/guides/wrangle-data"},{"title":"Create charts","href":"/en/cli/desktop/guides/create-charts"},{"title":"Create analytics","href":"/en/cli/desktop/guides/create-analytics"},{"title":"Write notes","href":"/en/cli/desktop/guides/write-notes"},{"title":"Duplicate dashboards","href":"/en/cli/desktop/guides/duplicate-dashboard"},{"title":"Publish","href":"/en/cli/desktop/guides/publish"},{"title":"Use from AI agents","href":"/en/cli/desktop/guides/agents"}]},{"group":"Reference","root":{"title":"Reference","href":"/en/cli/desktop/reference"},"pages":[{"title":"All commands","href":"/en/cli/desktop/commands"},{"title":"Global flags","href":"/en/cli/desktop/global-flags"},{"title":"Pass arguments and JSON","href":"/en/cli/desktop/guides/input"},{"title":"Output and language","href":"/en/cli/desktop/guides/output"},{"title":"Confirmation and long-running operations","href":"/en/cli/desktop/guides/confirmation"},{"title":"Exit codes and errors","href":"/en/cli/desktop/exit-codes"},{"title":"Data and permissions","href":"/en/cli/desktop/data"}]},{"title":"Troubleshooting","href":"/en/cli/desktop/troubleshooting"}]}]},{"group":"Product Features","root":{"title":"Product Features","href":"/en/product-features"},"pages":[{"title":"Summary View","href":"/en/summary/summary"},{"title":"Table View","href":"/en/table"},{"title":"Row Filter","href":"/en/table/row_filter"},{"title":"Column Filter","href":"/en/table/column_filter"},{"title":"Dashboard","href":"/en/markdown/markdown-dashboard"},{"title":"Note","href":"/en/markdown/markdown-note"},{"title":"Reproducible Steps","sidebarTitle":"Steps (Right-hand side)","href":"/en/steps"},{"title":"Branch feature","sidebarTitle":"Branch","href":"/en/branch"},{"title":"Parameter","href":"/en/parameter"},{"title":"Export Data","sidebarTitle":"Export","href":"/en/export"},{"group":"Share","root":{"title":"Share","href":"/en/share"},"pages":[{"title":"Share Type","href":"/en/share/share_type"},{"title":"Sharing Chart/Analytics","sidebarTitle":"Chart / Analytics","href":"/en/share/chart"},{"title":"Sharing Data","sidebarTitle":"Data","href":"/en/share/data"},{"title":"How to Share Report (Note or Dashboard)","sidebarTitle":"Report (Note / Dashboard)","href":"/en/share/note"},{"title":"Notification","href":"/en/share/notification"},{"title":"Version History","href":"/en/share/version-history"},{"title":"Restore Old Version","sidebarTitle":"Restore Older Version","href":"/en/share/restore"},{"title":"CSV API","href":"/en/share/csvapi"}]},{"group":"Schedule","root":{"title":"FAQ / Troubleshooting","sidebarTitle":"Schedule","href":"/en/schedule"},"pages":[{"title":"Publish Insights","sidebarTitle":"Manage Schedules","href":"/en/schedule/manage"},{"title":"Notification","href":"/en/schedule/notification"},{"title":"Scheduling History","href":"/en/schedule/history"}]},{"group":"Team","root":{"title":"Team","href":"/en/team"},"pages":[{"title":"Manage Teams","href":"/en/team/manage"}]},{"group":"Project","root":{"title":"Project","href":"/en/project"},"pages":[{"title":"How to import Project","sidebarTitle":"Import","href":"/en/project/import"},{"title":"How to export Project","sidebarTitle":"Export","href":"/en/project/export"},{"title":"How to search the Project","sidebarTitle":"Search","href":"/en/project/search"}]}]},{"group":"AI","root":{"title":"AI","href":"/en/ai"},"pages":[{"title":"AI Prompt Function","sidebarTitle":"AI Prompt Function","href":"/en/ai/ai-promtpt-function-en"}]},{"group":"Data Import","root":{"title":"Data Import","href":"/en/data_import"},"pages":[{"group":"File Data","root":{"title":"File Data","href":"/en/file-data"},"pages":[{"title":"Import CSV / Delimited File Data","sidebarTitle":"CSV / Delimited File","href":"/en/import/csv"},{"title":"Import CSV / Delimited File or Excel File or Parquet File Data from Amazon S3","sidebarTitle":"Amazon S3","href":"/en/import/s3"},{"title":"Import CSV / Delimited File or Excel File Data from Google Drive","sidebarTitle":"Google Drive","href":"/en/import/google-drive"},{"title":"Import CSV / Delimited File or Excel File Data from Google Cloud Storage (To be Introduced)","sidebarTitle":"Google Cloud Storage","href":"/en/import/google-cloud-storage"},{"title":"Import Excel File Data","sidebarTitle":"Excel","href":"/en/import/excel"},{"title":"Import JSON Data","sidebarTitle":"JSON","href":"/en/import/json"},{"title":"Import Log File Data","sidebarTitle":"Log File","href":"/en/import/log"},{"title":"Microsoft Azure Data Import","sidebarTitle":"Microsoft Azure","href":"/en/import/azure"},{"title":"Import Stats (SAS / SPSS / STAT) File Data","sidebarTitle":"Stats - SAS / SPSS / STATA","href":"/en/import/stats"},{"title":"Import R File (RDATA, RDS) File Data","sidebarTitle":"RData / RDS","href":"/en/import/rds"},{"title":"Import Parquet File Data","sidebarTitle":"Parquet File","href":"/en/import/parquet"},{"title":"Import Exploratory (EDF) File Data","sidebarTitle":"EDF - Exploratory","href":"/en/import/exploratory"}]},{"group":"Database Data","root":{"title":"Database Data","href":"/en/database-data"},"pages":[{"title":"SQL Troubleshooting","url":"https://exploratory.io/note/2ac8ae888097/How-to-workaround-the-issue-that-scheduled-Amazon-Athena-Data-Source-ends-up-with-empty-result-Fbe1yiQ3aC","href":"/en/external-sql-troubleshooting"},{"title":"Database Connection","sidebarTitle":"Create Connection","description":null,"href":"/en/import/connection.html"},{"title":"Athena Data Import","sidebarTitle":"Amazon Athena","href":"/en/import/athena"},{"title":"Aurora Data Import","sidebarTitle":"Amazon Aurora","description":null,"href":"/en/import/aurora"},{"title":"Amazon Redshift Database Data Import","sidebarTitle":"Amazon Redshift","href":"/en/import/redshift"},{"title":"Google BigQuery Data Import","sidebarTitle":"Google BigQuery","href":"/en/import/google-bigquery"},{"title":"HP Vertica Database Data Import","sidebarTitle":"HP Vertica","href":"/en/import/hp-vertica"},{"title":"MariaDB (MySQL) Data Import","sidebarTitle":"MariaDB / MySQL DB","href":"/en/import/mysql"},{"title":"MS Access Data Import","sidebarTitle":"Microsoft Access","href":"/en/import/access"},{"title":"MongoDB Data Import","sidebarTitle":"MongoDB","href":"/en/import/mongodb"},{"title":"ODBC Database Data Import","sidebarTitle":"ODBC","href":"/en/import/odbc"},{"title":"Oracle Database Data Import","sidebarTitle":"Oracle","href":"/en/import/oracle"},{"title":"Oracle Database Data Import (OCI)","sidebarTitle":"Oracle (OCI)","href":"/en/import/oracle-oci"},{"title":"PostgreSQL Database Data Import","sidebarTitle":"PostgreSQL","href":"/en/import/postgresql"},{"title":"Presto Data Import","sidebarTitle":"Presto","href":"/en/import/presto"},{"title":"Snowflake Data Import","sidebarTitle":"Snowflake","href":"/en/import/snowflake"},{"title":"SQLServer Data Import","sidebarTitle":"SQLServer (DSN)","href":"/en/import/sqlserver"},{"title":"SQL Server Data Import","sidebarTitle":"SQLServer","href":"/en/import/mssqlserver"},{"title":"Teradata Data Import","sidebarTitle":"Teradata","href":"/en/import/teradata"},{"title":"Treasure Data Import","sidebarTitle":"Treasure Data","href":"/en/import/treasuredata"}]},{"group":"Cloud Apps Data","root":{"title":"Cloud Apps Data","href":"/en/cloud-apps-data"},"pages":[{"title":"Connections for Cloud Apps","sidebarTitle":"Create Connection","href":"/en/import/connection-cloud-apps"},{"title":"FRED (Federal Reserve of Economic Data) Data Import","sidebarTitle":"FRED - Federal Reserve of Economic Data","href":"/en/import/fred"},{"title":"Github Issue Data Import","sidebarTitle":"Github Issues","href":"/en/import/github"},{"title":"Google Analytics Data","sidebarTitle":"Google Analytics","href":"/en/import/google-analytics"},{"title":"Google Spreadsheet Data Import","sidebarTitle":"Google Spreadsheet","href":"/en/import/google-sheet"},{"title":"Salesforce Data Import","sidebarTitle":"Salesforce","href":"/en/import/salesforce"},{"title":"Import Twitter Search API data","sidebarTitle":"Twitter Search","href":"/en/import/twitter"},{"title":"Import Stripe API Data","sidebarTitle":"Stripe","href":"/en/import/stripe"},{"title":"Whether Data Import","sidebarTitle":"Weather Data","href":"/en/import/weather"},{"title":"Stock Price Data","href":"/en/import/stock-price"},{"title":"Reinfolib","href":"/en/import/reinfolib"},{"title":"Estat","href":"/en/import/estat"},{"title":"Edinet","href":"/en/import/edinet"},{"title":"API","href":"/en/import/api"}]},{"group":"Write R Script as Data","root":{"title":"Write R Script to Get Data","sidebarTitle":"Write R Script as Data","href":"/en/import/r-script-data"},"pages":[{"title":"Currency Exchange Rate Data","sidebarTitle":"Currency Exchange Rate","href":"/en/import/currency"}]},{"title":"Import Data by Web Scraping","sidebarTitle":"Web Page Scraping","href":"/en/import/web-scraping"},{"title":"Text Input Data","href":"/en/import/free-input-text"},{"group":"Data Source Extension","root":{"title":"Data Source Extension","href":"/en/import/extensions"},"pages":[{"title":"Quandl Data Import","sidebarTitle":"Quandl","href":"/en/import/quandl"},{"title":"Holiday Data Import","sidebarTitle":"Holiday","href":"/en/import/holiday"},{"title":"RSS Data Import","sidebarTitle":"RSS Data","href":"/en/import/tidyrss"}]},{"title":"Add your Custom Data Sources with Data Source Extension Framework","sidebarTitle":"Create Custom Data Source","href":"/en/import/user-defined-plugin"}]},{"group":"Data Wrangling","root":{"title":"Data Wrangling","href":"/en/data-wrangling"},"pages":[{"title":"Command Line Mode","sidebarTitle":"Command Line mode for faster and more flexible data interaction in Exploratory","href":"/en/wrangling/command-mode"},{"title":"Select / Remove Columns","href":"/en/wrangling/select"},{"title":"Reorder Columns","href":"/en/wrangling/reorder"},{"title":"Create New Calculation","href":"/en/wrangling/mutate"},{"title":"Create New Calculation for Multiple Columns","href":"/en/wrangling/mutate_at"},{"title":"Summarize (Aggregate)","href":"/en/wrangling/summarize"},{"title":"Group Rows","sidebarTitle":"Group","href":"/en/wrangling/group"},{"title":"Filter","href":"/en/wrangling/filter"},{"title":"Rename","href":"/en/wrangling/rename"},{"title":"Arrange (Sort)","href":"/en/wrangling/arrange"},{"title":"Top / Bottom N","href":"/en/wrangling/top_n"},{"title":"Join Data","sidebarTitle":"Join","href":"/en/wrangling/join"},{"title":"Merge multiple Data Frames","sidebarTitle":"Merge","href":"/en/wrangling/merge"},{"title":"Gather (Unpivot)","sidebarTitle":"Gather","href":"/en/wrangling/gather"},{"title":"Spread","href":"/en/wrangling/spread"},{"title":"Pivot","href":"/en/wrangling/pivot"},{"title":"Expand","href":"/en/wrangling/expand"},{"title":"Complete","href":"/en/wrangling/complete"},{"title":"Separate","href":"/en/wrangling/separate"},{"title":"Unite","href":"/en/wrangling/unite"},{"title":"Bind Rows","href":"/en/wrangling/bind_rows"},{"title":"Bind Columns","href":"/en/wrangling/bind_columns"},{"title":"Keep Only Unique Rows","href":"/en/wrangling/distinct"},{"title":"Keep Only Duplicated Rows","href":"/en/wrangling/get_dupes"},{"title":"Slice","href":"/en/wrangling/slice"},{"title":"Drop NA","href":"/en/wrangling/drop_na"},{"title":"Sample","href":"/en/wrangling/sample"},{"title":"Impute NA","href":"/en/wrangling/impute_na"},{"title":"Fill","href":"/en/wrangling/fill"},{"title":"Create Buckets","href":"/en/wrangling/buckets"},{"title":"Assign New Values to Existing Values - Recode","href":"/en/wrangling/recode"},{"title":"Assign New Values by Setting Conditions - Case When","href":"/en/wrangling/case_when"},{"title":"Working with Categorical Data","sidebarTitle":"Work with Categories","href":"/en/wrangling/categories"},{"title":"Type Convert","sidebarTitle":"Data Type Conversion","href":"/en/wrangling/type-convert"},{"title":"Row as Header","sidebarTitle":"Row as header","href":"/en/wrangling/row_as_header"},{"title":"Ungroup","href":"/en/wrangling/ungroup"},{"title":"Unnest","href":"/en/wrangling/unnest"},{"title":"Separate List Items into Columns (Unnest Wider)","href":"/en/wrangling/unnest_wider"},{"title":"Separate List Items into Rows (Unnest Longer)","href":"/en/wrangling/unnest_longer"},{"title":"Separate Address (Japan)","href":"/en/wrangling/separate-japanese-address"},{"title":"Hoist","href":"/en/wrangling/hoist"},{"title":"Remove Empty Rows","href":"/en/wrangling/remove_empty_rows"},{"title":"Remove Empty Columns","href":"/en/wrangling/remove_empty_cols"},{"title":"Clean Column Names","href":"/en/wrangling/clean_names"},{"title":"Window (Table) Calculation","sidebarTitle":"Window Calculation","href":"/en/wrangling/window-calculation"},{"title":"Add Row","href":"/en/wrangling/add_row"},{"title":"Text Wrangling UI","sidebarTitle":"Text Wrangling","href":"/en/wrangling/text_wrangling"},{"title":"Regular Expression","sidebarTitle":"Regular Expression Cheat Sheet","href":"/en/wrangling/regular_expression"}]},{"group":"Visualization","root":{"title":"Visualization","href":"/en/visualization"},"pages":[{"group":"Types","pages":[{"title":"Pivot Table","sidebarTitle":"Pivot","href":"/en/viz/pivot"},{"title":"Summarize Table","href":"/en/viz/summarize-table"},{"title":"Table","href":"/en/viz/table"},{"title":"Bar Chart","sidebarTitle":"Bar","href":"/en/viz/bar"},{"title":"Line Chart","sidebarTitle":"Line","href":"/en/viz/line"},{"title":"Area Chart","sidebarTitle":"Area","href":"/en/viz/area"},{"title":"Pie / Ring Chart","sidebarTitle":"Pie/Ring","href":"/en/viz/pie"},{"title":"Radar Chart","sidebarTitle":"Radar","href":"/en/viz/radar"},{"title":"Histogram Chart","sidebarTitle":"Histogram","href":"/en/viz/hist"},{"title":"Density Plot","href":"/en/viz/densityplot"},{"title":"Scatter (No Aggregation) Chart","sidebarTitle":"Scatter (No Aggregation)","href":"/en/viz/scatter"},{"title":"Scatter (With Aggregation) Chart","sidebarTitle":"Scatter (With Aggregation)","href":"/en/viz/bubble"},{"title":"Boxplot Chart","sidebarTitle":"Boxplot","href":"/en/viz/boxplot"},{"title":"Violin Chart","sidebarTitle":"Violin","href":"/en/viz/violin"},{"title":"Error Bar Chart","sidebarTitle":"Error Bar","href":"/en/viz/errbar"},{"title":"Error Bar (Summarized Data) Chart","sidebarTitle":"Error Bar (Summarized Data)","href":"/en/viz/errbar-agg"},{"title":"Map - Standard","href":"/en/viz/easymap"},{"title":"Map - Extension","href":"/en/viz/geojson"},{"title":"Map - Long / Lat","sidebarTitle":"Map - Long/Lat","href":"/en/viz/map"},{"title":"Map - Heatmap","href":"/en/viz/maphmap"},{"title":"Heatmap","href":"/en/viz/heatmap"},{"title":"Contour","href":"/en/viz/contour"},{"title":"Number Chart","sidebarTitle":"Number","href":"/en/viz/singlevalue"},{"title":"Word Cloud","href":"/en/viz/wordcloud"},{"title":"Custom (R)","href":"/en/viz/r-custom"}]},{"group":"Features","pages":[{"title":"Trend Line","href":"/en/viz/trend-line"},{"title":"Reference Line","href":"/en/viz/reference-line"},{"title":"Repeat By","href":"/en/viz/small-multiple"},{"title":"Window (Table) Calculation","sidebarTitle":"Window Calculation","href":"/en/viz/window-calc"},{"title":"Date / Time Aggregation","sidebarTitle":"Date/Time Aggregation","href":"/en/viz/date-aggregate"},{"title":"Range","sidebarTitle":"Show Range","href":"/en/viz/range"},{"title":"Marker Type","sidebarTitle":"Change Marker","href":"/en/viz/marker"},{"title":"Multiple Y-Axis","sidebarTitle":"Multiple Y-Axis Columns","href":"/en/viz/multi-y"},{"title":"Configure Layout and Format","sidebarTitle":"Layout Configuration","href":"/en/viz/layout"},{"title":"Select and Configure Columns","sidebarTitle":"Column Configuration","href":"/en/viz/column-configuration"},{"title":"Column Configuration Dialog","href":"/en/viz/column-configuration-dialog"},{"title":"Color \u0026 Group Setting","sidebarTitle":"Color and Group Setting","href":"/en/viz/color"},{"title":"Color setting","sidebarTitle":"Color Setting","href":"/en/viz/color-dialog"},{"title":"User Color Palette","sidebarTitle":"User Color Palette Setting","href":"/en/viz/custom-palette"},{"title":"Chart Pinning","sidebarTitle":"Pin","href":"/en/viz/pin"},{"title":"Save Chart as PNG / SVG","sidebarTitle":"Save as PNG/SVG","href":"/en/viz/save"},{"title":"Export Chart as EDF (Exploratory Data File)","sidebarTitle":"Save as Exploratory Data File","href":"/en/viz/save-as-edf"},{"title":"Share / Schedule","sidebarTitle":"Share/Schedule","href":"/en/viz/schedule"},{"title":"URL Link","href":"/en/viz/urllink"},{"title":"Category (Binning)","href":"/en/viz/category"},{"title":"Highlight","href":"/en/viz/highlight"},{"title":"Limit Values","href":"/en/viz/limit"},{"title":"'Others' Group","sidebarTitle":"'Others' Group","href":"/en/viz/others-group"},{"title":"Edit Display Names","sidebarTitle":"Edit Display Name","href":"/en/viz/edit-display-name"},{"title":"Missing Value Handling","href":"/en/viz/missing-value-handling"},{"title":"Rename Column Names","href":"/en/viz/rename-column-names"},{"title":"Axis Setting","href":"/en/viz/dualy-setting"},{"title":"Axis Formatting","href":"/en/viz/axis-format"},{"title":"Show Detail","href":"/en/viz/show-detail"},{"title":"Fit to Screen","sidebarTitle":"Fit to Screen (Table)","href":"/en/viz/table-fit-to-screen"},{"title":"Number of Unique Values Check","href":"/en/viz/number-of-unuque-values-check"}]}]},{"group":"Analytics","root":{"title":"Instant Analytics UI","sidebarTitle":"Analytics","href":"/en/analytics"},"pages":[{"title":"Correlation by Column","sidebarTitle":"Correlation","href":"/en/analytics/correlation_column"},{"title":"Distance by Columns Analytics View","sidebarTitle":"Distance","href":"/en/analytics/distance_column"},{"title":"K-Means Clustering Analytics View","sidebarTitle":"K-Means Clustering","href":"/en/analytics/kmeans"},{"title":"K-Modes Clustering Analytics View","sidebarTitle":"K-Modes Clustering","href":"/en/analytics/kmodes"},{"title":"Principal Component Analysis Analytics View","sidebarTitle":"Principal Component Analysis","href":"/en/analytics/pca"},{"title":"Factor Analysis","href":"/en/analytics/factanal"},{"title":"Correspondence Analysis","href":"/en/analytics/correspondence"},{"title":"Regression Analysis","sidebarTitle":"Linear Regression Analysis","href":"/en/analytics/regression"},{"title":"Logistic Regression Analytics View","sidebarTitle":"Logistic Regression Analysis","href":"/en/analytics/logistic"},{"title":"Ordered Logistic Regression Analytics View","sidebarTitle":"Ordered Logistic Regression Analysis","href":"/en/analytics/ordered_logistic_regression"},{"title":"Generalized Linear Model (GLM) Analytics View","sidebarTitle":"Generalized Linear Models","href":"/en/analytics/glm"},{"title":"Survival Analysis","sidebarTitle":"Survival Curve","href":"/en/analytics/survival"},{"title":"Cox Regression Analytics","sidebarTitle":"Cox Regression","href":"/en/analytics/var_importance_time"},{"title":"Random Survival Forest","href":"/en/analytics/survival_forest"},{"title":"Decision Tree Analytics View","sidebarTitle":"Decision Tree","href":"/en/analytics/decision_tree"},{"title":"CHAID Analytics View","sidebarTitle":"CHAID","href":"/en/analytics/chaid"},{"title":"Random Forest","href":"/en/analytics/var_importance"},{"title":"XGBoost","href":"/en/analytics/xgboost"},{"title":"LightGBM","href":"/en/analytics/lightgbm"},{"title":"Time Series Forecasting","sidebarTitle":"Time Series Forecasting (Prophet)","href":"/en/analytics/forecasting"},{"title":"Time Series Forecasting (ARIMA)","href":"/en/analytics/arima"},{"title":"Time Series Clustering","href":"/en/analytics/time_series_clustering"},{"title":"Anomaly Detection","href":"/en/analytics/anomaly"},{"title":"Text Analysis","sidebarTitle":"Word Count","href":"/en/analytics/textanal"},{"title":"Text Clustering with Topic Model","sidebarTitle":"Text Clustering with Topic Model (LDA)","href":"/en/analytics/topic_model"},{"title":"Market Basket Analysis Analytics View","sidebarTitle":"Market Basket Analysis","href":"/en/analytics/market_basket"},{"title":"T Test Analytics View","sidebarTitle":"T Test","href":"/en/analytics/t_test"},{"title":"T Test Analytics View for Aggregated Data","sidebarTitle":"T Test (Aggregated Data)","href":"/en/analytics/t_test_aggregated"},{"title":"ANOVA Analytics","sidebarTitle":"ANOVA","href":"/en/analytics/anova"},{"title":"Wilcoxon Test Analytics View","sidebarTitle":"Wilcoxon Test","href":"/en/analytics/wilcoxon"},{"title":"Kruskal-Wallis Test Analytics View","sidebarTitle":"Kruskal-Wallis Test","href":"/en/analytics/kruskal_wallis"},{"title":"Chi-Square Test Analytics View","sidebarTitle":"Chi-Square Test","href":"/en/analytics/chisq"},{"title":"A/B Test - Bayesian","sidebarTitle":"A/B Test","href":"/en/analytics/ab_test"},{"title":"Normality Test Analytics View","sidebarTitle":"Normality Test","href":"/en/analytics/normality"},{"title":"Cronbach's Alpha Analytics View","sidebarTitle":"Cronbach's Alpha","href":"/en/analytics/cronbach-alpha"},{"title":"Prediction with a Model from Analytics View","sidebarTitle":"Prediction","href":"/en/analytics/prediction"},{"title":"How to manage Dictionaries","sidebarTitle":"Dictionaries for Text Analysis","href":"/en/analytics/dictionary"}]},{"group":"Statistics","root":{"title":"Statistics","href":"/en/statistics"},"pages":[{"title":"Correlation","href":"/en/stats/correlation"},{"title":"Distance","href":"/en/stats/dist"},{"title":"Cosine Similarity","href":"/en/stats/sim"},{"title":"SVD","href":"/en/stats/svd"},{"title":"Multi Dimensional Scaling","href":"/en/stats/mds"},{"title":"T-test","href":"/en/stats/t-test"},{"title":"F-test","href":"/en/stats/f-test"},{"title":"Chi Squared Test","sidebarTitle":"Chi-square test","href":"/en/stats/chi-test"},{"title":"A/B Test (Bayesian)","href":"/en/stats/exp_bayes_ab"}]},{"group":"Machine Learning","root":{"title":"Machine Learning","href":"/en/machine-learning"},"pages":[{"title":"Linear Regression Model","sidebarTitle":"Linear Regression","href":"/en/ml/linear-regression"},{"title":"Logistic Regression Model","sidebarTitle":"Logistic Regression","href":"/en/ml/logistic-regression"},{"title":"Generalized Linear Regression Model","sidebarTitle":"GLM","href":"/en/ml/glm"},{"title":"Multinomial Logistic Regression Model","sidebarTitle":"Multinomial Logistic Regression","href":"/en/ml/multinom"},{"title":"K-means Clustering Model","sidebarTitle":"K-means Clustering","href":"/en/ml/kmeans"},{"title":"Random Forest Model","sidebarTitle":"Random Forest","href":"/en/ml/random-forest"},{"title":"XGBoost - Extreme Gradient Boosting","sidebarTitle":"XGBoost","href":"/en/ml/xgboost"},{"title":"Time Series Forecasting","sidebarTitle":"Forecasting","href":"/en/ml/forecasting"},{"title":"Time Series Clustering","href":"/en/ml/timeseries_clustering"},{"title":"Anomaly Detection","href":"/en/ml/anomaly"},{"title":"Calculate Survival Curve","sidebarTitle":"Survival Curve","href":"/en/ml/survival-curv"},{"title":"Survival Analysis - Cox Regression / Proportional Hazard","sidebarTitle":"Survival Model (Cox Regression)","href":"/en/ml/cox-regression"},{"title":"Market Basket Analysis - Association Rules","sidebarTitle":"Market Basket","href":"/en/ml/arules"},{"title":"Causal Impact Analysis","sidebarTitle":"Causal Impact","href":"/en/ml/causal_impact"},{"title":"Evaluate Prediction - Regression","href":"/en/ml/evaluate_regression"},{"title":"Evaluate Prediction - Binary","href":"/en/ml/evaluate_binary"},{"title":"Calculate ROC","href":"/en/ml/do_roc"},{"title":"Evaluate Prediction - Multiclass","href":"/en/ml/evaluate_multi"},{"title":"Predict Data","sidebarTitle":"Prediction","href":"/en/ml/prediction"},{"title":"Predict Data - Binary","sidebarTitle":"Prediction - Binary Classification","href":"/en/ml/prediction_binary"},{"title":"Predict Data - Survival","sidebarTitle":"Prediction - Survival Model","href":"/en/ml/prediction_coxph"},{"title":"Simulate Survival Curve","href":"/en/ml/prediction_survfit"},{"title":"Summary of Fit","sidebarTitle":"Extract Summary of Fit","href":"/en/ml/model_stats"},{"title":"Extract Parameter Estimates","href":"/en/ml/model_coef"},{"title":"Run ANOVA Test","href":"/en/ml/model_anova"},{"title":"Fix Imbalanced Data","sidebarTitle":"Fix Imbalanced Data (SMOTE)","href":"/en/wrangling/smote"}]},{"group":"Text Analysis","root":{"title":"Text Mining in Exploratory","sidebarTitle":"Text Analysis","href":"/en/text/main"},"pages":[{"title":"Tokenize Text","href":"/en/text/do_tokenize"},{"title":"Create N-gram Tokens","href":"/en/text/do_ngram"},{"title":"Calculate TF-IDF","sidebarTitle":"Calculate tf-idf","href":"/en/text/do_tfidf"},{"title":"Count Text Pairs","href":"/en/text/pair_count"}]},{"group":"Extend with R","root":{"title":"Extend with R","href":"/en/extend-with-r"},"pages":[{"title":"Install R Package","sidebarTitle":"R Package Install","href":"/en/r_package"},{"title":"Add your own custom R functions or variables with R Script","sidebarTitle":"Custom R Script","href":"/en/r_script"},{"title":"Use Custom Model Function","sidebarTitle":"Custom Model Function","href":"/en/user-defined-model-function"}]},{"group":"Setup","pages":[{"title":"How to disable McAfee Real Time Virus Scan temporarily for allowing Exploratory to install R packages.","sidebarTitle":"Disable McAfee virus scan","href":"/en/howto/stopmcafee"},{"title":"Change Repository Location","href":"/en/howto/set_exploratory_home"},{"title":"How to Set Holidays Data for Time Series Forecast","sidebarTitle":"Holidays Data for Forecast","href":"/en/howto/holiday"},{"title":"Possible Reasons for Installation Errors","sidebarTitle":"Possible Reasons for Install Error","href":"/en/howto/install_errors"},{"title":"How to Upgrade .NET Framework","sidebarTitle":"Upgrade Microsoft .NET Framework","href":"/en/howto/upgrade_dot_net"}]},{"group":"Diagnostics","pages":[{"title":"Log file for debugging","href":"/en/debug_log"},{"title":"Startup log file for debugging","sidebarTitle":"Startup Log file for debugging","href":"/en/startup_log"},{"title":"Check version of your Exploratory Desktop","sidebarTitle":"Check version of Exploratory Desktop","href":"/en/version_check"},{"title":"How to Recover the History Data","href":"/en/history_error_recovery"}]},{"title":"Keyboard shortcuts","href":"/en/shortcut"}]}]},{"language":"ja","pages":[{"title":"ja","href":"/ja"}]}]},"basePath":"","title":"Athena Data Import - Exploratory","deploymentId":"dpl_HhUetB7eHHDAmK9T1Teip38TgFx9","buildId":"dpl_HhUetB7eHHDAmK9T1Teip38TgFx9","dynamics":[],"chunks":[]}