{"id":21804,"date":"2024-03-15T22:37:09","date_gmt":"2024-03-15T22:37:09","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-frames-be-merged-in-r-language\/"},"modified":"2024-03-21T21:21:39","modified_gmt":"2024-03-21T21:21:39","slug":"how-can-multiple-data-frames-be-merged-in-r-language","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-frames-be-merged-in-r-language\/","title":{"rendered":"How can multiple data frames be merged in R language?"},"content":{"rendered":"<p>In R language, you can merge multiple data frames using either the merge() function or the rbind() function.<\/p>\n<ol>\n<li>Merge data frames using the merge() function:<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-comment\"># \u521b\u5efa\u4e24\u4e2a\u6570\u636e\u6846 df1 \u548c df2<\/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\">\"Tom\"<\/span><span class=\"hljs-punctuation\">,<\/span> <span class=\"hljs-string\">\"Jerry\"<\/span><span class=\"hljs-punctuation\">,<\/span> <span class=\"hljs-string\">\"Mickey\"<\/span><span class=\"hljs-punctuation\">)<\/span><span class=\"hljs-punctuation\">)<\/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\">20<\/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-punctuation\">)<\/span>\r\n\r\n<span class=\"hljs-comment\"># \u4f7f\u7528merge()\u51fd\u6570\u5408\u5e76\u6570\u636e\u6846<\/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> <span class=\"hljs-built_in\">all<\/span> <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-literal\">TRUE<\/span><span class=\"hljs-punctuation\">)<\/span>\r\nprint<span class=\"hljs-punctuation\">(<\/span>merged_df<span class=\"hljs-punctuation\">)<\/span>\r\n<\/code><\/pre>\n<p>In the above code, the merge() function has the first argument as the two data frames to be merged, the by parameter specifies which variable to merge on, and setting the all parameter to TRUE keeps all merge results.<\/p>\n<ol>\n<li>Combine data frames using the rbind() function.<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-comment\"># \u521b\u5efa\u4e24\u4e2a\u6570\u636e\u6846 df1 \u548c df2<\/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\">\"Tom\"<\/span><span class=\"hljs-punctuation\">,<\/span> <span class=\"hljs-string\">\"Jerry\"<\/span><span class=\"hljs-punctuation\">,<\/span> <span class=\"hljs-string\">\"Mickey\"<\/span><span class=\"hljs-punctuation\">)<\/span><span class=\"hljs-punctuation\">)<\/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                  Name <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-built_in\">c<\/span><span class=\"hljs-punctuation\">(<\/span><span class=\"hljs-string\">\"John\"<\/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-punctuation\">)<\/span>\r\n\r\n<span class=\"hljs-comment\"># \u4f7f\u7528rbind()\u51fd\u6570\u5408\u5e76\u6570\u636e\u6846<\/span>\r\nmerged_df <span class=\"hljs-operator\">&lt;-<\/span> rbind<span class=\"hljs-punctuation\">(<\/span>df1<span class=\"hljs-punctuation\">,<\/span> df2<span class=\"hljs-punctuation\">)<\/span>\r\nprint<span class=\"hljs-punctuation\">(<\/span>merged_df<span class=\"hljs-punctuation\">)<\/span>\r\n<\/code><\/pre>\n<p>In the above code, the rbind() function takes as parameters two or more data frames to be merged, combining them row by row into a new data frame.<\/p>\n<p>It is important to note that when merging data frames, ensure that the variables to be merged are of the same type and in the same order to avoid getting incorrect results.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In R language, you can merge multiple data frames using either the merge() function or the rbind() function. Merge data frames using the merge() function: # \u521b\u5efa\u4e24\u4e2a\u6570\u636e\u6846 df1 \u548c df2 df1 &lt;- data.frame(ID = c(1, 2, 3), Name = c(&#8220;Tom&#8221;, &#8220;Jerry&#8221;, &#8220;Mickey&#8221;)) df2 &lt;- data.frame(ID = c(2, 3, 4), Age = c(20, 25, 30)) # [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-21804","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"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 can multiple data frames be merged in R language? - Blog - Silicon Cloud<\/title>\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-can-multiple-data-frames-be-merged-in-r-language\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How can multiple data frames be merged in R language?\" \/>\n<meta property=\"og:description\" content=\"In R language, you can merge multiple data frames using either the merge() function or the rbind() function. Merge data frames using the merge() function: # \u521b\u5efa\u4e24\u4e2a\u6570\u636e\u6846 df1 \u548c df2 df1 &lt;- data.frame(ID = c(1, 2, 3), Name = c(&quot;Tom&quot;, &quot;Jerry&quot;, &quot;Mickey&quot;)) df2 &lt;- data.frame(ID = c(2, 3, 4), Age = c(20, 25, 30)) # [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-frames-be-merged-in-r-language\/\" \/>\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-15T22:37:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T21:21:39+00:00\" \/>\n<meta name=\"author\" content=\"Sophia Anderson\" \/>\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=\"Sophia Anderson\" \/>\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-can-multiple-data-frames-be-merged-in-r-language\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-frames-be-merged-in-r-language\/\"},\"author\":{\"name\":\"Sophia Anderson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30\"},\"headline\":\"How can multiple data frames be merged in R language?\",\"datePublished\":\"2024-03-15T22:37:09+00:00\",\"dateModified\":\"2024-03-21T21:21:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-frames-be-merged-in-r-language\/\"},\"wordCount\":141,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-frames-be-merged-in-r-language\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-frames-be-merged-in-r-language\/\",\"name\":\"How can multiple data frames be merged in R language? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T22:37:09+00:00\",\"dateModified\":\"2024-03-21T21:21:39+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-frames-be-merged-in-r-language\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-frames-be-merged-in-r-language\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-frames-be-merged-in-r-language\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How can multiple data frames be merged in R language?\"}]},{\"@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\/19a24313de9c988db3d69226b4a40a30\",\"name\":\"Sophia Anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g\",\"caption\":\"Sophia Anderson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/sophiaanderson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How can multiple data frames be merged in R language? - Blog - Silicon Cloud","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-can-multiple-data-frames-be-merged-in-r-language\/","og_locale":"en_US","og_type":"article","og_title":"How can multiple data frames be merged in R language?","og_description":"In R language, you can merge multiple data frames using either the merge() function or the rbind() function. Merge data frames using the merge() function: # \u521b\u5efa\u4e24\u4e2a\u6570\u636e\u6846 df1 \u548c df2 df1 &lt;- data.frame(ID = c(1, 2, 3), Name = c(\"Tom\", \"Jerry\", \"Mickey\")) df2 &lt;- data.frame(ID = c(2, 3, 4), Age = c(20, 25, 30)) # [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-frames-be-merged-in-r-language\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T22:37:09+00:00","article_modified_time":"2024-03-21T21:21:39+00:00","author":"Sophia Anderson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Sophia Anderson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-frames-be-merged-in-r-language\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-frames-be-merged-in-r-language\/"},"author":{"name":"Sophia Anderson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30"},"headline":"How can multiple data frames be merged in R language?","datePublished":"2024-03-15T22:37:09+00:00","dateModified":"2024-03-21T21:21:39+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-frames-be-merged-in-r-language\/"},"wordCount":141,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-frames-be-merged-in-r-language\/","url":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-frames-be-merged-in-r-language\/","name":"How can multiple data frames be merged in R language? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T22:37:09+00:00","dateModified":"2024-03-21T21:21:39+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-frames-be-merged-in-r-language\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-frames-be-merged-in-r-language\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-can-multiple-data-frames-be-merged-in-r-language\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How can multiple data frames be merged in R language?"}]},{"@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\/19a24313de9c988db3d69226b4a40a30","name":"Sophia Anderson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g","caption":"Sophia Anderson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/sophiaanderson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/21804","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\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=21804"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/21804\/revisions"}],"predecessor-version":[{"id":55687,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/21804\/revisions\/55687"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=21804"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=21804"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=21804"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}