{"id":3283,"date":"2023-07-18T07:27:42","date_gmt":"2023-07-18T07:27:42","guid":{"rendered":"https:\/\/statorials.org\/id\/jumlah-dplyr-pada-beberapa-kolom\/"},"modified":"2023-07-18T07:27:42","modified_gmt":"2023-07-18T07:27:42","slug":"jumlah-dplyr-pada-beberapa-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/jumlah-dplyr-pada-beberapa-kolom\/","title":{"rendered":"Cara menjumlahkan beberapa kolom menggunakan dplyr"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan metode berikut untuk menjumlahkan nilai beberapa kolom dalam bingkai data menggunakan dplyr:<\/span><\/p>\n

Metode 1: Jumlahkan semua kolom<\/strong><\/span><\/p>\n

 df %>%\n  mutate(sum = rowSums(., na. rm<\/span> = TRUE<\/span> ))\n<\/strong><\/pre>\n
 Metode 2: Jumlahkan semua kolom numerik<\/strong><\/span><\/p>\n
 df %>%\n  mutate(sum = rowSums(across(where(is. numeric<\/span> )), na. rm<\/span> = TRUE<\/span> ))\n<\/strong><\/pre>\n
 Metode 3: Jumlahkan kolom tertentu<\/strong><\/span><\/p>\n
 df %>%\n  mutate(sum = rowSums(across(c(col1, col2))))\n<\/strong><\/pre>\n
 Contoh berikut menunjukkan cara menggunakan masing-masing metode dengan kerangka data berikut yang berisi informasi tentang poin yang dicetak oleh pemain bola basket berbeda dalam permainan berbeda:<\/span><\/p>\n
 #create data frame\n<\/span>df <- data. frame<\/span> (game1=c(22, 25, 29, 13, 22, 30),\n                 game2=c(12, 10, 6, 6, 8, 11),\n                 game3=c(NA, 15, 15, 18, 22, 13))\n\n#view data frame\n<\/span>df\n\n  game1 game2 game3\n1 22 12 NA\n2 25 10 15\n3 29 6 15\n4 13 6 18\n5 22 8 22\n6 30 11 13\n<\/strong><\/pre>\n
 Contoh 1: menjumlahkan semua kolom<\/strong><\/span><\/h2>\n
 Kode berikut menunjukkan cara menghitung jumlah nilai semua kolom dalam bingkai data:<\/span><\/p>\n
 library<\/span> (dplyr)\n\n#sum values across all columns\ndf %>%\n  mutate(total_points = rowSums(., na. rm<\/span> = TRUE<\/span> ))<\/span>\n\n<\/span>game1 game2 game3 total_points\n1 22 12 NA 34\n2 25 10 15 50\n3 29 6 15 50\n4 13 6 18 37\n5 22 8 22 52\n6 30 11 13 54\n<\/strong><\/span><\/pre>\n
 Contoh 2: Jumlahkan semua kolom numerik<\/strong><\/span><\/h2>\n
 Kode berikut menunjukkan cara menghitung jumlah nilai semua kolom numerik dalam bingkai data:<\/span><\/p>\n
 library<\/span> (dplyr)<\/span>\n\n#sum values across all numeric columns\n<\/span>df %>%\n  mutate(total_points = rowSums(across(where(is. numeric<\/span> )), na. rm<\/span> = TRUE<\/span> ))\n<\/span>\n<\/span>game1 game2 game3 total_points\n1 22 12 NA 34\n2 25 10 15 50\n3 29 6 15 50\n4 13 6 18 37\n5 22 8 22 52\n6 30 11 13 54<\/strong><\/pre>\n
 Contoh 3: Jumlahkan kolom tertentu<\/strong><\/span><\/h2>\n
 Kode berikut menunjukkan cara menghitung jumlah nilai pada kolom game1<\/strong> dan game2<\/strong> saja:<\/span><\/p>\n
 library<\/span> (dplyr)<\/span>\n\n#sum values across game1 and game2 only\n<\/span>df %>%\n  mutate(first2_sum = rowSums(across(c(game1, game2))))\n\n  game1 game2 game3 first2_sum\n1 22 12 NA 34\n2 25 10 15 35\n3 29 6 15 35\n4 13 6 18 19\n5 22 8 22 30\n6 30 11 13 41\n<\/strong><\/pre>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya menggunakan dplyr:<\/span><\/p>\n
 Cara menghapus baris menggunakan dplyr<\/a>
 Cara menyusun baris menggunakan dplyr<\/a>
 Cara memfilter berdasarkan beberapa kondisi menggunakan dplyr<\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan metode berikut untuk menjumlahkan nilai beberapa kolom dalam bingkai data menggunakan dplyr: Metode 1: Jumlahkan semua kolom df %>% mutate(sum = rowSums(., na. rm = TRUE )) Metode 2: Jumlahkan semua kolom numerik df %>% mutate(sum = rowSums(across(where(is. numeric )), na. rm = TRUE )) Metode 3: Jumlahkan kolom tertentu df %>% […]<\/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 menjumlahkan beberapa kolom menggunakan dplyr - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menambahkan beberapa kolom pada frame data menggunakan dplyr, termasuk contohnya.\" \/>\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\/jumlah-dplyr-pada-beberapa-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menjumlahkan beberapa kolom menggunakan dplyr - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menambahkan beberapa kolom pada frame data menggunakan dplyr, termasuk contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/jumlah-dplyr-pada-beberapa-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T07:27:42+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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/jumlah-dplyr-pada-beberapa-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/jumlah-dplyr-pada-beberapa-kolom\/\",\"name\":\"Cara menjumlahkan beberapa kolom menggunakan dplyr - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-18T07:27:42+00:00\",\"dateModified\":\"2023-07-18T07:27:42+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menambahkan beberapa kolom pada frame data menggunakan dplyr, termasuk contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/jumlah-dplyr-pada-beberapa-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/jumlah-dplyr-pada-beberapa-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/jumlah-dplyr-pada-beberapa-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menjumlahkan 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 menjumlahkan beberapa kolom menggunakan dplyr - Statorials","description":"Tutorial ini menjelaskan cara menambahkan beberapa kolom pada frame data menggunakan dplyr, termasuk contohnya.","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\/jumlah-dplyr-pada-beberapa-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menjumlahkan beberapa kolom menggunakan dplyr - Statorials","og_description":"Tutorial ini menjelaskan cara menambahkan beberapa kolom pada frame data menggunakan dplyr, termasuk contohnya.","og_url":"https:\/\/statorials.org\/id\/jumlah-dplyr-pada-beberapa-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-18T07:27:42+00:00","author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/jumlah-dplyr-pada-beberapa-kolom\/","url":"https:\/\/statorials.org\/id\/jumlah-dplyr-pada-beberapa-kolom\/","name":"Cara menjumlahkan beberapa kolom menggunakan dplyr - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-18T07:27:42+00:00","dateModified":"2023-07-18T07:27:42+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menambahkan beberapa kolom pada frame data menggunakan dplyr, termasuk contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/jumlah-dplyr-pada-beberapa-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/jumlah-dplyr-pada-beberapa-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/jumlah-dplyr-pada-beberapa-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menjumlahkan 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\/3283"}],"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=3283"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3283\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3283"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3283"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3283"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}