{"id":3780,"date":"2023-07-15T14:29:24","date_gmt":"2023-07-15T14:29:24","guid":{"rendered":"https:\/\/statorials.org\/id\/tabel-pivot-pandas-menghapus-multiindex\/"},"modified":"2023-07-15T14:29:24","modified_gmt":"2023-07-15T14:29:24","slug":"tabel-pivot-pandas-menghapus-multiindex","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tabel-pivot-pandas-menghapus-multiindex\/","title":{"rendered":"Pandas: cara menghapus multiindex di tabel pivot"},"content":{"rendered":"

<\/p>\n

\n

Untuk menghapus multiIndex dari tabel pivot pandas, Anda dapat menggunakan argumen nilai<\/strong> dengan fungsi reset_index()<\/strong> :<\/span><\/p>\n

 p.d. pivot_table<\/span> (df, index=' col1<\/span> ', columns=' col2<\/span> ', values=' col3<\/span> '). reset_index<\/span> ()\n<\/strong><\/pre>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Hapus MultiIndex di Pandas PivotTable<\/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\n<\/span>df = pd. DataFrame<\/span> ({' team<\/span> ': ['A', 'A', 'A', 'A', 'B', 'B', 'B', 'B'],\n                   ' position<\/span> ': ['G', 'G', 'F', 'F', 'G', 'F', 'F', 'F'],\n                   ' points<\/span> ': [4, 4, 6, 8, 9, 5, 5, 12]})\n\n#view DataFrame\n<\/span>print<\/span> (df)\n\n  team position points\n0 AG 4\n1 GA 4\n2 AF 6\n3AF 8\n4 BG 9\n5 BF 5\n6 BF 5\n7 BF 12<\/strong><\/pre>\n
 Sekarang anggaplah kita membuat tabel pivot berikut untuk merangkum nilai rata-rata poin<\/strong> berdasarkan tim<\/strong> dan posisi<\/strong> :<\/span><\/p>\n
 #create pivot table to summarize mean points by team and position\n<\/span>p.d. pivot_table<\/span> (df, index=' team<\/span> ', columns=' position<\/span> ')\n\n\t        points\nFG position\nteam\t\t\nAt 7.000000 4.0\nB 7.333333 9.0\n<\/span><\/span><\/strong><\/pre>\n
 Tabel pivot yang dihasilkan merangkum nilai poin<\/strong> rata-rata berdasarkan team<\/strong> dan position<\/strong> , namun berisi multiIndex.<\/span><\/p>\n
 Untuk menghapus multiIndex, kita dapat menggunakan argumen nilai<\/strong> di fungsi pivot_table()<\/strong> dan menambahkan reset_index()<\/strong> di akhir:<\/span><\/p>\n
 #create pivot table to summarize mean points by team and position\n<\/span>p.d. pivot_table<\/span> (df, index=' team<\/span> ', columns=' position<\/span> ', values=' points<\/span> '). reset_index<\/span> ()\n\nposition team F G\n0 to 7.000000 4.0\n1 B 7.333333 9.0\n<\/span><\/span><\/strong><\/pre>\n
 Tabel pivot yang dihasilkan merangkum nilai poin<\/strong> rata-rata berdasarkan tim<\/strong> dan posisi<\/strong> dan tidak lagi memiliki multiIndex.<\/span><\/span><\/p>\n
 Perhatikan bahwa fungsi pivot_table()<\/strong> menghitung nilai rata-rata secara default.<\/span><\/p>\n
 Untuk menghitung metrik lain, seperti jumlah, gunakan argumen aggfunc<\/strong> sebagai berikut:<\/span><\/p>\n
 #create pivot table to summarize sum of points by team and position\n<\/span>p.d. pivot_table<\/span> (df, index=' team<\/span> ', columns=' position<\/span> ', values=' points<\/span> ',\n               aggfunc=' sum<\/span> '). reset_index<\/span> ()\n\nposition team FG\n0 to 14 8\n1 B 22 9<\/span><\/span><\/strong><\/pre>\n
 Tabel pivot yang dihasilkan merangkum jumlah nilai poin<\/strong> berdasarkan tim<\/strong> dan posisi<\/strong> dan juga tidak memiliki multiIndex.<\/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 operasi umum lainnya di panda:<\/span><\/p>\n
 Pandas: Cara menambahkan filter ke tabel pivot<\/a>
 Pandas: Cara mengurutkan tabel pivot berdasarkan nilai di kolom<\/a>
 Pandas: Cara menambahkan subtotal ke tabel pivot<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Untuk menghapus multiIndex dari tabel pivot pandas, Anda dapat menggunakan argumen nilai dengan fungsi reset_index() : p.d. pivot_table (df, index=’ col1 ‘, columns=’ col2 ‘, values=’ col3 ‘). reset_index () Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh: Hapus MultiIndex di Pandas PivotTable Misalkan kita memiliki pandas DataFrame berikut yang berisi informasi tentang […]<\/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 Menghapus MultiIndex di Tabel Pivot - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghapus multiIndex dari 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-pandas-menghapus-multiindex\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara Menghapus MultiIndex di Tabel Pivot - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghapus multiIndex dari tabel pivot pandas, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tabel-pivot-pandas-menghapus-multiindex\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T14:29:24+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-pandas-menghapus-multiindex\/\",\"url\":\"https:\/\/statorials.org\/id\/tabel-pivot-pandas-menghapus-multiindex\/\",\"name\":\"Pandas: Cara Menghapus MultiIndex di Tabel Pivot - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T14:29:24+00:00\",\"dateModified\":\"2023-07-15T14:29:24+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghapus multiIndex dari tabel pivot pandas, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tabel-pivot-pandas-menghapus-multiindex\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tabel-pivot-pandas-menghapus-multiindex\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tabel-pivot-pandas-menghapus-multiindex\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara menghapus multiindex di 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 Menghapus MultiIndex di Tabel Pivot - Statologi","description":"Tutorial ini menjelaskan cara menghapus multiIndex dari 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-pandas-menghapus-multiindex\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara Menghapus MultiIndex di Tabel Pivot - Statologi","og_description":"Tutorial ini menjelaskan cara menghapus multiIndex dari tabel pivot pandas, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/tabel-pivot-pandas-menghapus-multiindex\/","og_site_name":"Statorials","article_published_time":"2023-07-15T14:29:24+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-pandas-menghapus-multiindex\/","url":"https:\/\/statorials.org\/id\/tabel-pivot-pandas-menghapus-multiindex\/","name":"Pandas: Cara Menghapus MultiIndex di Tabel Pivot - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T14:29:24+00:00","dateModified":"2023-07-15T14:29:24+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghapus multiIndex dari tabel pivot pandas, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tabel-pivot-pandas-menghapus-multiindex\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tabel-pivot-pandas-menghapus-multiindex\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tabel-pivot-pandas-menghapus-multiindex\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara menghapus multiindex di 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\/3780"}],"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=3780"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3780\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3780"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3780"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3780"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}