{"id":2084,"date":"2023-07-23T18:54:13","date_gmt":"2023-07-23T18:54:13","guid":{"rendered":"https:\/\/statorials.org\/id\/r-menggabungkan-beberapa-kolom-2\/"},"modified":"2023-07-23T18:54:13","modified_gmt":"2023-07-23T18:54:13","slug":"r-menggabungkan-beberapa-kolom-2","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/r-menggabungkan-beberapa-kolom-2\/","title":{"rendered":"A: cara menggabungkan bingkai data berdasarkan beberapa kolom"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk menggabungkan dua bingkai data di R berdasarkan beberapa kolom:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>merge(df1, df2, by. <span style=\"color: #3366ff;\">x<\/span> =c(' <span style=\"color: #ff0000;\">col1<\/span> ', ' <span style=\"color: #ff0000;\">col2<\/span> '), by. <span style=\"color: #3366ff;\">y<\/span> =c(' <span style=\"color: #ff0000;\">col1<\/span> ', ' <span style=\"color: #ff0000;\">col2<\/span> '))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Gabungkan blok data di beberapa kolom<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki dua frame data berikut di R:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008080;\">#define data frames<\/span>\ndf1 = data. <span style=\"color: #3366ff;\">frame<\/span> (playerID=c(1, 2, 3, 4, 5, 6),\n                 team=c('A', 'B', 'B', 'B', 'C', 'C'),\n                 dots=c(19, 22, 25, 29, 34, 39))\n\ndf2 = data. <span style=\"color: #3366ff;\">frame<\/span> (playerID=c(1, 2, 3, 4),\n                 tm=c('A', 'B', 'B', 'B'),\n                 rebounds=c(7, 8, 8, 14))\n\n<span style=\"color: #008080;\">#view first data frame<\/span>\ndf1\n\n  playerID team points\n1 1 A 19\n2 2 B 22\n3 3 B 25\n4 4 B 29\n5 5 C 34\n6 6 C 39\n\n<span style=\"color: #008080;\">#view second data frame\n<\/span>df2 \n\n  playerID tm rebounds\n1 1 To 7\n2 2 B 8\n3 3 B 8\n4 4 B 14<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kedua bingkai data berbagi kolom <strong>ID Pemain<\/strong> , namun kolom tim memiliki nama berbeda di setiap bingkai data:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Bingkai data pertama memiliki kolom \u201c <strong>tim<\/strong> \u201d.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Bingkai data kedua memiliki kolom &#8216; <strong>tm<\/strong> &#8216;<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Untuk menggabungkan bingkai data ini berdasarkan kolom playerID dan tim, kita perlu menggunakan argumen <strong>by.x<\/strong> dan <strong>by.y.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk melakukan penggabungan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#merge two data frames<\/span>\n<span style=\"color: #000000;\">merged = merge(df1, df2, by. <span style=\"color: #3366ff;\">x<\/span> =c(' <span style=\"color: #ff0000;\">playerID<\/span> ', ' <span style=\"color: #ff0000;\">team<\/span> '), by. <span style=\"color: #3366ff;\">y<\/span> =c(' <span style=\"color: #ff0000;\">playerID<\/span> ', ' <span style=\"color: #ff0000;\">tm<\/span> '))\n\n<span style=\"color: #008080;\">#view merged data frame\n<\/span>merged\n\n  playerID team points rebounds\n1 1 A 19 7\n2 2 B 22 8\n3 3 B 25 8\n4 4 B 29 14<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Bingkai data gabungan terakhir berisi data untuk keempat pemain yang termasuk dalam dua bingkai data asli.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara menjalankan fungsi bingkai data umum lainnya di R:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/kiri-bergabung-r\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara melakukan gabung kiri di R<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vlookup-di-r\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara melakukan VLOOKUP di R<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/r-tambahkan-ke-kerangka-data\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan baris ke bingkai data di R<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk menggabungkan dua bingkai data di R berdasarkan beberapa kolom: merge(df1, df2, by. x =c(&#8216; col1 &#8216;, &#8216; col2 &#8216;), by. y =c(&#8216; col1 &#8216;, &#8216; col2 &#8216;)) Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh: Gabungkan blok data di beberapa kolom Misalkan kita memiliki dua frame [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>A: Cara menggabungkan bingkai data berdasarkan beberapa kolom - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggabungkan dua frame data di R berdasarkan beberapa kolom, dengan sebuah contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/r-menggabungkan-beberapa-kolom-2\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A: Cara menggabungkan bingkai data berdasarkan beberapa kolom - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggabungkan dua frame data di R berdasarkan beberapa kolom, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/r-menggabungkan-beberapa-kolom-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-23T18:54:13+00:00\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/r-menggabungkan-beberapa-kolom-2\/\",\"url\":\"https:\/\/statorials.org\/id\/r-menggabungkan-beberapa-kolom-2\/\",\"name\":\"A: Cara menggabungkan bingkai data berdasarkan beberapa kolom - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-23T18:54:13+00:00\",\"dateModified\":\"2023-07-23T18:54:13+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggabungkan dua frame data di R berdasarkan beberapa kolom, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/r-menggabungkan-beberapa-kolom-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/r-menggabungkan-beberapa-kolom-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/r-menggabungkan-beberapa-kolom-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"A: cara menggabungkan bingkai data berdasarkan beberapa kolom\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"A: Cara menggabungkan bingkai data berdasarkan beberapa kolom - Statologi","description":"Tutorial ini menjelaskan cara menggabungkan dua frame data di R berdasarkan beberapa kolom, dengan sebuah contoh.","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:\/\/statorials.org\/id\/r-menggabungkan-beberapa-kolom-2\/","og_locale":"id_ID","og_type":"article","og_title":"A: Cara menggabungkan bingkai data berdasarkan beberapa kolom - Statologi","og_description":"Tutorial ini menjelaskan cara menggabungkan dua frame data di R berdasarkan beberapa kolom, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/r-menggabungkan-beberapa-kolom-2\/","og_site_name":"Statorials","article_published_time":"2023-07-23T18:54:13+00:00","author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/r-menggabungkan-beberapa-kolom-2\/","url":"https:\/\/statorials.org\/id\/r-menggabungkan-beberapa-kolom-2\/","name":"A: Cara menggabungkan bingkai data berdasarkan beberapa kolom - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-23T18:54:13+00:00","dateModified":"2023-07-23T18:54:13+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggabungkan dua frame data di R berdasarkan beberapa kolom, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/r-menggabungkan-beberapa-kolom-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/r-menggabungkan-beberapa-kolom-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/r-menggabungkan-beberapa-kolom-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"A: cara menggabungkan bingkai data berdasarkan beberapa kolom"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2084"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=2084"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2084\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2084"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2084"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2084"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}