{"id":2098,"date":"2023-07-23T17:12:17","date_gmt":"2023-07-23T17:12:17","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-meratakan-multiindex\/"},"modified":"2023-07-23T17:12:17","modified_gmt":"2023-07-23T17:12:17","slug":"panda-meratakan-multiindex","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-meratakan-multiindex\/","title":{"rendered":"Cara meratakan multiindex di pandas (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk meratakan MultiIndex di panda:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#flatten all levels of MultiIndex<\/span>\ndf. <span style=\"color: #3366ff;\">reset_index<\/span> (inplace= <span style=\"color: #008000;\">True<\/span> )\n\n<span style=\"color: #008080;\">#flatten specific levels of MultiIndex<\/span>\ndf. <span style=\"color: #3366ff;\">reset_index<\/span> (inplace= <span style=\"color: #008000;\">True<\/span> , level = [' <span style=\"color: #ff0000;\">level_name<\/span> '])\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Ratakan semua level MultiIndex di Pandas<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki MultiIndex DataFrame panda 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>index_names = pd. <span style=\"color: #3366ff;\">MultiIndex<\/span> . <span style=\"color: #3366ff;\">from_tuples<\/span> ([('Level1','Lev1', 'L1'),\n                                       ('Level2','Lev2', 'L2'),\n                                       ('Level3','Lev3', 'L3'),\n                                       ('Level4','Lev4', 'L4')],\n                                       names=['Full','Partial', 'ID'])\n\ndata = {'Store': ['A','B','C','D'],\n        'Sales': [12, 44, 29, 35]}\n\ndf = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> (data, columns = [' <span style=\"color: #ff0000;\">Store<\/span> ',' <span style=\"color: #ff0000;\">Sales<\/span> '], index=index_names)\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span>df\n\n\t\t\tStore Sales\nFull Partial ID\t\t\nLevel1 Lev1 L1 A 17\nLevel2 Lev2 L2 B 22\nLevel3 Lev3 L3 C 29\nLevel4 Lev4 L4 D 35\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk meratakan setiap level MultiIndex ke dalam kolom DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#flatten every level of MultiIndex<\/span> \ndf. <span style=\"color: #3366ff;\">reset_index<\/span> (inplace= <span style=\"color: #008000;\">True<\/span> )\n\n<span style=\"color: #008080;\">#view updated DataFrame<\/span>\ndf\n\n        Full Partial ID Store Sales\n0 Level1 Lev1 L1 A 12\n1 Level2 Lev2 L2 B 44\n2 Level3 Lev3 L3 C 29\n3 Level4 Lev4 L4 D 35\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa setiap level MultiIndex sekarang menjadi kolom di DataFrame.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Meratakan level MultiIndex tertentu di Pandas<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Anggaplah kita memiliki pandas DataFrame yang sama seperti contoh sebelumnya:<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#view DataFrame<\/span>\n<span style=\"color: #000000;\">df\n\n<\/span>Store Sales\nFull Partial ID\t\t\nLevel1 Lev1 L1 A 12\nLevel2 Lev2 L2 B 44\nLevel3 Lev3 L3 C 29\nLevel4 Lev4 L4 D 35\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara meratakan satu level MultiIndex tertentu:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#flatten 'ID' level only\n<span style=\"color: #000000;\">df. <span style=\"color: #3366ff;\">reset_index<\/span> (inplace= <span style=\"color: #008000;\">True<\/span> ,level=[' <span style=\"color: #ff0000;\">ID<\/span> '])\n\n<span style=\"color: #008080;\">#view updated DataFrame<\/span>\ndf\n\n\t\tID Store Sales\nFull Partial\t\t\t\nLevel1 Lev1 L1 A 12\nLevel2 Lev2 L2 B 44\nLevel3 Lev3 L3 C 29\nLevel4 Lev4 L4 D 35<\/span>\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Dan kode berikut menunjukkan cara meratakan beberapa level MultiIndex tertentu:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#flatten 'ID' level only\n<span style=\"color: #000000;\">df. <span style=\"color: #3366ff;\">reset_index<\/span> (inplace= <span style=\"color: #008000;\">True<\/span> ,level=[' <span style=\"color: #ff0000;\">Partial<\/span> ',' <span style=\"color: #ff0000;\">ID<\/span> '])\n\n<span style=\"color: #008080;\">#view updated DataFrame<\/span>\ndf\n\n\tPartial ID Store Sales\nFull\t\t\t\t\nLevel1 Lev1 L1 A 12\nLevel2 Lev2 L2 B 44\nLevel3 Lev3 L3 C 29\nLevel4 Lev4 L4 D 35<\/span><\/span><\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara menjalankan fungsi umum lainnya di panda:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/panda-mengubah-indeks-menjadi-kolom\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara mengubah indeks menjadi kolom di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/ganti-nama-indeks-panda\/\" target=\"_blank\" rel=\"noopener\">Cara mengganti nama indeks di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-mengatur-kolom-sebagai-indeks\/\" target=\"_blank\" rel=\"noopener\">Cara mengatur kolom sebagai indeks di Pandas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk meratakan MultiIndex di panda: #flatten all levels of MultiIndex df. reset_index (inplace= True ) #flatten specific levels of MultiIndex df. reset_index (inplace= True , level = [&#8216; level_name &#8216;]) Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh 1: Ratakan semua level MultiIndex di Pandas Misalkan kita [&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>Cara meratakan MultiIndex di Pandas (dengan contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara meratakan multiIndex di panda, dengan beberapa 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\/panda-meratakan-multiindex\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara meratakan MultiIndex di Pandas (dengan contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara meratakan multiIndex di panda, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-meratakan-multiindex\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-23T17:12:17+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\/panda-meratakan-multiindex\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-meratakan-multiindex\/\",\"name\":\"Cara meratakan MultiIndex di Pandas (dengan contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-23T17:12:17+00:00\",\"dateModified\":\"2023-07-23T17:12:17+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara meratakan multiIndex di panda, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-meratakan-multiindex\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-meratakan-multiindex\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-meratakan-multiindex\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara meratakan multiindex di pandas (dengan contoh)\"}]},{\"@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":"Cara meratakan MultiIndex di Pandas (dengan contoh) - Statorials","description":"Tutorial ini menjelaskan cara meratakan multiIndex di panda, dengan beberapa 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\/panda-meratakan-multiindex\/","og_locale":"id_ID","og_type":"article","og_title":"Cara meratakan MultiIndex di Pandas (dengan contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara meratakan multiIndex di panda, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/panda-meratakan-multiindex\/","og_site_name":"Statorials","article_published_time":"2023-07-23T17:12:17+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\/panda-meratakan-multiindex\/","url":"https:\/\/statorials.org\/id\/panda-meratakan-multiindex\/","name":"Cara meratakan MultiIndex di Pandas (dengan contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-23T17:12:17+00:00","dateModified":"2023-07-23T17:12:17+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara meratakan multiIndex di panda, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-meratakan-multiindex\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-meratakan-multiindex\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-meratakan-multiindex\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara meratakan multiindex di pandas (dengan contoh)"}]},{"@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\/2098"}],"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=2098"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2098\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2098"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2098"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2098"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}