{"id":2386,"date":"2023-07-22T12:12:16","date_gmt":"2023-07-22T12:12:16","guid":{"rendered":"https:\/\/statorials.org\/id\/tabel-pivot-pandas-ke-kerangka-data\/"},"modified":"2023-07-22T12:12:16","modified_gmt":"2023-07-22T12:12:16","slug":"tabel-pivot-pandas-ke-kerangka-data","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tabel-pivot-pandas-ke-kerangka-data\/","title":{"rendered":"Cara mengonversi pivottable pandas ke dataframe"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk mengonversi PivotTable pandas menjadi DataFrame pandas:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df = pivot_name. <span style=\"color: #3366ff;\">reset_index<\/span> ()<\/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: Konversi PivotTable ke DataFrame<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki panda 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 style=\"color: #000000;\">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', 'F', 'G', 'G', 'F', 'F'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [11, 8, 10, 6, 6, 5, 9, 12]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span>df\n\n\tteam position points\n0 A G 11\n1 A G 8\n2 A F 10\n3 A F 6\n4 B G 6\n5 B G 5\n6 B F 9\n7 B F 12\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk membuat tabel pivot yang menampilkan rata-rata poin yang dicetak 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\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\n<span style=\"color: #008080;\">#view pivot table\n<\/span>df_pivot\n\nposition F G\nteam\t\t\nAt 8.0 9.5\nB 10.5 5.5<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menggunakan fungsi <strong>reset_index()<\/strong> untuk mengonversi tabel pivot ini menjadi DataFrame pandas:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#convert pivot table to DataFrame\n<\/span>df2 = df_pivot. <span style=\"color: #3366ff;\">reset_index<\/span> ()\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span>df2\n\n\tteam F G\n0 to 8.0 9.5\n1 B 10.5 5.5\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Hasilnya adalah DataFrame panda dengan dua baris dan tiga kolom.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita juga dapat menggunakan sintaks berikut untuk <a href=\"https:\/\/statorials.org\/id\/panda-mengganti-nama-kolom\/\" target=\"_blank\" rel=\"noopener\">mengganti nama kolom<\/a> 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;\">#convert pivot table to DataFrame\n<\/span>df2. <span style=\"color: #3366ff;\">columns<\/span> = [' <span style=\"color: #ff0000;\">team<\/span> ', ' <span style=\"color: #ff0000;\">Forward_Pts<\/span> ', ' <span style=\"color: #ff0000;\">Guard_Pts<\/span> ']\n\n<span style=\"color: #008080;\">#view updated DataFrame\n<\/span>df2\n\n        team Forward_Pts Guard_Pts\n0 to 8.0 9.5\n1 B 10.5 5.5<\/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 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 sintaks berikut untuk mengonversi PivotTable pandas menjadi DataFrame pandas: df = pivot_name. reset_index () Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh: Konversi PivotTable ke DataFrame Misalkan kita memiliki panda DataFrame berikut: import pandas as pd #createDataFrame df = pd. DataFrame ({&#8216; team &#8216;: [&#8216;A&#8217;, &#8216;A&#8217;, &#8216;A&#8217;, &#8216;A&#8217;, &#8216;B&#8217;, &#8216;B&#8217;, [&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 mengonversi PivotTable Pandas ke DataFrame - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengonversi pandas PivotTable ke pandas DataFrame, 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\/tabel-pivot-pandas-ke-kerangka-data\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara mengonversi PivotTable Pandas ke DataFrame - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengonversi pandas PivotTable ke pandas DataFrame, termasuk contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tabel-pivot-pandas-ke-kerangka-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T12:12:16+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=\"1 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-ke-kerangka-data\/\",\"url\":\"https:\/\/statorials.org\/id\/tabel-pivot-pandas-ke-kerangka-data\/\",\"name\":\"Cara mengonversi PivotTable Pandas ke DataFrame - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T12:12:16+00:00\",\"dateModified\":\"2023-07-22T12:12:16+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengonversi pandas PivotTable ke pandas DataFrame, termasuk contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tabel-pivot-pandas-ke-kerangka-data\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tabel-pivot-pandas-ke-kerangka-data\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tabel-pivot-pandas-ke-kerangka-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengonversi pivottable pandas ke dataframe\"}]},{\"@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 mengonversi PivotTable Pandas ke DataFrame - Statorials","description":"Tutorial ini menjelaskan cara mengonversi pandas PivotTable ke pandas DataFrame, 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\/tabel-pivot-pandas-ke-kerangka-data\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mengonversi PivotTable Pandas ke DataFrame - Statorials","og_description":"Tutorial ini menjelaskan cara mengonversi pandas PivotTable ke pandas DataFrame, termasuk contohnya.","og_url":"https:\/\/statorials.org\/id\/tabel-pivot-pandas-ke-kerangka-data\/","og_site_name":"Statorials","article_published_time":"2023-07-22T12:12:16+00:00","author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/tabel-pivot-pandas-ke-kerangka-data\/","url":"https:\/\/statorials.org\/id\/tabel-pivot-pandas-ke-kerangka-data\/","name":"Cara mengonversi PivotTable Pandas ke DataFrame - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T12:12:16+00:00","dateModified":"2023-07-22T12:12:16+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengonversi pandas PivotTable ke pandas DataFrame, termasuk contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tabel-pivot-pandas-ke-kerangka-data\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tabel-pivot-pandas-ke-kerangka-data\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tabel-pivot-pandas-ke-kerangka-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengonversi pivottable pandas ke dataframe"}]},{"@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\/2386"}],"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=2386"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2386\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2386"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2386"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}