{"id":2940,"date":"2023-07-20T00:09:11","date_gmt":"2023-07-20T00:09:11","guid":{"rendered":"https:\/\/statorials.org\/id\/gabung-dalam-r\/"},"modified":"2023-07-20T00:09:11","modified_gmt":"2023-07-20T00:09:11","slug":"gabung-dalam-r","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/gabung-dalam-r\/","title":{"rendered":"Cara melakukan inner join di r (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

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

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

 merge(df1, df2, by=' column_to_join_on<\/span> ')\n<\/strong><\/pre>\n
 Metode 2: gunakan dplyr<\/span><\/strong><\/span><\/p>\n
 library<\/span> (dplyr)\n\n<\/span>inner_join(df1, df2, by=' column_to_join_on<\/span> ')<\/strong><\/pre>\n
 Kedua metode akan menghasilkan hasil yang sama, namun metode dplyr 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', 'G', 'H'),\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\n5G 10\n6:8 a.m.<\/strong><\/pre>\n
 Contoh 1: Gabungan dalam menggunakan Basis R<\/strong><\/span><\/h3>\n
 Kita dapat menggunakan fungsi merge()<\/strong> di basis R untuk melakukan penggabungan dalam, menggunakan kolom ‘tim’ sebagai kolom untuk bergabung:<\/span><\/p>\n
 #perform inner join using base R<\/span>\ndf3 <- merge(df1, df2, by=' team<\/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 G 20 10\n6:28 a.m. 8\n<\/strong><\/pre>\n
 Perhatikan bahwa hanya tim yang muncul di kedua kumpulan data yang dipertahankan di kumpulan data akhir.<\/span><\/p>\n
 Contoh 2: Gabungan dalam menggunakan dplyr<\/strong><\/span><\/h3>\n
 Kita dapat menggunakan fungsi inner_join()<\/strong> dari paket dplyr<\/a> untuk melakukan inner join, menggunakan kolom ‘team’ sebagai kolom untuk bergabung:<\/span><\/p>\n
 library<\/span> (dplyr)\n\n#perform inner join using dplyr<\/span> \ndf3 <- inner_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 G 20 10\n6:28 a.m. 8<\/strong><\/pre>\n
 Perhatikan bahwa ini sesuai dengan hasil yang kita peroleh dengan menggunakan fungsi merge()<\/strong> di basis R.<\/span><\/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 menambahkan kolom ke bingkai data di R<\/a>
 Cara menghapus kolom dari bingkai data di R<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Ada dua cara umum untuk melakukan inner join di R: Metode 1: Gunakan Basis R merge(df1, df2, by=’ column_to_join_on ‘) Metode 2: gunakan dplyr library (dplyr) inner_join(df1, df2, by=’ column_to_join_on ‘) Kedua metode akan menghasilkan hasil yang sama, namun metode dplyr akan cenderung bekerja lebih cepat pada kumpulan data yang sangat besar. Contoh berikut menunjukkan […]<\/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 Inner Join di R (dengan Contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan inner join 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-dalam-r\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Melakukan Inner Join di R (dengan Contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan inner join di R, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/gabung-dalam-r\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T00:09:11+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-dalam-r\/\",\"url\":\"https:\/\/statorials.org\/id\/gabung-dalam-r\/\",\"name\":\"Cara Melakukan Inner Join di R (dengan Contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T00:09:11+00:00\",\"dateModified\":\"2023-07-20T00:09:11+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan inner join di R, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/gabung-dalam-r\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/gabung-dalam-r\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/gabung-dalam-r\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melakukan inner join 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 Inner Join di R (dengan Contoh) - Statorials","description":"Tutorial ini menjelaskan cara melakukan inner join 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-dalam-r\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Melakukan Inner Join di R (dengan Contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara melakukan inner join di R, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/gabung-dalam-r\/","og_site_name":"Statorials","article_published_time":"2023-07-20T00:09:11+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-dalam-r\/","url":"https:\/\/statorials.org\/id\/gabung-dalam-r\/","name":"Cara Melakukan Inner Join di R (dengan Contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T00:09:11+00:00","dateModified":"2023-07-20T00:09:11+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan inner join di R, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/gabung-dalam-r\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/gabung-dalam-r\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/gabung-dalam-r\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melakukan inner join 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\/2940"}],"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=2940"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2940\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2940"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2940"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2940"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}