{"id":3475,"date":"2023-07-17T07:15:39","date_gmt":"2023-07-17T07:15:39","guid":{"rendered":"https:\/\/statorials.org\/id\/penggabungan-dplyr\/"},"modified":"2023-07-17T07:15:39","modified_gmt":"2023-07-17T07:15:39","slug":"penggabungan-dplyr","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/penggabungan-dplyr\/","title":{"rendered":"Cara menggunakan fungsi coalesce() di dplyr (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan fungsi <strong>coalesce()<\/strong> dari paket <a href=\"https:\/\/dplyr.tidyverse.org\/\" target=\"_blank\" rel=\"noopener\">dplyr<\/a> di R untuk mengembalikan nilai pertama yang tidak hilang di setiap posisi dari satu atau lebih vektor.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Ada dua cara umum untuk menggunakan fungsi ini:<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Ganti nilai yang hilang dalam vektor<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008000;\">library<\/span> (dplyr)<\/span>\n\n#replace missing values with 100\n<\/span>coalescence(x, 100)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Kembalikan nilai pertama yang tidak hilang di kolom bingkai data<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008000;\">library<\/span> (dplyr)<\/span>\n\n#return first non-missing value at each position across columns A and B<\/span>\ncoalesce(df$A, df$B)<\/strong>\n<\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan bagaimana menerapkan setiap metode dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Gunakan coalesce() untuk mengganti nilai yang hilang pada vektor<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara menggunakan fungsi <strong>coalesce()<\/strong> untuk mengganti semua nilai yang hilang dalam vektor dengan nilai 100:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008000;\">library<\/span> (dplyr)<\/span>\n\n#create vector of values\n<\/span>x &lt;- c(4, NA, 12, NA, 5, 14, 19)\n\n<span style=\"color: #008080;\">#replace missing values with 100\n<\/span>coalescence(x, 100)\n\n[1] 4 100 12 100 5 14 19\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa setiap nilai <strong>NA<\/strong> pada vektor asli telah diganti dengan nilai <strong>100<\/strong> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2:<\/strong><\/span> <span style=\"color: #000000;\"><strong>Gunakan coalesce() untuk mengembalikan nilai pertama yang tidak hilang di kolom bingkai data<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki bingkai data berikut di R:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008080;\">#create data frame\n<span style=\"color: #000000;\">df &lt;- data. <span style=\"color: #3366ff;\">frame<\/span> (A=c(10, NA, 5, 6, NA, 7, NA),\n                 B=c(14, 9, NA, 3, NA, 10, 4))<\/span>\n\n#view data frame\n<span style=\"color: #000000;\">df\n\n   AB\n1 10 14\n2 NA 9\n3 5 NA\n4 6 3\n5 NA NA\n6 7 10\n7 NA 4\n<\/span><\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara menggunakan fungsi <strong>coalesce()<\/strong> untuk mengembalikan nilai pertama yang tidak hilang di kolom A dan B bingkai data:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">library<\/span> (dplyr)\n\n<span style=\"color: #008080;\">#create new column that coalesces values from columns A and B\n<span style=\"color: #000000;\">df$C &lt;- coalesce(df$A, df$B)\n<\/span>\n#view updated data frame\n<span style=\"color: #000000;\">df\n\n   ABC\n1 10 14 10\n2 NA 9 9\n3 5 NA 5\n4 6 3 6\n5 NA NA NA\n6 7 10 7\n7 NA 4 4<\/span><\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Kolom C yang dihasilkan berisi nilai pertama yang tidak hilang di kolom A dan B.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Perhatikan bahwa baris 5 memiliki nilai NA di kolom C karena kolom A dan B sama-sama memiliki nilai NA di baris ini.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita cukup menambahkan nilai ekstra ke fungsi <strong>coalesce()<\/strong> untuk digunakan sebagai nilai jika ada nilai NA di setiap kolom:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">library<\/span> (dplyr)\n\n<span style=\"color: #008080;\">#create new column that coalesces values from columns A and B\n<span style=\"color: #000000;\">df$C &lt;- coalesce(df$A, df$B, 100)\n<\/span>\n#view updated data frame\n<span style=\"color: #000000;\">df\n\n   ABC\n1 10 14 10\n2 NA 9 9\n3 5 NA 5\n4 6 3 6\n5 NA NA 100\n6 7 10 7\n7 NA 4 4\n<\/span><\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa nilai NA pada baris 5 kolom C kini telah diganti dengan nilai <strong>100<\/strong> .<\/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 menjalankan fungsi umum lainnya menggunakan dplyr:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/dplyr-menghapus-baris\/\" target=\"_blank\" rel=\"noopener\">Cara menghapus baris menggunakan dplyr<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/mengatur-garis-r\/\" target=\"_blank\" rel=\"noopener\">Cara menyusun baris menggunakan dplyr<\/a><br \/> Cara memfilter berdasarkan beberapa kondisi menggunakan dplyr<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan fungsi coalesce() dari paket dplyr di R untuk mengembalikan nilai pertama yang tidak hilang di setiap posisi dari satu atau lebih vektor. Ada dua cara umum untuk menggunakan fungsi ini: Metode 1: Ganti nilai yang hilang dalam vektor library (dplyr) #replace missing values with 100 coalescence(x, 100) Metode 2: Kembalikan nilai pertama [&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>Cara menggunakan fungsi coalesce() di dplyr (dengan contoh) \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi coalesce() di dplyr 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\/penggabungan-dplyr\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menggunakan fungsi coalesce() di dplyr (dengan contoh) \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi coalesce() di dplyr di R, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/penggabungan-dplyr\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T07:15:39+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\/penggabungan-dplyr\/\",\"url\":\"https:\/\/statorials.org\/id\/penggabungan-dplyr\/\",\"name\":\"Cara menggunakan fungsi coalesce() di dplyr (dengan contoh) \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T07:15:39+00:00\",\"dateModified\":\"2023-07-17T07:15:39+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi coalesce() di dplyr di R, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/penggabungan-dplyr\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/penggabungan-dplyr\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/penggabungan-dplyr\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggunakan fungsi coalesce() di dplyr (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 menggunakan fungsi coalesce() di dplyr (dengan contoh) \u2013 Statorials","description":"Tutorial ini menjelaskan cara menggunakan fungsi coalesce() di dplyr 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\/penggabungan-dplyr\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menggunakan fungsi coalesce() di dplyr (dengan contoh) \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi coalesce() di dplyr di R, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/penggabungan-dplyr\/","og_site_name":"Statorials","article_published_time":"2023-07-17T07:15:39+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\/penggabungan-dplyr\/","url":"https:\/\/statorials.org\/id\/penggabungan-dplyr\/","name":"Cara menggunakan fungsi coalesce() di dplyr (dengan contoh) \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T07:15:39+00:00","dateModified":"2023-07-17T07:15:39+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi coalesce() di dplyr di R, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/penggabungan-dplyr\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/penggabungan-dplyr\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/penggabungan-dplyr\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggunakan fungsi coalesce() di dplyr (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\/3475"}],"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=3475"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3475\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3475"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3475"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3475"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}