{"id":3276,"date":"2023-07-18T08:17:47","date_gmt":"2023-07-18T08:17:47","guid":{"rendered":"https:\/\/statorials.org\/id\/tabel-pivot-panda-di-bawah-total\/"},"modified":"2023-07-18T08:17:47","modified_gmt":"2023-07-18T08:17:47","slug":"tabel-pivot-panda-di-bawah-total","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tabel-pivot-panda-di-bawah-total\/","title":{"rendered":"Pandas: cara menambahkan subtotal ke tabel pivot"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin menambahkan subtotal ke tabel pivot pandas.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini mudah dilakukan menggunakan fungsi bawaan panda.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara melakukan hal ini.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Tambahkan Subtotal ke PivotTable Pandas<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki pandas DataFrame berikut yang berisi informasi tentang berbagai pemain bola basket:<\/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\n<\/span>df = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">team<\/span> ': ['A', 'A', 'A', 'A', 'B', 'B', 'B', 'B'],\n                   ' <span style=\"color: #ff0000;\">position<\/span> ': ['G', 'G', 'F', 'F', 'G', 'F', 'F', 'F'],\n                   ' <span style=\"color: #ff0000;\">all_star<\/span> ': ['Y', 'N', 'Y', 'Y', 'N', 'N', 'N', 'Y'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [4, 4, 6, 8, 9, 5, 5, 12]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n  team position all_star points\n0 AGY 4\n1 AGN 4\n2 AFY 6\n3 AFY 8\n4 BGN 9\n5 BFN 5\n6 BFN 5\n7 BFY 12<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk membuat tabel pivot di panda yang menampilkan jumlah <strong>poin<\/strong> untuk setiap kombinasi <strong>team<\/strong> , <strong>all_star<\/strong> dan <strong>position<\/strong> di DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#create pivot table\n<span style=\"color: #000000;\">my_table = pd. <span style=\"color: #3366ff;\">pivot_table<\/span> (df, values=' <span style=\"color: #ff0000;\">points<\/span> ',\n                              index=[' <span style=\"color: #ff0000;\">team<\/span> ', ' <span style=\"color: #ff0000;\">all_star<\/span> '],\n                              columns=' <span style=\"color: #ff0000;\">position<\/span> ',\n                              aggfunc=' <span style=\"color: #ff0000;\">sum<\/span> ')\n\n<span style=\"color: #008080;\">#view pivot table\n<\/span><span style=\"color: #008000;\">print<\/span> (my_table)\n\nFG position\nteam all_star           \nAN NaN 4.0\n     Y 14.0 4.0\nBN 10.0 9.0\n     Y 12.0 NaN<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Sekarang katakanlah kita ingin menambahkan baris <strong>subtotal<\/strong> yang menampilkan poin subtotal untuk setiap tim dan posisi.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#add subtotals row to pivot table\n<\/span>p.d. <span style=\"color: #3366ff;\">concat<\/span> ([\n    y. <span style=\"color: #3366ff;\">append<\/span> ( <span style=\"color: #3366ff;\">y.sum<\/span> (). <span style=\"color: #3366ff;\">rename<\/span> ((x, ' <span style=\"color: #ff0000;\">Total<\/span> ')))\n    <span style=\"color: #008000;\">for<\/span> x, y <span style=\"color: #008000;\">in<\/span> my_table. <span style=\"color: #3366ff;\">groupby<\/span> (level= <span style=\"color: #008000;\">0<\/span> )\n]). <span style=\"color: #3366ff;\">append<\/span> ( <span style=\"color: #3366ff;\">my_table.sum<\/span> (). <span style=\"color: #3366ff;\">rename<\/span> ((' <span style=\"color: #ff0000;\">Large<\/span> ', ' <span style=\"color: #ff0000;\">Total<\/span> ')))\n\n\tposition F G\nteam all_star\t\t\nA N NaN 4.0\n               Y 7.0 4.0\n           Overall 7.0 8.0\nB N 5.0 9.0\n               Y 12.0 NaN\n           Total 17.0 9.0\nGrand Total 24.0 17.0\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kami sekarang memiliki dua baris subtotal yang menunjukkan poin subtotal untuk setiap tim dan posisi, serta baris total keseluruhan yang menunjukkan total keseluruhan untuk setiap kolom.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi pandas <strong>pivot_table()<\/strong> <a href=\"https:\/\/pandas.pydata.org\/docs\/reference\/api\/pandas.pivot_table.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 panda:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/jumlah-tabel-pivot-panda\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara membuat tabel pivot dengan sejumlah nilai<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tabel-pivot-panda-ganti-nan-dengan-0\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara mengganti nilai NaN di tabel pivot dengan nol<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tabel-pivot-pandas-ke-kerangka-data\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara mengonversi PivotTable ke DataFrame<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin menambahkan subtotal ke tabel pivot pandas. Untungnya, hal ini mudah dilakukan menggunakan fungsi bawaan panda. Contoh berikut menunjukkan cara melakukan hal ini. Contoh: Tambahkan Subtotal ke PivotTable Pandas Misalkan kita memiliki pandas DataFrame berikut yang berisi informasi tentang berbagai pemain bola basket: import pandas as pd #createDataFrame df = pd. DataFrame [&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 menambahkan subtotal ke tabel pivot - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menambahkan subtotal ke tabel pivot pandas, 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\/tabel-pivot-panda-di-bawah-total\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara menambahkan subtotal ke tabel pivot - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menambahkan subtotal ke tabel pivot pandas, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tabel-pivot-panda-di-bawah-total\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T08:17:47+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\/tabel-pivot-panda-di-bawah-total\/\",\"url\":\"https:\/\/statorials.org\/id\/tabel-pivot-panda-di-bawah-total\/\",\"name\":\"Pandas: Cara menambahkan subtotal ke tabel pivot - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-18T08:17:47+00:00\",\"dateModified\":\"2023-07-18T08:17:47+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menambahkan subtotal ke tabel pivot pandas, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tabel-pivot-panda-di-bawah-total\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tabel-pivot-panda-di-bawah-total\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tabel-pivot-panda-di-bawah-total\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara menambahkan subtotal ke tabel pivot\"}]},{\"@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 menambahkan subtotal ke tabel pivot - Statorial","description":"Tutorial ini menjelaskan cara menambahkan subtotal ke tabel pivot pandas, 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\/tabel-pivot-panda-di-bawah-total\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara menambahkan subtotal ke tabel pivot - Statorial","og_description":"Tutorial ini menjelaskan cara menambahkan subtotal ke tabel pivot pandas, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/tabel-pivot-panda-di-bawah-total\/","og_site_name":"Statorials","article_published_time":"2023-07-18T08:17:47+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\/tabel-pivot-panda-di-bawah-total\/","url":"https:\/\/statorials.org\/id\/tabel-pivot-panda-di-bawah-total\/","name":"Pandas: Cara menambahkan subtotal ke tabel pivot - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-18T08:17:47+00:00","dateModified":"2023-07-18T08:17:47+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menambahkan subtotal ke tabel pivot pandas, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tabel-pivot-panda-di-bawah-total\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tabel-pivot-panda-di-bawah-total\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tabel-pivot-panda-di-bawah-total\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara menambahkan subtotal ke tabel pivot"}]},{"@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\/3276"}],"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=3276"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3276\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3276"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3276"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3276"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}