{"id":2387,"date":"2023-07-22T12:10:44","date_gmt":"2023-07-22T12:10:44","guid":{"rendered":"https:\/\/statorials.org\/id\/jumlah-tabel-pivot-panda\/"},"modified":"2023-07-22T12:10:44","modified_gmt":"2023-07-22T12:10:44","slug":"jumlah-tabel-pivot-panda","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/jumlah-tabel-pivot-panda\/","title":{"rendered":"Pandas: cara membuat tabel pivot dengan sejumlah nilai"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan salah satu metode berikut untuk membuat tabel pivot di panda yang menampilkan jumlah nilai di kolom tertentu:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Tabel Pivot dengan Angka<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>p.d. <span style=\"color: #3366ff;\">pivot_table<\/span> (df, values=' <span style=\"color: #ff0000;\">col1<\/span> ', index=' <span style=\"color: #ff0000;\">col2<\/span> ', columns=' <span style=\"color: #ff0000;\">col3<\/span> ',\n               aggfunc=' <span style=\"color: #ff0000;\">count<\/span> ')\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: PivotTable dengan Angka Unik<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>p.d. <span style=\"color: #3366ff;\">pivot_table<\/span> (df, values=' <span style=\"color: #ff0000;\">col1<\/span> ', index=' <span style=\"color: #ff0000;\">col2<\/span> ', columns=' <span style=\"color: #ff0000;\">col3<\/span> ',\n               aggfunc=pd. <span style=\"color: #3366ff;\">Series<\/span> . <span style=\"color: #3366ff;\">nunique<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap metode dengan pandas DataFrame berikut:<\/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', 'C', 'G', 'F', 'F', 'F'],\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>df\n\n\tteam position points\n0 A G 4\n1 A G 4\n2 A F 6\n3 A C 8\n4 B G 9\n5 B F 5\n6 B F 5\n7 B F 12<\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Metode 1: Buat PivotTable Pandas dengan Hitungan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara membuat tabel pivot di panda yang menampilkan jumlah total nilai &#8220;titik&#8221; untuk setiap &#8220;tim&#8221; dan &#8220;posisi&#8221; di DataFrame:<\/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\n<\/span>df_pivot = pd. <span style=\"color: #3366ff;\">pivot_table<\/span> (df, values=' <span style=\"color: #ff0000;\">points<\/span> ', index=' <span style=\"color: #ff0000;\">team<\/span> ', columns=' <span style=\"color: #ff0000;\">position<\/span> ',\n                          aggfunc=' <span style=\"color: #ff0000;\">count<\/span> ')\n\n<span style=\"color: #008080;\">#view pivot table\n<\/span>df_pivot\n\nposition C F G\nteam\t\t\t\n   A 1.0 1.0 2.0\n   B NaN 3.0 1.0<\/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;\">Terdapat <strong>1<\/strong> nilai pada kolom \u201cpoin\u201d untuk tim A pada posisi C.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Terdapat <strong>1<\/strong> nilai pada kolom \u201cpoin\u201d untuk tim A di posisi F.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Terdapat <strong>2<\/strong> nilai pada kolom \u201cpoin\u201d untuk tim A di posisi G.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Metode 2: Buat PivotTable Pandas dengan Hitungan Unik<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara membuat tabel pivot di panda yang menampilkan jumlah total unik nilai &#8220;titik&#8221; untuk setiap &#8220;tim&#8221; dan &#8220;posisi&#8221; di DataFrame:<\/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\n<\/span>df_pivot = pd. <span style=\"color: #3366ff;\">pivot_table<\/span> (df, values=' <span style=\"color: #ff0000;\">points<\/span> ', index=' <span style=\"color: #ff0000;\">team<\/span> ', columns=' <span style=\"color: #ff0000;\">position<\/span> ',\n                          aggfunc=pd. <span style=\"color: #3366ff;\">Series<\/span> . <span style=\"color: #3366ff;\">nunique<\/span> )\n\n<span style=\"color: #008080;\">#view pivot table\n<\/span>df_pivot\n\nposition C F G\nteam\t\t\t\n   A 1.0 1.0 1.0\n   B NaN 2.0 1.0<\/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;\">Terdapat <strong>1<\/strong> nilai unik pada kolom &#8220;poin&#8221; untuk tim A di posisi C.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Terdapat <strong>1<\/strong> nilai unik pada kolom \u201cpoin\u201d untuk tim A di posisi F.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Terdapat <strong>1<\/strong> nilai unik pada kolom \u201cpoin\u201d untuk tim A di posisi G.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/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<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\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\/panda-panjang-hingga-lebar\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara membentuk ulang DataFrame dari panjang ke lebar<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-lebar-hingga-panjang\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara membentuk ulang DataFrame dari lebar ke panjang<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/pandas-mengelompokkan-dengan-menggabungkan-beberapa-kolom\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara mengelompokkan dan menggabungkan beberapa kolom<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan salah satu metode berikut untuk membuat tabel pivot di panda yang menampilkan jumlah nilai di kolom tertentu: Metode 1: Tabel Pivot dengan Angka p.d. pivot_table (df, values=&#8217; col1 &#8216;, index=&#8217; col2 &#8216;, columns=&#8217; col3 &#8216;, aggfunc=&#8217; count &#8216;) Metode 2: PivotTable dengan Angka Unik p.d. pivot_table (df, values=&#8217; col1 &#8216;, index=&#8217; col2 [&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 tabel pivot dengan jumlah nilai - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat tabel pivot di panda yang merangkum jumlah nilai pada kolom tertentu.\" \/>\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-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 tabel pivot dengan jumlah nilai - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat tabel pivot di panda yang merangkum jumlah nilai pada kolom tertentu.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/jumlah-tabel-pivot-panda\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T12:10:44+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\/jumlah-tabel-pivot-panda\/\",\"url\":\"https:\/\/statorials.org\/id\/jumlah-tabel-pivot-panda\/\",\"name\":\"Pandas: Cara membuat tabel pivot dengan jumlah nilai - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T12:10:44+00:00\",\"dateModified\":\"2023-07-22T12:10:44+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat tabel pivot di panda yang merangkum jumlah nilai pada kolom tertentu.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/jumlah-tabel-pivot-panda\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/jumlah-tabel-pivot-panda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/jumlah-tabel-pivot-panda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara membuat tabel pivot dengan sejumlah nilai\"}]},{\"@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 tabel pivot dengan jumlah nilai - Statorials","description":"Tutorial ini menjelaskan cara membuat tabel pivot di panda yang merangkum jumlah nilai pada kolom tertentu.","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-tabel-pivot-panda\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara membuat tabel pivot dengan jumlah nilai - Statorials","og_description":"Tutorial ini menjelaskan cara membuat tabel pivot di panda yang merangkum jumlah nilai pada kolom tertentu.","og_url":"https:\/\/statorials.org\/id\/jumlah-tabel-pivot-panda\/","og_site_name":"Statorials","article_published_time":"2023-07-22T12:10:44+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\/jumlah-tabel-pivot-panda\/","url":"https:\/\/statorials.org\/id\/jumlah-tabel-pivot-panda\/","name":"Pandas: Cara membuat tabel pivot dengan jumlah nilai - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T12:10:44+00:00","dateModified":"2023-07-22T12:10:44+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat tabel pivot di panda yang merangkum jumlah nilai pada kolom tertentu.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/jumlah-tabel-pivot-panda\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/jumlah-tabel-pivot-panda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/jumlah-tabel-pivot-panda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara membuat tabel pivot dengan sejumlah nilai"}]},{"@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\/2387"}],"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=2387"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2387\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2387"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2387"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2387"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}