{"id":3004,"date":"2023-07-19T16:34:23","date_gmt":"2023-07-19T16:34:23","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-tidak-berputar\/"},"modified":"2023-07-19T16:34:23","modified_gmt":"2023-07-19T16:34:23","slug":"panda-tidak-berputar","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-tidak-berputar\/","title":{"rendered":"Cara membatalkan pivot dataframe pandas (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Di panda, Anda dapat menggunakan fungsimelt <a href=\"https:\/\/pandas.pydata.org\/docs\/reference\/api\/pandas.melt.html\" target=\"_blank\" rel=\"noopener\">()<\/a> untuk membatalkan pivot DataFrame \u2013 mengonversinya dari format lebar ke <a href=\"https:\/\/statorials.org\/id\/data-panjang-vs-data-lebar\/\" target=\"_blank\" rel=\"noopener\">format panjang<\/a> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini menggunakan sintaks dasar berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df_unpivot = pd. <span style=\"color: #3366ff;\">melt<\/span> (df, id_vars=' <span style=\"color: #ff0000;\">col1<\/span> ', value_vars=[' <span style=\"color: #ff0000;\">col2<\/span> ', ' <span style=\"color: #ff0000;\">col3<\/span> ', ...])\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>id_vars<\/strong> : Kolom yang akan digunakan sebagai pengidentifikasi<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>value_vars<\/strong> : Kolom yang akan dilepas porosnya<\/span><\/li>\n<\/ul>\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: membatalkan pivot pada Pandas 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', 'B', 'C', 'D', 'E'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [18, 22, 19, 14, 14],\n                   ' <span style=\"color: #ff0000;\">assists<\/span> ': [5, 7, 7, 9, 12],\n                   ' <span style=\"color: #ff0000;\">rebounds<\/span> ': [11, 8, 10, 6, 6]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n  team points assists rebounds\n0 A 18 5 11\n1 B 22 7 8\n2 C 19 7 10\n3 D 14 9 6\n4 E 14 12 6<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk &#8220;melepaskan&#8221; DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#unpivot DataFrame from wide format to long format\n<span style=\"color: #000000;\">df_unpivot = pd. <span style=\"color: #3366ff;\">melt<\/span> (df, id_vars=' <span style=\"color: #ff0000;\">team<\/span> ', value_vars=[' <span style=\"color: #ff0000;\">points<\/span> ', ' <span style=\"color: #ff0000;\">assists<\/span> ', ' <span style=\"color: #ff0000;\">rebounds<\/span> '])\n<\/span>\n#view updated DataFrame\n<span style=\"color: #000000;\"><span style=\"color: #008000;\">print<\/span> (df_unpivot)\n\n   team variable value\n0 A points 18\n1 B points 22\n2 C points 19\n3 D dots 14\n4 E points 14\n5 A assists 5\n6 B assists 7\n7 C assists 7\n8 D assists 9\n9 E assists 12\n10 A rebounds 11\n11 B rebounds 8\n12 C rebounds 10\n13 D rebounds 6\n14 E rebounds 6\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kami menggunakan kolom <strong>tim<\/strong> sebagai kolom pengidentifikasi dan memilih untuk tidak merotasi <strong>kolom<\/strong> poin, <strong>assist<\/strong> , dan <strong>rebound<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Hasilnya adalah DataFrame format panjang.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kita juga dapat menggunakan argumen <strong>var_name<\/strong> dan <strong>value_name<\/strong> untuk menentukan nama kolom di DataFrame yang tidak diputar:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#unpivot DataFrame from wide format to long format<\/span>\ndf_unpivot = pd. <span style=\"color: #3366ff;\">melt<\/span> (df, id_vars=' <span style=\"color: #ff0000;\">team<\/span> ', value_vars=[' <span style=\"color: #ff0000;\">points<\/span> ', ' <span style=\"color: #ff0000;\">assists<\/span> ', ' <span style=\"color: #ff0000;\">rebounds<\/span> '],\n             var_name=' <span style=\"color: #ff0000;\">metric<\/span> ', value_name=' <span style=\"color: #ff0000;\">amount<\/span> ')\n\n<span style=\"color: #008080;\">#view updated DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df_unpivot)\n\n   team metric amount\n0 A points 18\n1 B points 22\n2 C points 19\n3 D dots 14\n4 E points 14\n5 A assists 5\n6 B assists 7\n7 C assists 7\n8 D assists 9\n9 E assists 12\n10 A rebounds 11\n11 B rebounds 8\n12 C rebounds 10\n13 D rebounds 6\n14 E rebounds 6\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kolom baru sekarang diberi judul <strong>Metric<\/strong> dan <strong>Amount<\/strong> .<\/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 dengan Python:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/pandas-menambahkan-baris-ke-kerangka-data\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan baris ke Pandas DataFrame<\/a><br \/> Bagaimana cara menambahkan kolom ke Pandas DataFrame<br \/> <a href=\"https:\/\/statorials.org\/id\/pandas-menghitung-nilai-tertentu-di-kolom\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung kemunculan nilai tertentu di Pandas DataFrame<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Di panda, Anda dapat menggunakan fungsimelt () untuk membatalkan pivot DataFrame \u2013 mengonversinya dari format lebar ke format panjang . Fungsi ini menggunakan sintaks dasar berikut: df_unpivot = pd. melt (df, id_vars=&#8217; col1 &#8216;, value_vars=[&#8216; col2 &#8216;, &#8216; col3 &#8216;, &#8230;]) Emas: id_vars : Kolom yang akan digunakan sebagai pengidentifikasi value_vars : Kolom yang akan [&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 membatalkan pivot DataFrame Pandas (dengan contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membatalkan pivot DataFrame panda, 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\/panda-tidak-berputar\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara membatalkan pivot DataFrame Pandas (dengan contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membatalkan pivot DataFrame panda, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-tidak-berputar\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-19T16:34:23+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-tidak-berputar\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-tidak-berputar\/\",\"name\":\"Cara membatalkan pivot DataFrame Pandas (dengan contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-19T16:34:23+00:00\",\"dateModified\":\"2023-07-19T16:34:23+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membatalkan pivot DataFrame panda, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-tidak-berputar\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-tidak-berputar\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-tidak-berputar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membatalkan pivot dataframe 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 membatalkan pivot DataFrame Pandas (dengan contoh) - Statologi","description":"Tutorial ini menjelaskan cara membatalkan pivot DataFrame panda, 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\/panda-tidak-berputar\/","og_locale":"id_ID","og_type":"article","og_title":"Cara membatalkan pivot DataFrame Pandas (dengan contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara membatalkan pivot DataFrame panda, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/panda-tidak-berputar\/","og_site_name":"Statorials","article_published_time":"2023-07-19T16:34:23+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-tidak-berputar\/","url":"https:\/\/statorials.org\/id\/panda-tidak-berputar\/","name":"Cara membatalkan pivot DataFrame Pandas (dengan contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-19T16:34:23+00:00","dateModified":"2023-07-19T16:34:23+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membatalkan pivot DataFrame panda, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-tidak-berputar\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-tidak-berputar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-tidak-berputar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membatalkan pivot dataframe 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\/3004"}],"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=3004"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3004\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3004"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3004"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3004"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}