{"id":3124,"date":"2023-07-19T02:40:19","date_gmt":"2023-07-19T02:40:19","guid":{"rendered":"https:\/\/statorials.org\/id\/nama-kolom-tabel-pivot-pandas\/"},"modified":"2023-07-19T02:40:19","modified_gmt":"2023-07-19T02:40:19","slug":"nama-kolom-tabel-pivot-pandas","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/nama-kolom-tabel-pivot-pandas\/","title":{"rendered":"Pandas: cara mengubah nama kolom di tabel pivot"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin mengubah atau memformat nama kolom di tabel pivot pandas dengan cara tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini mudah dilakukan menggunakan fungsi bawaan panda.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara melakukan hal ini.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Mengubah Nama Kolom di Tabel Pivot Pandas<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki pandas DataFrame berikut yang berisi informasi tentang berbagai pemain bola basket:<\/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>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', 'C', 'G', 'C', 'F', 'F'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [4, 4, 6, 8, 9, 5, 5, 12]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n\tteam position points\n0 A G 4\n1 A G 4\n2 A F 6\n3 A C 8\n4 B G 9\n5 B C 5\n6 B F 5\n7 B F 12<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk membuat tabel pivot di panda yang menunjukkan nilai <strong>poin<\/strong> rata-rata untuk setiap <strong>tim<\/strong> dan <strong>posisi<\/strong> di DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#create pivot table\n<span style=\"color: #000000;\">piv = 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><span style=\"color: #008000;\">print<\/span> (piv)\n\nCFG position\nteam                   \nA 8.0 6.0 4.0\nB 5.0 8.5 9.0<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Sekarang katakanlah kita ingin menghapus <strong>posisi<\/strong> kata dalam tabel pivot dan menghapus baris <strong>tim<\/strong> tambahan dari tabel pivot.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#format column names\n<\/span>iv. <span style=\"color: #3366ff;\">columns<\/span> = ['_'. <span style=\"color: #3366ff;\">join<\/span> (str(s). <span style=\"color: #3366ff;\">strip<\/span> () <span style=\"color: #008000;\">for<\/span> s <span style=\"color: #008000;\">in<\/span> col <span style=\"color: #008000;\">if<\/span> s) <span style=\"color: #008000;\">for<\/span> col <span style=\"color: #008000;\">in<\/span> piv. <span style=\"color: #3366ff;\">columns<\/span> ]\n\n<span style=\"color: #008080;\">#reset indexes\n<\/span>iv. <span style=\"color: #3366ff;\">reset_index<\/span> (inplace= <span style=\"color: #008000;\">True<\/span> )\n\n<span style=\"color: #008080;\">#view updated pivot table\n<\/span><span style=\"color: #008000;\">print<\/span> (piv)\n\n  team CFG\n0 A 8.0 6.0 4.0\n1 B 5.0 8.5 9.0\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kami dapat menghapus <strong>posisi<\/strong> kata dalam tabel pivot dan menghapus baris <strong>tim<\/strong> tambahan dari tabel pivot.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan juga bahwa solusi umum ini juga akan berfungsi untuk PivotTable dengan MultiIndex.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi pandas <strong>pivot_table()<\/strong> <a href=\"https:\/\/pandas.pydata.org\/docs\/reference\/api\/pandas.pivot_table.html\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/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 di panda:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/jumlah-tabel-pivot-panda\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara membuat tabel pivot dengan jumlah nilai<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tabel-pivot-panda-ganti-nan-dengan-0\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara mengganti nilai NaN di tabel pivot dengan nol<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tabel-pivot-pandas-ke-kerangka-data\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara mengonversi PivotTable ke DataFrame<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin mengubah atau memformat nama kolom di tabel pivot pandas dengan cara tertentu. Untungnya, hal ini mudah dilakukan menggunakan fungsi bawaan panda. Contoh berikut menunjukkan cara melakukan hal ini. Contoh: Mengubah Nama Kolom di Tabel Pivot Pandas Misalkan kita memiliki pandas DataFrame berikut yang berisi informasi tentang berbagai pemain bola basket: import [&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>Pandas: Cara mengubah nama kolom di tabel pivot - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengubah nama kolom di 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\/nama-kolom-tabel-pivot-pandas\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara mengubah nama kolom di tabel pivot - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengubah nama kolom di tabel pivot pandas, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/nama-kolom-tabel-pivot-pandas\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-19T02:40:19+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\/nama-kolom-tabel-pivot-pandas\/\",\"url\":\"https:\/\/statorials.org\/id\/nama-kolom-tabel-pivot-pandas\/\",\"name\":\"Pandas: Cara mengubah nama kolom di tabel pivot - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-19T02:40:19+00:00\",\"dateModified\":\"2023-07-19T02:40:19+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengubah nama kolom di tabel pivot pandas, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/nama-kolom-tabel-pivot-pandas\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/nama-kolom-tabel-pivot-pandas\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/nama-kolom-tabel-pivot-pandas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara mengubah nama kolom 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 mengubah nama kolom di tabel pivot - Statorials","description":"Tutorial ini menjelaskan cara mengubah nama kolom di 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\/nama-kolom-tabel-pivot-pandas\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara mengubah nama kolom di tabel pivot - Statorials","og_description":"Tutorial ini menjelaskan cara mengubah nama kolom di tabel pivot pandas, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/nama-kolom-tabel-pivot-pandas\/","og_site_name":"Statorials","article_published_time":"2023-07-19T02:40:19+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\/nama-kolom-tabel-pivot-pandas\/","url":"https:\/\/statorials.org\/id\/nama-kolom-tabel-pivot-pandas\/","name":"Pandas: Cara mengubah nama kolom di tabel pivot - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-19T02:40:19+00:00","dateModified":"2023-07-19T02:40:19+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengubah nama kolom di tabel pivot pandas, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/nama-kolom-tabel-pivot-pandas\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/nama-kolom-tabel-pivot-pandas\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/nama-kolom-tabel-pivot-pandas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara mengubah nama kolom 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\/3124"}],"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=3124"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3124\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3124"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3124"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}