{"id":14923,"date":"2024-03-15T10:11:26","date_gmt":"2024-03-15T10:11:26","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-merge-multiple-data-tables-with-the-same-columns-in-r\/"},"modified":"2025-08-06T14:15:32","modified_gmt":"2025-08-06T14:15:32","slug":"how-to-merge-multiple-data-tables-with-the-same-columns-in-r","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-merge-multiple-data-tables-with-the-same-columns-in-r\/","title":{"rendered":"How to merge multiple data tables with the same columns&#8230;"},"content":{"rendered":"<p>In R language, you can use the merge() function to combine multiple data tables based on the same column. Below is an example code:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-comment\"># \u521b\u5efa\u6570\u636e\u88681<\/span>\r\ndf1 <span class=\"hljs-operator\">&lt;-<\/span> data.frame<span class=\"hljs-punctuation\">(<\/span>ID <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-built_in\">c<\/span><span class=\"hljs-punctuation\">(<\/span><span class=\"hljs-number\">1<\/span><span class=\"hljs-punctuation\">,<\/span> <span class=\"hljs-number\">2<\/span><span class=\"hljs-punctuation\">,<\/span> <span class=\"hljs-number\">3<\/span><span class=\"hljs-punctuation\">)<\/span><span class=\"hljs-punctuation\">,<\/span>\r\n                  Name <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-built_in\">c<\/span><span class=\"hljs-punctuation\">(<\/span><span class=\"hljs-string\">\"Alice\"<\/span><span class=\"hljs-punctuation\">,<\/span> <span class=\"hljs-string\">\"Bob\"<\/span><span class=\"hljs-punctuation\">,<\/span> <span class=\"hljs-string\">\"Charlie\"<\/span><span class=\"hljs-punctuation\">)<\/span><span class=\"hljs-punctuation\">)<\/span>\r\n\r\n<span class=\"hljs-comment\"># \u521b\u5efa\u6570\u636e\u88682<\/span>\r\ndf2 <span class=\"hljs-operator\">&lt;-<\/span> data.frame<span class=\"hljs-punctuation\">(<\/span>ID <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-built_in\">c<\/span><span class=\"hljs-punctuation\">(<\/span><span class=\"hljs-number\">2<\/span><span class=\"hljs-punctuation\">,<\/span> <span class=\"hljs-number\">3<\/span><span class=\"hljs-punctuation\">,<\/span> <span class=\"hljs-number\">4<\/span><span class=\"hljs-punctuation\">)<\/span><span class=\"hljs-punctuation\">,<\/span>\r\n                  Age <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-built_in\">c<\/span><span class=\"hljs-punctuation\">(<\/span><span class=\"hljs-number\">25<\/span><span class=\"hljs-punctuation\">,<\/span> <span class=\"hljs-number\">30<\/span><span class=\"hljs-punctuation\">,<\/span> <span class=\"hljs-number\">35<\/span><span class=\"hljs-punctuation\">)<\/span><span class=\"hljs-punctuation\">)<\/span>\r\n\r\n<span class=\"hljs-comment\"># \u5408\u5e76\u6570\u636e\u88681\u548c\u6570\u636e\u88682<\/span>\r\nmerged_df <span class=\"hljs-operator\">&lt;-<\/span> merge<span class=\"hljs-punctuation\">(<\/span>df1<span class=\"hljs-punctuation\">,<\/span> df2<span class=\"hljs-punctuation\">,<\/span> by <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">\"ID\"<\/span><span class=\"hljs-punctuation\">)<\/span>\r\n\r\n<span class=\"hljs-comment\"># \u6253\u5370\u5408\u5e76\u540e\u7684\u6570\u636e\u8868<\/span>\r\nprint<span class=\"hljs-punctuation\">(<\/span>merged_df<span class=\"hljs-punctuation\">)<\/span>\r\n<\/code><\/pre>\n<p>After running the above code, the merged data table will appear as follows:<\/p>\n<pre class=\"post-pre\"><code>  ID   Name Age\r\n1  2    Bob  25\r\n2  3 Charlie  30\r\n<\/code><\/pre>\n<p>In the merge() function, the parameter by specifies which column to merge by. In the example above, we chose the &#8220;ID&#8221; column as the basis for merging. If both tables have columns with the same name, you can use the by.x and by.y parameters to specify the corresponding column names in table 1 and table 2, respectively.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In R language, you can use the merge() function to combine multiple data tables based on the same column. Below is an example code: # \u521b\u5efa\u6570\u636e\u88681 df1 &lt;- data.frame(ID = c(1, 2, 3), Name = c(&#8220;Alice&#8221;, &#8220;Bob&#8221;, &#8220;Charlie&#8221;)) # \u521b\u5efa\u6570\u636e\u88682 df2 &lt;- data.frame(ID = c(2, 3, 4), Age = c(25, 30, 35)) # \u5408\u5e76\u6570\u636e\u88681\u548c\u6570\u636e\u88682 merged_df [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[453,1402,299,1404,1403],"class_list":["post-14923","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-development","tag-guide","tag-programming","tag-technology","tag-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to merge multiple data tables with the same columns... - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn about how to merge multiple data tables with the same columns in r?. Comprehensive guide with examples and best practices.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-to-merge-multiple-data-tables-with-the-same-columns-in-r\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to merge multiple data tables with the same columns...\" \/>\n<meta property=\"og:description\" content=\"Learn about how to merge multiple data tables with the same columns in r?. Comprehensive guide with examples and best practices.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-merge-multiple-data-tables-with-the-same-columns-in-r\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T10:11:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-06T14:15:32+00:00\" \/>\n<meta name=\"author\" content=\"Emily Johnson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Emily Johnson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-merge-multiple-data-tables-with-the-same-columns-in-r\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-merge-multiple-data-tables-with-the-same-columns-in-r\/\"},\"author\":{\"name\":\"Emily Johnson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378\"},\"headline\":\"How to merge multiple data tables with the same columns&#8230;\",\"datePublished\":\"2024-03-15T10:11:26+00:00\",\"dateModified\":\"2025-08-06T14:15:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-merge-multiple-data-tables-with-the-same-columns-in-r\/\"},\"wordCount\":104,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"Development\",\"guide\",\"programming\",\"technology\",\"tutorial\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-merge-multiple-data-tables-with-the-same-columns-in-r\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-merge-multiple-data-tables-with-the-same-columns-in-r\/\",\"name\":\"How to merge multiple data tables with the same columns... - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T10:11:26+00:00\",\"dateModified\":\"2025-08-06T14:15:32+00:00\",\"description\":\"Learn about how to merge multiple data tables with the same columns in r?. Comprehensive guide with examples and best practices.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-merge-multiple-data-tables-with-the-same-columns-in-r\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-merge-multiple-data-tables-with-the-same-columns-in-r\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-merge-multiple-data-tables-with-the-same-columns-in-r\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to merge multiple data tables with the same columns&#8230;\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378\",\"name\":\"Emily Johnson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g\",\"caption\":\"Emily Johnson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/emilyjohnson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to merge multiple data tables with the same columns... - Blog - Silicon Cloud","description":"Learn about how to merge multiple data tables with the same columns in r?. Comprehensive guide with examples and best practices.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-to-merge-multiple-data-tables-with-the-same-columns-in-r\/","og_locale":"en_US","og_type":"article","og_title":"How to merge multiple data tables with the same columns...","og_description":"Learn about how to merge multiple data tables with the same columns in r?. Comprehensive guide with examples and best practices.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-merge-multiple-data-tables-with-the-same-columns-in-r\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T10:11:26+00:00","article_modified_time":"2025-08-06T14:15:32+00:00","author":"Emily Johnson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Emily Johnson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-merge-multiple-data-tables-with-the-same-columns-in-r\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-merge-multiple-data-tables-with-the-same-columns-in-r\/"},"author":{"name":"Emily Johnson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378"},"headline":"How to merge multiple data tables with the same columns&#8230;","datePublished":"2024-03-15T10:11:26+00:00","dateModified":"2025-08-06T14:15:32+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-merge-multiple-data-tables-with-the-same-columns-in-r\/"},"wordCount":104,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["Development","guide","programming","technology","tutorial"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-merge-multiple-data-tables-with-the-same-columns-in-r\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-merge-multiple-data-tables-with-the-same-columns-in-r\/","name":"How to merge multiple data tables with the same columns... - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T10:11:26+00:00","dateModified":"2025-08-06T14:15:32+00:00","description":"Learn about how to merge multiple data tables with the same columns in r?. Comprehensive guide with examples and best practices.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-merge-multiple-data-tables-with-the-same-columns-in-r\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-merge-multiple-data-tables-with-the-same-columns-in-r\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-merge-multiple-data-tables-with-the-same-columns-in-r\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to merge multiple data tables with the same columns&#8230;"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378","name":"Emily Johnson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g","caption":"Emily Johnson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/emilyjohnson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/14923","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=14923"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/14923\/revisions"}],"predecessor-version":[{"id":158842,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/14923\/revisions\/158842"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=14923"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=14923"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=14923"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}