{"id":3778,"date":"2023-07-15T14:42:57","date_gmt":"2023-07-15T14:42:57","guid":{"rendered":"https:\/\/statorials.org\/id\/filter-tabel-pivot-panda\/"},"modified":"2023-07-15T14:42:57","modified_gmt":"2023-07-15T14:42:57","slug":"filter-tabel-pivot-panda","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/filter-tabel-pivot-panda\/","title":{"rendered":"Pandas: cara menambahkan filter ke tabel pivot"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks dasar berikut untuk menambahkan kondisi filter ke tabel pivot pandas:<\/span><\/p>\n

 df[df. col1<\/span> ==<\/span> ' A<\/span> ']. pivot_table<\/span> (index=' col1<\/span> ', values=[' col2<\/span> ', ' col3<\/span> '], aggfunc=' sum<\/span> ')\n<\/strong><\/pre>\n
 Contoh khusus ini membuat tabel pivot yang menampilkan jumlah nilai col2<\/strong> dan col3<\/strong> , yang dikelompokkan berdasarkan col1<\/strong> .<\/span><\/p>\n
 Filter sebelum fungsi pivot_table()<\/strong> menetapkan bahwa kita hanya ingin menyertakan baris yang nilai di col1<\/strong> DataFrame asli memiliki nilai “A”.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Cara menambahkan filter ke tabel pivot Pandas<\/strong><\/span><\/h2>\n
 Misalkan kita memiliki pandas DataFrame berikut yang berisi informasi tentang berbagai pemain bola basket:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#createDataFrame<\/span>\ndf = pd. DataFrame<\/span> ({' team<\/span> ': ['A', 'A', 'A', 'A', 'B', 'B',\n                            'B', 'B', 'C', 'C', 'C', 'C'],\n                   ' points<\/span> ': [4, 4, 2, 8, 9, 5, 5, 7, 8, 8, 4, 3],\n                   ' assists<\/span> ': [2, 2, 5, 5, 4, 7, 5, 3, 9, 8, 4, 4]})\n\n#view DataFrame\n<\/span>print<\/span> (df)\n\n   team points assists\n0 to 4 2\n1 to 4 2\n2 to 2 5\n3 to 8 5\n4 B 9 4\n5 B 5 7\n6 B 5 5\n7 B 7 3\n8 C 8 9\n9 C 8 8\n10 C 4 4\n11 C 3 4\n<\/strong><\/pre>\n
 Kita dapat menggunakan kode berikut untuk membuat tabel pivot di panda yang menampilkan jumlah nilai dalam kolom poin<\/strong> dan bantuan<\/strong> yang dikelompokkan berdasarkan tim<\/strong> hanya untuk baris di mana DataFrame asli memiliki nilai di kolom skor. tim<\/strong> sama dengan “A”:<\/span><\/p>\n
 #create pivot table for rows where team is equal to 'A'\n<\/span>df[df. team<\/span> ==<\/span> ' A<\/span> ']. pivot_table<\/span> (index=' team<\/span> ', values=[' points<\/span> ', ' assists<\/span> '],\n                                 aggfunc=' sum<\/span> ')\n\n        assist points\nteam\t\t\nAt 14 18<\/span><\/span><\/strong><\/pre>\n
 Perhatikan bahwa tabel pivot hanya merangkum nilai poin<\/strong> dan kolom bantuan<\/strong> untuk baris di mana tim<\/strong> sama dengan “A”.<\/span><\/p>\n
 Anda juga dapat menggunakan operator &<\/strong> dan |<\/strong> untuk menerapkan filter yang menggunakan logika \u201cDAN\u201d atau \u201cATAU\u201d.<\/span><\/p>\n
 Misalnya, kita bisa menggunakan sintaks berikut untuk membuat tabel pivot yang memfilter baris dengan nilai di kolom tim<\/strong> DataFrame asli sama dengan “A” atau “B”:<\/span><\/p>\n
 #create pivot table for rows where team is equal to 'A' or 'B'<\/span>\ndf[( df.team<\/span> ==<\/span> ' A<\/span> ') | (df. team<\/span> ==<\/span> ' B<\/span> ')]. pivot_table<\/span> (index=' team<\/span> ',\n                                                    values=[' points<\/span> ', ' assists<\/span> '],\n                                                    aggfunc=' sum<\/span> ')\n\n\tassist points\nteam\t\t\nAt 14 18\nB 19 26<\/span><\/span><\/strong><\/pre>\n
 Perhatikan bahwa tabel pivot hanya merangkum nilai dalam kolom poin<\/strong> dan bantuan<\/strong> untuk baris di mana tim<\/strong> sama dengan “A” atau “B”.<\/span><\/p>\n
 Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi pandas pivot_table()<\/strong> di sini<\/a> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di panda:<\/span><\/p>\n
 Pandas: Cara mengurutkan tabel pivot berdasarkan nilai di kolom<\/a>
 Pandas: Cara membuat tabel pivot dengan jumlah nilai
 Pandas: Cara menambahkan subtotal ke tabel pivot<\/a>
 Pandas: Cara mengubah nama kolom di tabel pivot<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut untuk menambahkan kondisi filter ke tabel pivot pandas: df[df. col1 == ‘ A ‘]. pivot_table (index=’ col1 ‘, values=[‘ col2 ‘, ‘ col3 ‘], aggfunc=’ sum ‘) Contoh khusus ini membuat tabel pivot yang menampilkan jumlah nilai col2 dan col3 , yang dikelompokkan berdasarkan col1 . Filter sebelum fungsi […]<\/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":"\nPandas: Cara menambahkan filter ke tabel pivot - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menambahkan filter 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\/filter-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 menambahkan filter ke tabel pivot - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menambahkan filter ke tabel pivot pandas, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/filter-tabel-pivot-panda\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T14:42:57+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\/filter-tabel-pivot-panda\/\",\"url\":\"https:\/\/statorials.org\/id\/filter-tabel-pivot-panda\/\",\"name\":\"Pandas: Cara menambahkan filter ke tabel pivot - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T14:42:57+00:00\",\"dateModified\":\"2023-07-15T14:42:57+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menambahkan filter ke tabel pivot pandas, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/filter-tabel-pivot-panda\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/filter-tabel-pivot-panda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/filter-tabel-pivot-panda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara menambahkan filter 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 filter ke tabel pivot - Statologi","description":"Tutorial ini menjelaskan cara menambahkan filter 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\/filter-tabel-pivot-panda\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara menambahkan filter ke tabel pivot - Statologi","og_description":"Tutorial ini menjelaskan cara menambahkan filter ke tabel pivot pandas, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/filter-tabel-pivot-panda\/","og_site_name":"Statorials","article_published_time":"2023-07-15T14:42:57+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\/filter-tabel-pivot-panda\/","url":"https:\/\/statorials.org\/id\/filter-tabel-pivot-panda\/","name":"Pandas: Cara menambahkan filter ke tabel pivot - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T14:42:57+00:00","dateModified":"2023-07-15T14:42:57+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menambahkan filter ke tabel pivot pandas, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/filter-tabel-pivot-panda\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/filter-tabel-pivot-panda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/filter-tabel-pivot-panda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara menambahkan filter 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\/3778"}],"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=3778"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3778\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3778"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3778"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3778"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}