{"id":2868,"date":"2023-07-20T08:15:14","date_gmt":"2023-07-20T08:15:14","guid":{"rendered":"https:\/\/statorials.org\/id\/jumlah-kumulatif-panda-per-grup\/"},"modified":"2023-07-20T08:15:14","modified_gmt":"2023-07-20T08:15:14","slug":"jumlah-kumulatif-panda-per-grup","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/jumlah-kumulatif-panda-per-grup\/","title":{"rendered":"Pandas: cara menghitung jumlah kumulatif per kelompok"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk menghitung jumlah kumulatif per grup di panda:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df[' <span style=\"color: #ff0000;\">cumsum_col<\/span> '] = df. <span style=\"color: #3366ff;\">groupby<\/span> ([' <span style=\"color: #ff0000;\">col1<\/span> '])[' <span style=\"color: #ff0000;\">col2<\/span> ']. <span style=\"color: #3366ff;\">cumsum<\/span> ()\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini menghitung jumlah kumulatif <strong>col2<\/strong> , dikelompokkan berdasarkan <strong>col1<\/strong> , dan menampilkan hasilnya di kolom baru berjudul <strong>cumsum_col<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: hitung jumlah kumulatif per grup di Pandas<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki pandas DataFrame berikut yang berisi informasi penjualan untuk berbagai toko:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">import<\/span> pandas <span style=\"color: #008000;\">as<\/span> pd\n\n<span style=\"color: #008080;\">#createDataFrame<\/span>\ndf = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">store<\/span> ': ['A', 'A', 'A', 'A', 'A', 'B', 'B', 'B', 'B', 'B'],\n                   ' <span style=\"color: #ff0000;\">sales<\/span> ': [4, 7, 10, 5, 8, 9, 12, 15, 10, 8]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n  blind sales\n0 to 4\n1 to 7\n2 to 10\n3 to 5\n4 to 8\n5 B 9\n6 B 12\n7 B 15\n8 B 10\n9 B 8<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk menghitung jumlah kumulatif penjualan untuk setiap toko:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008080;\">#add column that shows cumulative sum of sales by store\n<span style=\"color: #000000;\">df[' <span style=\"color: #ff0000;\">cumsum_sales<\/span> '] = df. <span style=\"color: #3366ff;\">groupby<\/span> ([' <span style=\"color: #ff0000;\">store<\/span> '])[' <span style=\"color: #ff0000;\">sales<\/span> ']. <span style=\"color: #3366ff;\">cumsum<\/span> ()\n<\/span>\n<span style=\"color: #008080;\">#view updated DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> <span style=\"color: #000000;\">(df)\n\n  store sales cumsum_sales\n0 to 4 4\n1 to 7 11\n2 to 10 21\n3 to 5 26\n4 to 8 34\n5 B 9 9\n6 B 12 21\n7 B 15 36\n8 B 10 46\n9 B 8 54\n<\/span><\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kolom <strong>cumsum_sales<\/strong> menampilkan penjualan kumulatif yang dikelompokkan berdasarkan masing-masing toko.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi <b>cumsum<\/b> di pandas <a href=\"https:\/\/pandas.pydata.org\/docs\/reference\/api\/pandas.DataFrame.cumsum.html\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di panda:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/kolom-jumlah-spesifik-panda\/\" target=\"_blank\" rel=\"noopener\">Cara menjumlahkan kolom tertentu di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kolom-jumlah-panda-dengan-syarat\/\" target=\"_blank\" rel=\"noopener\">Cara menjumlahkan kolom berdasarkan kondisi di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-membalikkan-cumsum\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung jumlah kumulatif terbalik di panda<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk menghitung jumlah kumulatif per grup di panda: df[&#8216; cumsum_col &#8216;] = df. groupby ([&#8216; col1 &#8216;])[&#8216; col2 &#8216;]. cumsum () Rumus khusus ini menghitung jumlah kumulatif col2 , dikelompokkan berdasarkan col1 , dan menampilkan hasilnya di kolom baru berjudul cumsum_col . Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam [&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>Pandas: Cara menghitung jumlah kumulatif per grup - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah kumulatif per kelompok di antara panda, dengan 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\/jumlah-kumulatif-panda-per-grup\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara menghitung jumlah kumulatif per grup - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah kumulatif per kelompok di antara panda, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/jumlah-kumulatif-panda-per-grup\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T08:15:14+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-kumulatif-panda-per-grup\/\",\"url\":\"https:\/\/statorials.org\/id\/jumlah-kumulatif-panda-per-grup\/\",\"name\":\"Pandas: Cara menghitung jumlah kumulatif per grup - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T08:15:14+00:00\",\"dateModified\":\"2023-07-20T08:15:14+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung jumlah kumulatif per kelompok di antara panda, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/jumlah-kumulatif-panda-per-grup\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/jumlah-kumulatif-panda-per-grup\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/jumlah-kumulatif-panda-per-grup\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara menghitung jumlah kumulatif per kelompok\"}]},{\"@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":"Pandas: Cara menghitung jumlah kumulatif per grup - Statorials","description":"Tutorial ini menjelaskan cara menghitung jumlah kumulatif per kelompok di antara panda, dengan 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\/jumlah-kumulatif-panda-per-grup\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara menghitung jumlah kumulatif per grup - Statorials","og_description":"Tutorial ini menjelaskan cara menghitung jumlah kumulatif per kelompok di antara panda, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/jumlah-kumulatif-panda-per-grup\/","og_site_name":"Statorials","article_published_time":"2023-07-20T08:15:14+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-kumulatif-panda-per-grup\/","url":"https:\/\/statorials.org\/id\/jumlah-kumulatif-panda-per-grup\/","name":"Pandas: Cara menghitung jumlah kumulatif per grup - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T08:15:14+00:00","dateModified":"2023-07-20T08:15:14+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung jumlah kumulatif per kelompok di antara panda, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/jumlah-kumulatif-panda-per-grup\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/jumlah-kumulatif-panda-per-grup\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/jumlah-kumulatif-panda-per-grup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara menghitung jumlah kumulatif per kelompok"}]},{"@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\/2868"}],"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=2868"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2868\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2868"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2868"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2868"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}