{"id":3285,"date":"2023-07-18T07:13:50","date_gmt":"2023-07-18T07:13:50","guid":{"rendered":"https:\/\/statorials.org\/id\/dplyr-meringkas-beberapa-kolom\/"},"modified":"2023-07-18T07:13:50","modified_gmt":"2023-07-18T07:13:50","slug":"dplyr-meringkas-beberapa-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/dplyr-meringkas-beberapa-kolom\/","title":{"rendered":"Cara meringkas beberapa kolom menggunakan dplyr"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut untuk meringkas beberapa kolom dalam bingkai data menggunakan dplyr:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Ringkas semua kolom<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#summarize mean of all columns<\/span>\ndf %&gt;%\n  group_by(group_var) %&gt;%\n  summarise(across(everything(), mean, na. <span style=\"color: #3366ff;\">rm<\/span> = <span style=\"color: #008000;\">TRUE<\/span> ))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Ringkas Kolom Tertentu<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#summarize mean of col1 and col2 only<\/span>\ndf %&gt;%\n  group_by(group_var) %&gt;%\n  summarise(across(c(col1, col2), mean, na. <span style=\"color: #3366ff;\">rm<\/span> = <span style=\"color: #008000;\">TRUE<\/span> ))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 3: Ringkas Semua Kolom Numerik<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#summarize mean and standard deviation of all numeric columns\n<\/span>df %&gt;%\n  group_by(group_var) %&gt;%\n  summarise(across(where(is. <span style=\"color: #3366ff;\">numeric<\/span> ), list(mean=mean, sd=sd), na. <span style=\"color: #3366ff;\">rm<\/span> = <span style=\"color: #008000;\">TRUE<\/span> ))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap metode dengan kerangka data berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#create data frame\n<\/span>df &lt;- data. <span style=\"color: #3366ff;\">frame<\/span> (team=c('A', 'A', 'A', 'B', 'B', 'B'),\n                 points=c(99, 90, 86, 88, 95, 90),\n                 assists=c(33, 28, 31, 39, 34, 25),\n                 rebounds=c(NA, 28, 24, 24, 28, 19))\n\n<span style=\"color: #008080;\">#view data frame\n<\/span>df\n\n  team points assists rebounds\n1 A 99 33 NA\n2 A 90 28 28\n3 A 86 31 24\n4 B 88 39 24\n5 B 95 34 28\n6 B 90 25 19\n<\/strong><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Ringkas semua kolom<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara merangkum rata-rata semua kolom:<\/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#summarize mean of all columns, grouped by team<\/span>\ndf %&gt;%\n  group_by(team) %&gt;%\n  summarise(across(everything(), mean, na. <span style=\"color: #3366ff;\">rm<\/span> = <span style=\"color: #008000;\">TRUE<\/span> ))\n\n# A tibble: 2 x 4\n  team points assists rebounds\n           \n1 A 91.7 30.7 26  \n2 B 91 32.7 23.7\n<\/strong><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Ringkas kolom tertentu<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara merangkum rata-rata kolom <strong>poin<\/strong> dan <strong>rebound<\/strong> saja:<\/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#summarize mean of points and rebounds, grouped by team<\/span>\ndf %&gt;%\n  group_by(team) %&gt;%\n  summarise(across(c(points, rebounds), mean, na. <span style=\"color: #3366ff;\">rm<\/span> = <span style=\"color: #008000;\">TRUE<\/span> ))\n\n# A tibble: 2 x 3\n  team points rebounds\n        \n1 A 91.7 26  \n2 B 91 23.7<\/strong><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 3: Ringkaslah semua kolom numerik<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara merangkum mean dan deviasi standar semua kolom numerik dalam bingkai data:<\/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#summarize mean and standard deviation of all numeric columns<\/span>\ndf %&gt;%\n  group_by(team) %&gt;%\n  summarise(across(where(is. <span style=\"color: #3366ff;\">numeric<\/span> ), list(mean=mean, sd=sd), na. <span style=\"color: #3366ff;\">rm<\/span> = <span style=\"color: #008000;\">TRUE<\/span> ))\n\n# A tibble: 2 x 7\n  team points_mean points_sd assists_mean assists_sd rebounds_mean rebounds_sd\n                                            \n1 A 91.7 6.66 30.7 2.52 26 2.83\n2 B 91 3.61 32.7 7.09 23.7 4.51<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Outputnya menampilkan mean dan deviasi standar semua variabel numerik dalam bingkai data.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa dalam contoh ini kami menggunakan fungsi <strong>list()<\/strong> untuk mencantumkan beberapa ringkasan statistik yang ingin kami hitung.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Dalam setiap contoh, kami menggunakan fungsi <strong>dplyrcross()<\/strong> . Anda dapat menemukan dokumentasi lengkap untuk fungsi ini <a href=\"https:\/\/dplyr.tidyverse.org\/reference\/across.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 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 metode berikut untuk meringkas beberapa kolom dalam bingkai data menggunakan dplyr: Metode 1: Ringkas semua kolom #summarize mean of all columns df %&gt;% group_by(group_var) %&gt;% summarise(across(everything(), mean, na. rm = TRUE )) Metode 2: Ringkas Kolom Tertentu #summarize mean of col1 and col2 only df %&gt;% group_by(group_var) %&gt;% summarise(across(c(col1, col2), mean, na. [&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 meringkas beberapa kolom menggunakan dplyr - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara meringkas beberapa kolom dalam bingkai data menggunakan dplyr, 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\/dplyr-meringkas-beberapa-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara meringkas beberapa kolom menggunakan dplyr - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara meringkas beberapa kolom dalam bingkai data menggunakan dplyr, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/dplyr-meringkas-beberapa-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T07:13:50+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-meringkas-beberapa-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/dplyr-meringkas-beberapa-kolom\/\",\"name\":\"Cara meringkas beberapa kolom menggunakan dplyr - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-18T07:13:50+00:00\",\"dateModified\":\"2023-07-18T07:13:50+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara meringkas beberapa kolom dalam bingkai data menggunakan dplyr, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/dplyr-meringkas-beberapa-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/dplyr-meringkas-beberapa-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/dplyr-meringkas-beberapa-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara meringkas beberapa kolom menggunakan dplyr\"}]},{\"@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 meringkas beberapa kolom menggunakan dplyr - Statorials","description":"Tutorial ini menjelaskan cara meringkas beberapa kolom dalam bingkai data menggunakan dplyr, 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\/dplyr-meringkas-beberapa-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"Cara meringkas beberapa kolom menggunakan dplyr - Statorials","og_description":"Tutorial ini menjelaskan cara meringkas beberapa kolom dalam bingkai data menggunakan dplyr, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/dplyr-meringkas-beberapa-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-18T07:13:50+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-meringkas-beberapa-kolom\/","url":"https:\/\/statorials.org\/id\/dplyr-meringkas-beberapa-kolom\/","name":"Cara meringkas beberapa kolom menggunakan dplyr - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-18T07:13:50+00:00","dateModified":"2023-07-18T07:13:50+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara meringkas beberapa kolom dalam bingkai data menggunakan dplyr, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/dplyr-meringkas-beberapa-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/dplyr-meringkas-beberapa-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/dplyr-meringkas-beberapa-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara meringkas beberapa kolom menggunakan dplyr"}]},{"@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\/3285"}],"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=3285"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3285\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3285"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3285"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3285"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}