Connect two separate data source components (CSV Reader, Excel Reader) to the left and right input handles of Merge / Join.
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"ClickML Studio","colors":{"primary":"#1E40AF","light":"#3B82F6","dark":"#1E40AF"},"logo":{"light":"https://mintcdn.com/clickml/Uly6Z5roOSNUx5mT/logo/light.svg?fit=max\u0026auto=format\u0026n=Uly6Z5roOSNUx5mT\u0026q=85\u0026s=3a85ac14a6024905a9e437b6e429a34c","dark":"https://mintcdn.com/clickml/Uly6Z5roOSNUx5mT/logo/dark.svg?fit=max\u0026auto=format\u0026n=Uly6Z5roOSNUx5mT\u0026q=85\u0026s=08e7eaab99a2f86ce69e0b18ac670e9c"},"favicon":"https://mintcdn.com/clickml/Uly6Z5roOSNUx5mT/public/favicon.svg?fit=max\u0026auto=format\u0026n=Uly6Z5roOSNUx5mT\u0026q=85\u0026s=4c8cf1cb472079968416f081ff3b70e2","navbar":{"links":[{"href":"https://clickml.com","label":"Website"}],"primary":{"type":"button","label":"Go to Studio","href":"https://app.clickml.com"}},"footer":{"socials":{"linkedin":"https://www.linkedin.com/company/clickml"}},"styling":{"latex":false},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"clickml","hasAudioNarration":false,"actualSubdomain":"clickml","customDomains":["docs.clickml.app"],"gitSource":{"type":"github","owner":"baselhusam","repo":"clickml_docs","deployBranch":"main","contentDirectory":"","isPrivate":true,"mountPath":"","label":""},"chroma":{"liveDeploymentHistoryId":"6a8b5e6a4ed67b30ee2287b4","collectionId":"63a2612f-1f1b-4372-b6b2-8a55acbac483","schemaVersion":"v2","latestBuiltDeploymentHistoryId":"6a8b5e6a4ed67b30ee2287b4"},"entitlements":{"AI_CHAT":{"status":"DISABLED"}},"buildId":"6a8b5e6a4ed67b30ee2287b4","clientVersion":"0.0.3990","searchFilterCounts":[{"language":"default","tag":"Models — Regression","count":8},{"language":"default","tag":"Data Processing","count":7},{"language":"default","tag":"Models — Classification","count":6},{"language":"default","tag":"Evaluation \u0026 Inference","count":3},{"language":"default","tag":"Feature Engineering","count":3},{"language":"default","tag":"Data","count":2},{"language":"default","tag":"Data Wrangling","count":2},{"language":"default","tag":"Get Started","count":2},{"language":"default","tag":"Analytics","count":1},{"language":"default","tag":"Components","count":1}]},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableContextualStarterQuestions":false,"enableAskAiSearchBar":true},"basePath":"","hasChatPermissions":false,"hasWebMcpPermissions":false,"toggles":[{"name":"kill-isr","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":"editor-v7-file-tree","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":"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":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"pause-universal-search-reconcile","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":"per-site-search-delta","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":"editor-private-page-search","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":"editor-nav-generations","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":"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":"byok-sep-25","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":"vite-origin","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-agent-model-picker","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-updated-9-15","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":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"isAtlas":false,"googleFontsInlined":false},"customCss":[],"page":{"pagePath":"components/wrangling/merge-join","slug":"/components/wrangling/merge-join","pageMetadata":{"title":"Merge and Join DataFrames component","description":"Join two DataFrames on a shared key column using inner, left, right, or outer joins to combine related datasets before model training.","href":"/components/wrangling/merge-join"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Join two DataFrames on a shared key column using inner, left, right, or outer joins to combine related datasets before model training.\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"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={code:`code`,p:`p`,strong:`strong`,tbody:`tbody`,td:`td`,th:`th`,thead:`thead`,tr:`tr`,..._provideComponents(),...props.components},{Heading,Note,Table}=_components;if(!Heading)_missingMdxReference(`Heading`,true);if(!Note)_missingMdxReference(`Note`,true);if(!Table)_missingMdxReference(`Table`,true);return _jsxs(_Fragment,{children:[_jsxs(_components.p,{children:[`The `,_jsx(_components.strong,{children:`Merge / Join`}),` component combines two DataFrames side-by-side by matching rows on one or more key columns — equivalent to a SQL JOIN.`]}),`\n`,_jsx(Heading,{level:`2`,id:`configuration`,children:`Configuration`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Option`}),_jsx(_components.th,{children:`Description`}),_jsx(_components.th,{children:`Default`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`How`})}),_jsxs(_components.td,{children:[`Join type: `,_jsx(_components.code,{children:`inner`}),`, `,_jsx(_components.code,{children:`left`}),`, `,_jsx(_components.code,{children:`right`}),`, `,_jsx(_components.code,{children:`outer`})]}),_jsx(_components.td,{children:_jsx(_components.code,{children:`inner`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Left On`})}),_jsx(_components.td,{children:`Key column(s) from the left DataFrame`}),_jsx(_components.td,{children:`—`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Right On`})}),_jsx(_components.td,{children:`Key column(s) from the right DataFrame`}),_jsx(_components.td,{children:`—`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Suffixes`})}),_jsxs(_components.td,{children:[`Suffix added to overlapping column names (e.g. `,_jsx(_components.code,{children:`_x,_y`}),`)`]}),_jsx(_components.td,{children:_jsx(_components.code,{children:`_x,_y`})})]})]})]}),`\n`,_jsx(Heading,{level:`3`,id:`join-types`,children:`Join types`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Type`}),_jsx(_components.th,{children:`Result`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`inner`}),_jsx(_components.td,{children:`Only rows with matching keys in both DataFrames`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`left`}),_jsx(_components.td,{children:`All rows from the left DataFrame; NaN for unmatched right rows`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`right`}),_jsx(_components.td,{children:`All rows from the right DataFrame; NaN for unmatched left rows`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`outer`}),_jsx(_components.td,{children:`All rows from both DataFrames; NaN where no match`})]})]})]}),`\n`,_jsx(Heading,{level:`2`,id:`input-/-output`,children:`Input / Output`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{}),_jsx(_components.th,{children:`Type`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Input`}),_jsx(_components.td,{children:`Left DataFrame + Right DataFrame`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Output`}),_jsx(_components.td,{children:`DataFrame`})]})]})]}),`\n`,_jsx(Note,{children:_jsx(_components.p,{children:`Connect two separate data source components (CSV Reader, Excel Reader) to the left and right input handles of Merge / Join.`})})]})}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":"Merge and Join DataFrames component","description":"Join two DataFrames on a shared key column using inner, left, right, or outer joins to combine related datasets before model training.","href":"/components/wrangling/merge-join"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"Configuration","slug":"configuration","depth":2,"children":[{"title":"Join types","slug":"join-types","depth":3,"children":[]}]},{"title":"Input / Output","slug":"input-/-output","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":[],"subdomain":"clickml","siteName":"ClickML Studio","title":"Merge and Join DataFrames component - ClickML Studio","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-05-02T23:08:40.868Z","originalFileLocation":"components/wrangling/merge-join.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;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=\"system\"}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=\"description\" content=\"Join two DataFrames on a shared key column using inner, left, right, or outer joins to combine related datasets before model training.\">\u003cmeta data-mint-head name=\"application-name\" content=\"ClickML Studio\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/clickml/VCt0Ega09sioYoHB/_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/clickml/VCt0Ega09sioYoHB/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/clickml/VCt0Ega09sioYoHB/_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/clickml/VCt0Ega09sioYoHB/_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/clickml/VCt0Ega09sioYoHB/_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/clickml/VCt0Ega09sioYoHB/_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/clickml/VCt0Ega09sioYoHB/_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/clickml/VCt0Ega09sioYoHB/_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/clickml/VCt0Ega09sioYoHB/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Merge and Join DataFrames component - ClickML Studio\">\u003cmeta data-mint-head property=\"og:description\" content=\"Join two DataFrames on a shared key column using inner, left, right, or outer joins to combine related datasets before model training.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"ClickML Studio\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.clickml.app/components/wrangling/merge-join\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://clickml.mintlify.app/_mintlify/api/og/v2?division=Data+Wrangling\u0026amp;title=Merge+and+Join+DataFrames+component\u0026amp;description=Join+two+DataFrames+on+a+shared+key+column+using+inner%2C+left%2C+right%2C+or+outer+joins+to+combine+related+datasets+before+model+training.\u0026amp;theme=329502de4701099884229d65\u0026amp;signature=0e31ef797922a25afdf10493fd418a8e9ac9cf7b35e608d6e924ccdbda120e21\">\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=\"Merge and Join DataFrames component - ClickML Studio\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Join two DataFrames on a shared key column using inner, left, right, or outer joins to combine related datasets before model training.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://clickml.mintlify.app/_mintlify/api/og/v2?division=Data+Wrangling\u0026amp;title=Merge+and+Join+DataFrames+component\u0026amp;description=Join+two+DataFrames+on+a+shared+key+column+using+inner%2C+left%2C+right%2C+or+outer+joins+to+combine+related+datasets+before+model+training.\u0026amp;theme=329502de4701099884229d65\u0026amp;signature=0e31ef797922a25afdf10493fd418a8e9ac9cf7b35e608d6e924ccdbda120e21\">\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/clickml/VCt0Ega09sioYoHB/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"ClickML Studio\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#1E40AF\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.clickml.app/components/wrangling/merge-join\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/components/wrangling/merge-join.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.clickml.app/#organization\",\"name\":\"ClickML Studio\",\"url\":\"https://docs.clickml.app\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/clickml/Uly6Z5roOSNUx5mT/logo/light.svg?fit=max\u0026auto=format\u0026n=Uly6Z5roOSNUx5mT\u0026q=85\u0026s=3a85ac14a6024905a9e437b6e429a34c\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.clickml.app#website\",\"name\":\"ClickML Studio\",\"url\":\"https://docs.clickml.app\",\"publisher\":{\"@id\":\"https://docs.clickml.app/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.clickml.app/components/wrangling/merge-join#webpage\",\"url\":\"https://docs.clickml.app/components/wrangling/merge-join\",\"name\":\"Merge and Join DataFrames component\",\"description\":\"Join two DataFrames on a shared key column using inner, left, right, or outer joins to combine related datasets before model training.\",\"dateModified\":\"2026-05-02T23:08:40.868Z\",\"isPartOf\":{\"@id\":\"https://docs.clickml.app#website\"},\"breadcrumb\":{\"@id\":\"https://docs.clickml.app/components/wrangling/merge-join#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.clickml.app/components/wrangling/merge-join#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"ClickML Studio\",\"item\":\"https://docs.clickml.app\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Merge and Join DataFrames component\",\"item\":\"https://docs.clickml.app/components/wrangling/merge-join\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.clickml.app/components/wrangling/merge-join#article\",\"headline\":\"Merge and Join DataFrames component\",\"name\":\"Merge and Join DataFrames component\",\"description\":\"Join two DataFrames on a shared key column using inner, left, right, or outer joins to combine related datasets before model training.\",\"url\":\"https://docs.clickml.app/components/wrangling/merge-join\",\"mainEntityOfPage\":{\"@id\":\"https://docs.clickml.app/components/wrangling/merge-join#webpage\"},\"dateModified\":\"2026-05-02T23:08:40.868Z\",\"publisher\":{\"@id\":\"https://docs.clickml.app/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.clickml.app#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"ClickML Studio\",\"creator\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","siteName":"ClickML Studio","nav":{"global":null,"groups":[{"group":"Get Started","pages":[{"title":"Introduction to ClickML Studio","href":"/introduction"},{"title":"Quickstart guide to building ML pipelines","href":"/quickstart"}]},{"group":"Components","pages":[{"title":"ClickML Studio components reference","href":"/components/overview"}]},{"group":"Data","pages":[{"title":"CSV Reader component","href":"/components/data/csv-reader"},{"title":"Excel Reader component","href":"/components/data/excel-reader"}]},{"group":"Data Processing","pages":[{"title":"Data Cleaning component","href":"/components/processing/data-cleaning"},{"title":"Missing Values imputation component","href":"/components/processing/missing-values"},{"title":"Feature Scaling component","href":"/components/processing/scaling"},{"title":"Categorical Encoding component","href":"/components/processing/encoding"},{"title":"Data Transformation component","href":"/components/processing/data-transformation"},{"title":"Delete Columns and Rows component","href":"/components/processing/delete-columns-rows"},{"title":"Train-Test Split component","href":"/components/processing/train-test-split"}]},{"group":"Feature Engineering","pages":[{"title":"Feature Extraction component","href":"/components/feature-engineering/feature-extraction"},{"title":"Feature Transformation component","href":"/components/feature-engineering/feature-transformation"},{"title":"Feature Selection component","description":"Keep only the most informative features in your dataset using statistical tests, model-based importance, and recursive feature elimination methods.","href":"/components/feature-engineering/feature-selection"}]},{"group":"Data Wrangling","pages":[{"title":"Merge and Join DataFrames component","href":"/components/wrangling/merge-join"},{"title":"Concatenate DataFrames component","description":"Stack two DataFrames vertically to add more rows or horizontally to add more columns, with control over index alignment and join behavior.","href":"/components/wrangling/concatenate"}]},{"group":"Analytics","pages":[{"title":"Exploratory data analysis (EDA) component","href":"/components/analytics/eda"}]},{"group":"Models — Classification","pages":[{"title":"Random Forest Classifier component","href":"/components/models/classification/random-forest"},{"title":"Logistic Regression Classifier component","href":"/components/models/classification/logistic-regression"},{"title":"Support Vector Classifier (SVC) component","href":"/components/models/classification/svc"},{"title":"Decision Tree Classifier component","href":"/components/models/classification/decision-tree"},{"title":"Gradient Boosting Classifier component","href":"/components/models/classification/gradient-boosting"},{"title":"K-Nearest Neighbors Classifier component","href":"/components/models/classification/knn"}]},{"group":"Models — Regression","pages":[{"title":"Linear Regression component","href":"/components/models/regression/linear-regression"},{"title":"Ridge Regression component","href":"/components/models/regression/ridge"},{"title":"Lasso Regression component","href":"/components/models/regression/lasso"},{"title":"Random Forest Regressor component","href":"/components/models/regression/random-forest"},{"title":"Support Vector Regressor (SVR) component","href":"/components/models/regression/svr"},{"title":"Decision Tree Regressor component","href":"/components/models/regression/decision-tree"},{"title":"Gradient Boosting Regressor component","href":"/components/models/regression/gradient-boosting"},{"title":"K-Nearest Neighbors Regressor component","href":"/components/models/regression/knn"}]},{"group":"Evaluation \u0026 Inference","pages":[{"title":"Model evaluation component","href":"/components/evaluation/evaluation"},{"title":"Model inference component","href":"/components/evaluation/inference"},{"title":"Model Selector component","href":"/components/evaluation/model-selector"}]}]},"title":"Merge and Join DataFrames component - ClickML Studio","buildId":"dpl_2oYXwqkEXirXBPk8wV1FtM5USFWi","deploymentId":"dpl_2oYXwqkEXirXBPk8wV1FtM5USFWi","dynamics":[],"chunks":[]}