{"id":2942,"date":"2023-07-19T23:54:37","date_gmt":"2023-07-19T23:54:37","guid":{"rendered":"https:\/\/statorials.org\/id\/gabung-luar-r\/"},"modified":"2023-07-19T23:54:37","modified_gmt":"2023-07-19T23:54:37","slug":"gabung-luar-r","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/gabung-luar-r\/","title":{"rendered":"Cara melakukan penggabungan luar di r (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Ada dua cara umum untuk melakukan gabungan luar di R:<\/span><\/p>\n

Metode 1: Gunakan Basis R<\/strong><\/span><\/p>\n

 merge(df1, df2, by=' column_to_join_on<\/span> ', all= TRUE<\/span> )\n<\/strong><\/pre>\n
 Metode 2: gunakan dplyr<\/strong><\/span><\/p>\n
 library<\/span> (dplyr)\n\n<\/span>full_join(df1, df2, by=' column_to_join_on<\/span> ')<\/strong><\/pre>\n
 Setiap metode akan mengembalikan semua baris dari kedua tabel.<\/span><\/p>\n
 Kedua metode akan menghasilkan hasil yang sama, namun metode dplyr<\/strong> akan cenderung bekerja lebih cepat pada kumpulan data yang sangat besar.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan masing-masing fungsi ini dalam praktik dengan bingkai data berikut:<\/span><\/p>\n
 #define first data frame\n<\/span>df1 = data. frame<\/span> (team=c('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H'),\n                 points=c(18, 22, 19, 14, 14, 11, 20, 28))\n\ndf1\n\n  team points\n1 to 18\n2 B 22\n3 C 19\n4 D 14\n5 E 14\n6 F 11\n7 G 20\n8:28 a.m.\n\n#define second data frame\n<\/span>df2 = data. frame<\/span> (team=c('A', 'B', 'C', 'D', 'L', 'M'),\n                 assists=c(4, 9, 14, 13, 10, 8))\n\ndf2\n\n  team assists\n1 to 4\n2 B 9\n3 C 14\n4 D 13\n5 L 10\n6 M 8<\/strong><\/pre>\n
 Contoh 1: Gabungan luar menggunakan Basis R<\/strong><\/span><\/h3>\n
 Kita dapat menggunakan fungsi merge()<\/strong> di basis R untuk melakukan penggabungan luar, menggunakan kolom ‘tim’ sebagai kolom untuk bergabung:<\/span><\/p>\n
 #perform outer join using base R<\/span>\ndf3 <- merge(df1, df2, by=' team<\/span> ', all= TRUE<\/span> )\n\n#view result<\/span>\ndf3\n\n   team points assists\n1 to 18 4\n2 B 22 9\n3 C 19 14\n4 D 14 13\n5 E 14 NA\n6 F 11 NA\n7 G 20 NA\n8:28 AM NA\n9L NA 10\n10M NA 8\n<\/strong><\/pre>\n
 Perhatikan bahwa semua baris di kedua bingkai data dikembalikan.<\/span><\/p>\n
 Contoh 2: Gabungan luar menggunakan dplyr<\/strong><\/span><\/h3>\n
 Kita dapat menggunakan fungsi full_join()<\/strong> dari paket dplyr<\/a> untuk melakukan penggabungan luar, menggunakan kolom ‘tim’ sebagai kolom untuk bergabung:<\/span><\/p>\n
 library<\/span> (dplyr)\n\n#perform outer join using dplyr<\/span> \ndf3 <- full_join(df1, df2, by=' team<\/span> ')\n\n#view result\n<\/span>df3\n\n   team points assists\n1 to 18 4\n2 B 22 9\n3 C 19 14\n4 D 14 13\n5 E 14 NA\n6 F 11 NA\n7 G 20 NA\n8:28 AM NA\n9L NA 10\n10M NA 8<\/strong><\/pre>\n
 Perhatikan bahwa ini sesuai dengan hasil yang kita peroleh dengan menggunakan fungsi merge()<\/strong> di basis R.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di R:<\/span><\/p>\n
 Bagaimana cara melakukan gabung kiri di R<\/a>
 Bagaimana cara melakukan join yang benar di R<\/a>
 Bagaimana cara melakukan inner join di R<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Ada dua cara umum untuk melakukan gabungan luar di R: Metode 1: Gunakan Basis R merge(df1, df2, by=’ column_to_join_on ‘, all= TRUE ) Metode 2: gunakan dplyr library (dplyr) full_join(df1, df2, by=’ column_to_join_on ‘) Setiap metode akan mengembalikan semua baris dari kedua tabel. Kedua metode akan menghasilkan hasil yang sama, namun metode dplyr akan cenderung […]<\/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":"\nCara melakukan gabungan luar di R (dengan contoh) - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan penggabungan luar di R, dengan beberapa 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\/gabung-luar-r\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara melakukan gabungan luar di R (dengan contoh) - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan penggabungan luar di R, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/gabung-luar-r\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-19T23:54:37+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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/gabung-luar-r\/\",\"url\":\"https:\/\/statorials.org\/id\/gabung-luar-r\/\",\"name\":\"Cara melakukan gabungan luar di R (dengan contoh) - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-19T23:54:37+00:00\",\"dateModified\":\"2023-07-19T23:54:37+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan penggabungan luar di R, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/gabung-luar-r\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/gabung-luar-r\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/gabung-luar-r\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan penggabungan luar di r (dengan contoh)\"}]},{\"@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":"Cara melakukan gabungan luar di R (dengan contoh) - Statorial","description":"Tutorial ini menjelaskan cara melakukan penggabungan luar di R, dengan beberapa 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\/gabung-luar-r\/","og_locale":"id_ID","og_type":"article","og_title":"Cara melakukan gabungan luar di R (dengan contoh) - Statorial","og_description":"Tutorial ini menjelaskan cara melakukan penggabungan luar di R, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/gabung-luar-r\/","og_site_name":"Statorials","article_published_time":"2023-07-19T23:54:37+00:00","author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/gabung-luar-r\/","url":"https:\/\/statorials.org\/id\/gabung-luar-r\/","name":"Cara melakukan gabungan luar di R (dengan contoh) - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-19T23:54:37+00:00","dateModified":"2023-07-19T23:54:37+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan penggabungan luar di R, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/gabung-luar-r\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/gabung-luar-r\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/gabung-luar-r\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan penggabungan luar di r (dengan contoh)"}]},{"@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\/2942"}],"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=2942"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2942\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2942"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2942"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2942"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}