{"id":4249,"date":"2023-07-12T13:03:26","date_gmt":"2023-07-12T13:03:26","guid":{"rendered":"https:\/\/statorials.org\/id\/persentase-tabel-pivot-panda\/"},"modified":"2023-07-12T13:03:26","modified_gmt":"2023-07-12T13:03:26","slug":"persentase-tabel-pivot-panda","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/persentase-tabel-pivot-panda\/","title":{"rendered":"Pandas: cara membuat pivottable dengan persentase"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk menambahkan kolom ke tabel pivot di panda yang menampilkan persentase total untuk kolom tertentu:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>my_table[' <span style=\"color: #ff0000;\">% points<\/span> '] = (my_table[' <span style=\"color: #ff0000;\">points<\/span> ']\/my_table[' <span style=\"color: #ff0000;\">points<\/span> ']. <span style=\"color: #3366ff;\">sum<\/span> ())* <span style=\"color: #008000;\">100\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Sintaks khusus ini menambahkan kolom baru bernama <strong>% poin<\/strong> ke tabel pivot bernama <strong>my_table<\/strong> yang menampilkan persentase nilai total di kolom <strong>poin<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Membuat PivotTable Pandas dengan Persentase<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki panda DataFrame berikut yang menunjukkan jumlah poin yang dicetak oleh pemain bola basket yang berbeda:<\/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;\">team<\/span> ': ['A', 'A', 'A', 'A', 'B', 'B', 'B', 'B'],\n                   ' <span style=\"color: #ff0000;\">position<\/span> ': ['Guard', 'Guard', 'Forward', 'Forward',\n                                'Guard', 'Guard', 'Forward', 'Forward'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [22, 30, 14, 15, 19, 30, 23, 20]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n  team position points\n0 A Guard 22\n1A Guard 30\n2 A Forward 14\n3 A Forward 15\n4 B Guard 19\n5 B Guard 30\n6 B Forward 23\n7 B Forward 20\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan fungsi <strong>pivot_table()<\/strong> untuk membuat tabel pivot yang menunjukkan jumlah poin berdasarkan tim dan posisi:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#create pivot table to calculate sum of points by team and position\n<\/span>my_table = pd. <span style=\"color: #3366ff;\">pivot_table<\/span> (df, index=[' <span style=\"color: #ff0000;\">team<\/span> ', ' <span style=\"color: #ff0000;\">position<\/span> '], 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\n               points\nteam position        \nA Forward 29\n     Guard 52\nB Forward 43\n     Guard 49\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Penyerang Tim A mencetak total <b>29<\/b> poin.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Penjaga Tim A mencetak total <b>52<\/b> poin.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Penyerang Tim B mencetak total <b>43<\/b> poin.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Penjaga Tim B mencetak total <b>49<\/b> poin.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kita kemudian dapat menggunakan sintaks berikut untuk menambahkan kolom baru bernama <strong>% poin<\/strong> yang menampilkan persentase total poin untuk setiap baris:<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#add column that displays points as a percentage of total points<\/span>\nmy_table[' <span style=\"color: #ff0000;\">% points<\/span> '] = (my_table[' <span style=\"color: #ff0000;\">points<\/span> ']\/my_table[' <span style=\"color: #ff0000;\">points<\/span> ']. <span style=\"color: #3366ff;\">sum<\/span> ())* <span style=\"color: #008000;\">100\n\n<span style=\"color: #000000;\"><span style=\"color: #008080;\">#view updated pivot table\n<\/span><span style=\"color: #008000;\">print<\/span> (my_table)\n\n               points % points\nteam position                   \nA Forward 29 16.763006\n     Guard 52 30.057803\nB Forward 43 24.855491\n     Guard 49 28.323699<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kolom <strong>% Poin<\/strong> baru sekarang menampilkan nilai poin sebagai persentase dari total poin.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan juga bahwa Anda dapat menggunakan fungsi <strong>round()<\/strong> untuk membulatkan nilai persentase ke sejumlah tempat desimal tertentu.<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#add column that displays points as a percentage of total points (rounded)<\/span>\nmy_table[' <span style=\"color: #ff0000;\">% points<\/span> '] = <span style=\"color: #008000;\">round<\/span> ((my_table[' <span style=\"color: #ff0000;\">points<\/span> ']\/my_table[' <span style=\"color: #ff0000;\">points<\/span> ']. <span style=\"color: #3366ff;\">sum<\/span> ())* <span style=\"color: #008000;\">100 <span style=\"color: #000000;\">, <span style=\"color: #008000;\">2<\/span> )<\/span>\n\n<span style=\"color: #000000;\"><span style=\"color: #008080;\">#view updated pivot table\n<\/span><span style=\"color: #008000;\">print<\/span> (my_table)\n\n               points % points\nteam position                  \nA Forward 29 16.76\n     Guard 52 30.06\nB Forward 43 24.86\n     Guard 49 28.32\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Nilai persentase kini dibulatkan menjadi dua tempat desimal.<\/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\/filter-tabel-pivot-panda\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara menambahkan filter ke tabel pivot<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/mantra-tabel-pivot-panda\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara mengurutkan tabel pivot berdasarkan nilai di kolom<\/a><br \/> Pandas: Cara membuat tabel pivot dengan jumlah nilai<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk menambahkan kolom ke tabel pivot di panda yang menampilkan persentase total untuk kolom tertentu: my_table[&#8216; % points &#8216;] = (my_table[&#8216; points &#8216;]\/my_table[&#8216; points &#8216;]. sum ())* 100 Sintaks khusus ini menambahkan kolom baru bernama % poin ke tabel pivot bernama my_table yang menampilkan persentase nilai total di kolom poin [&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 Membuat PivotTable dengan Persentase - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat tabel pivot di Pandas dengan persentase, 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\/persentase-tabel-pivot-panda\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara Membuat PivotTable dengan Persentase - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat tabel pivot di Pandas dengan persentase, termasuk contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/persentase-tabel-pivot-panda\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-12T13:03:26+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\/persentase-tabel-pivot-panda\/\",\"url\":\"https:\/\/statorials.org\/id\/persentase-tabel-pivot-panda\/\",\"name\":\"Pandas: Cara Membuat PivotTable dengan Persentase - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-12T13:03:26+00:00\",\"dateModified\":\"2023-07-12T13:03:26+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat tabel pivot di Pandas dengan persentase, termasuk contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/persentase-tabel-pivot-panda\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/persentase-tabel-pivot-panda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/persentase-tabel-pivot-panda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara membuat pivottable dengan persentase\"}]},{\"@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 Membuat PivotTable dengan Persentase - Statorial","description":"Tutorial ini menjelaskan cara membuat tabel pivot di Pandas dengan persentase, 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\/persentase-tabel-pivot-panda\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara Membuat PivotTable dengan Persentase - Statorial","og_description":"Tutorial ini menjelaskan cara membuat tabel pivot di Pandas dengan persentase, termasuk contohnya.","og_url":"https:\/\/statorials.org\/id\/persentase-tabel-pivot-panda\/","og_site_name":"Statorials","article_published_time":"2023-07-12T13:03:26+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\/persentase-tabel-pivot-panda\/","url":"https:\/\/statorials.org\/id\/persentase-tabel-pivot-panda\/","name":"Pandas: Cara Membuat PivotTable dengan Persentase - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-12T13:03:26+00:00","dateModified":"2023-07-12T13:03:26+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat tabel pivot di Pandas dengan persentase, termasuk contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/persentase-tabel-pivot-panda\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/persentase-tabel-pivot-panda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/persentase-tabel-pivot-panda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara membuat pivottable dengan persentase"}]},{"@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\/4249"}],"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=4249"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4249\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4249"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4249"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4249"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}