What is sent and what is recorded when you use expl.
What is sent and recorded
Commands go to the Desktop app over a local connection on your computer. Desktop keeps a log of each tool call on your computer (tool name, parameter names without their values, result, duration) and deletes it after 90 days.While you are signed in and AI features are on, Desktop also sends one usage record for each tool call to the exploratory.io server you are signed in to, as it does for MCP Desktop (never for local data catalog tools). A record holds the tool name and its arguments (which can include formulas and values you entered), success or failure with the error type and message, the size of the result (not the content), the duration, the Desktop version, the client name and version, and the session and item IDs.expl itself sends no usage analytics.For what MCP Desktop records, see also Data and permissions.
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":"treatment","enabled":true,"payload":{"type":"string","value":"treatment"},"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/cli/desktop/data","slug":"/en/cli/desktop/data","pageMetadata":{"title":"Data and permissions","description":null,"href":"/en/cli/desktop/data"},"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},{Heading}=_components;if(!Heading)_missingMdxReference(`Heading`,true);return _jsxs(_Fragment,{children:[_jsx(_components.p,{children:`What is sent and what is recorded when you use expl.`}),`\n`,_jsx(`a`,{id:`records`}),`\n`,_jsx(Heading,{level:`2`,id:`what-is-sent-and-recorded`,children:`What is sent and recorded`}),`\n`,_jsx(_components.p,{children:`Commands go to the Desktop app over a local connection on your computer. Desktop keeps a log of each tool call on your computer (tool name, parameter names without their values, result, duration) and deletes it after 90 days.`}),`\n`,_jsx(_components.p,{children:`While you are signed in and AI features are on, Desktop also sends one usage record for each tool call to the exploratory.io server you are signed in to, as it does for MCP Desktop (never for local data catalog tools). A record holds the tool name and its arguments (which can include formulas and values you entered), success or failure with the error type and message, the size of the result (not the content), the duration, the Desktop version, the client name and version, and the session and item IDs.`}),`\n`,_jsx(_components.p,{children:`expl itself sends no usage analytics.`}),`\n`,_jsxs(_components.p,{children:[`For what MCP Desktop records, see also `,_jsx(_components.a,{href:`/en/mcp/desktop/data`,children:`Data and permissions`}),`.`]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Data and permissions","description":null,"href":"/en/cli/desktop/data"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"What is sent and recorded","slug":"what-is-sent-and-recorded","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":[],"subdomain":"exploratory-inc","siteName":"Exploratory","title":"Data and permissions - Exploratory","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{"en":{"href":"/en/cli/desktop/data","matchLevel":0},"ja":{"href":"/ja/cli/desktop/data","matchLevel":1}}},"lastModified":"2026-11-18T06:05:30.529Z","originalFileLocation":"en/cli/desktop/data.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=\"Data and permissions - Exploratory\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Exploratory\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.exploratory.io/en/cli/desktop/data\">\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=Reference\u0026amp;title=Data+and+permissions\u0026amp;theme=d875c51dedd76fd973af8cde\u0026amp;signature=80b4571758f2e3ed094f938677d7178ee3140c98d38b4d800712f301c25a079e\">\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=\"Data and permissions - Exploratory\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://exploratory-inc.mintlify.site/_mintlify/api/og/v2?division=Reference\u0026amp;title=Data+and+permissions\u0026amp;theme=d875c51dedd76fd973af8cde\u0026amp;signature=80b4571758f2e3ed094f938677d7178ee3140c98d38b4d800712f301c25a079e\">\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/cli/desktop/data\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/en/cli/desktop/data.md\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"en\" href=\"https://docs.exploratory.io/en/cli/desktop/data\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ja\" href=\"https://docs.exploratory.io/ja/cli/desktop/data\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"x-default\" href=\"https://docs.exploratory.io/en/cli/desktop/data\">\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/cli/desktop/data#webpage\",\"url\":\"https://docs.exploratory.io/en/cli/desktop/data\",\"name\":\"Data and permissions\",\"dateModified\":\"2026-11-18T06:05:30.529Z\",\"isPartOf\":{\"@id\":\"https://docs.exploratory.io#website\"},\"breadcrumb\":{\"@id\":\"https://docs.exploratory.io/en/cli/desktop/data#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.exploratory.io/en/cli/desktop/data#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Exploratory\",\"item\":\"https://docs.exploratory.io/en\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exploratory CLI\",\"item\":\"https://docs.exploratory.io/en/cli\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Desktop\",\"item\":\"https://docs.exploratory.io/en/cli/desktop\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Reference\",\"item\":\"https://docs.exploratory.io/en/cli/desktop/reference\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Data and permissions\",\"item\":\"https://docs.exploratory.io/en/cli/desktop/data\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.exploratory.io/en/cli/desktop/data#article\",\"headline\":\"Data and permissions\",\"name\":\"Data and permissions\",\"url\":\"https://docs.exploratory.io/en/cli/desktop/data\",\"mainEntityOfPage\":{\"@id\":\"https://docs.exploratory.io/en/cli/desktop/data#webpage\"},\"dateModified\":\"2026-11-18T06:05:30.529Z\",\"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/cli/desktop/data.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","description":null,"href":"/en/cli/desktop/exit-codes"},{"title":"Data and permissions","href":"/en/cli/desktop/data"}]},{"title":"Troubleshooting","description":null,"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","href":"/en/import/connection.html"},{"title":"Athena Data Import","sidebarTitle":"Amazon Athena","href":"/en/import/athena"},{"title":"Aurora Data Import","sidebarTitle":"Amazon Aurora","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/cli/desktop/data"}]}]},"basePath":"","title":"Data and permissions - Exploratory","deploymentId":"dpl_HhUetB7eHHDAmK9T1Teip38TgFx9","buildId":"dpl_HhUetB7eHHDAmK9T1Teip38TgFx9","dynamics":[],"chunks":[]}