{"id":4508,"date":"2023-07-10T13:04:53","date_gmt":"2023-07-10T13:04:53","guid":{"rendered":"https:\/\/statorials.org\/id\/dplyr-kiri-bergabung-dengan-nama-kolom-yang-berbeda\/"},"modified":"2023-07-10T13:04:53","modified_gmt":"2023-07-10T13:04:53","slug":"dplyr-kiri-bergabung-dengan-nama-kolom-yang-berbeda","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/dplyr-kiri-bergabung-dengan-nama-kolom-yang-berbeda\/","title":{"rendered":"Gabung kiri di dplyr dengan nama kolom berbeda"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut di dplyr untuk menggabungkan dua bingkai data ke kiri ketika kolom yang Anda gabung memiliki nama berbeda di setiap bingkai data:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #000000;\"><span style=\"color: #008000;\">library<\/span> (dplyr)\n\n<\/span>final_df &lt;- left_join(df_A, df_B, by = c(' <span style=\"color: #ff0000;\">team<\/span> ' = ' <span style=\"color: #ff0000;\">team_name<\/span> '))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini akan melakukan penggabungan kiri pada bingkai data yang disebut <strong>df_A<\/strong> dan <strong>df_B<\/strong> , menggabungkan kolom dari <strong>df_A<\/strong> yang disebut <strong>team<\/strong> dan kolom dari <strong>df_B<\/strong> yang disebut <strong>team_name<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Lakukan gabung kiri dengan nama kolom berbeda di dplyr<\/strong><\/span><\/h2>\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;\"> <strong><span style=\"color: #008080;\">#create first data frame\n<\/span>df_A &lt;- data. <span style=\"color: #3366ff;\">frame<\/span> (team=c('A', 'B', 'C', 'D', 'E'),\n                   dots=c(22, 25, 19, 14, 38))\n\ndf_A\n\n  team points\n1 to 22\n2 B 25\n3 C 19\n4 D 14\n5 E 38\n\n<span style=\"color: #008080;\">#create second data frame\n<\/span>df_B &lt;- data. <span style=\"color: #3366ff;\">frame<\/span> (team=c('A', 'C', 'D', 'F', 'G'),\n                   rebounds=c(14, 8, 8, 6, 9))\n\ndf_B\n\n  team_name rebounds\n1 to 14\n2 C 8\n3 D 8\n4 F 6\n5 G 9\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut di dplyr untuk melakukan penggabungan kiri berdasarkan nilai yang cocok di kolom <strong>tim<\/strong> <strong>df_A<\/strong> dan kolom <strong>nama_tim<\/strong> di <strong>df_B<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">library<\/span> (dplyr)\n\n<span style=\"color: #008080;\">#perform left join based on different column names in df_A and df_B\n<\/span>final_df &lt;- left_join(df_A, df_B, by = c(' <span style=\"color: #ff0000;\">team<\/span> ' = ' <span style=\"color: #ff0000;\">team_name<\/span> '))\n\n<span style=\"color: #008080;\">#view final data frame\n<\/span>final_df\n\n  team points rebounds\n1 to 22 14\n2 B 25 NA\n3 C 19 8\n4 D 14 8\n5 E 38 NA\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Bingkai data yang dihasilkan berisi semua baris dari <strong>df_A<\/strong> dan hanya baris dari <strong>df_B<\/strong> yang nilai <strong>tim<\/strong> cocok dengan nilai <strong>nama_tim<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa Anda juga dapat mencari di beberapa kolom dengan nama berbeda menggunakan sintaks dasar berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">library<\/span> (dplyr)\n\n<span style=\"color: #008080;\">#perform left join based on multiple different column names\n<\/span>final_df &lt;- left_join(df_A, df_B, by = c(' <span style=\"color: #ff0000;\">A1<\/span> ' = ' <span style=\"color: #ff0000;\">B1<\/span> ', ' <span style=\"color: #ff0000;\">A2<\/span> ' = ' <span style=\"color: #ff0000;\">B2<\/span> ', ' <span style=\"color: #ff0000;\">A3<\/span> ' = ' <span style=\"color: #ff0000;\">B3<\/span> '))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi <strong>left_join()<\/strong> di dplyr <a href=\"https:\/\/dplyr.tidyverse.org\/reference\/mutate-joins.html\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di R:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><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\/benar-bergabung-di-r\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara melakukan join yang benar di R<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/gabung-dalam-r\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara melakukan inner join di R<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/gabung-luar-r\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara melakukan gabung luar di R<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut di dplyr untuk menggabungkan dua bingkai data ke kiri ketika kolom yang Anda gabung memiliki nama berbeda di setiap bingkai data: library (dplyr) final_df &lt;- left_join(df_A, df_B, by = c(&#8216; team &#8216; = &#8216; team_name &#8216;)) Contoh khusus ini akan melakukan penggabungan kiri pada bingkai data yang disebut df_A [&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>Gabung ke kiri di dplyr dengan nama kolom berbeda - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melakukan join kiri menggunakan dplyr dengan nama kolom berbeda, beserta 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\/dplyr-kiri-bergabung-dengan-nama-kolom-yang-berbeda\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Gabung ke kiri di dplyr dengan nama kolom berbeda - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melakukan join kiri menggunakan dplyr dengan nama kolom berbeda, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/dplyr-kiri-bergabung-dengan-nama-kolom-yang-berbeda\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-10T13:04:53+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\/dplyr-kiri-bergabung-dengan-nama-kolom-yang-berbeda\/\",\"url\":\"https:\/\/statorials.org\/id\/dplyr-kiri-bergabung-dengan-nama-kolom-yang-berbeda\/\",\"name\":\"Gabung ke kiri di dplyr dengan nama kolom berbeda - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-10T13:04:53+00:00\",\"dateModified\":\"2023-07-10T13:04:53+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melakukan join kiri menggunakan dplyr dengan nama kolom berbeda, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/dplyr-kiri-bergabung-dengan-nama-kolom-yang-berbeda\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/dplyr-kiri-bergabung-dengan-nama-kolom-yang-berbeda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/dplyr-kiri-bergabung-dengan-nama-kolom-yang-berbeda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Gabung kiri di dplyr dengan nama kolom berbeda\"}]},{\"@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":"Gabung ke kiri di dplyr dengan nama kolom berbeda - Statorial","description":"Tutorial ini menjelaskan cara melakukan join kiri menggunakan dplyr dengan nama kolom berbeda, beserta 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\/dplyr-kiri-bergabung-dengan-nama-kolom-yang-berbeda\/","og_locale":"id_ID","og_type":"article","og_title":"Gabung ke kiri di dplyr dengan nama kolom berbeda - Statorial","og_description":"Tutorial ini menjelaskan cara melakukan join kiri menggunakan dplyr dengan nama kolom berbeda, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/dplyr-kiri-bergabung-dengan-nama-kolom-yang-berbeda\/","og_site_name":"Statorials","article_published_time":"2023-07-10T13:04:53+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\/dplyr-kiri-bergabung-dengan-nama-kolom-yang-berbeda\/","url":"https:\/\/statorials.org\/id\/dplyr-kiri-bergabung-dengan-nama-kolom-yang-berbeda\/","name":"Gabung ke kiri di dplyr dengan nama kolom berbeda - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-10T13:04:53+00:00","dateModified":"2023-07-10T13:04:53+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melakukan join kiri menggunakan dplyr dengan nama kolom berbeda, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/dplyr-kiri-bergabung-dengan-nama-kolom-yang-berbeda\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/dplyr-kiri-bergabung-dengan-nama-kolom-yang-berbeda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/dplyr-kiri-bergabung-dengan-nama-kolom-yang-berbeda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Gabung kiri di dplyr dengan nama kolom berbeda"}]},{"@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\/4508"}],"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=4508"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4508\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4508"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4508"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4508"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}