{"id":3777,"date":"2023-07-15T14:49:31","date_gmt":"2023-07-15T14:49:31","guid":{"rendered":"https:\/\/statorials.org\/id\/mantra-tabel-pivot-panda\/"},"modified":"2023-07-15T14:49:31","modified_gmt":"2023-07-15T14:49:31","slug":"mantra-tabel-pivot-panda","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/mantra-tabel-pivot-panda\/","title":{"rendered":"Pandas: cara mengurutkan tabel pivot berdasarkan nilai di kolom"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk mengurutkan tabel pivot pandas berdasarkan nilai kolom:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>my_pivot_table. <span style=\"color: #3366ff;\">sort_values<\/span> (by=[' <span style=\"color: #ff0000;\">some_column<\/span> '], ascending= <span style=\"color: #008000;\">False<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini mengurutkan nilai tabel pivot yang disebut <strong>my_pivot_table<\/strong> berdasarkan nilai <strong>some_column<\/strong> dalam urutan menurun.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Urutkan tabel pivot Pandas berdasarkan nilai di kolom<\/strong><\/span><\/h2>\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<\/span>\ndf = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">team<\/span> ': ['A', 'A', 'A', 'A', 'B', 'B',\n                            'B', 'B', 'C', 'C', 'C', 'C'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [4, 4, 2, 8, 9, 5, 5, 7, 8, 8, 4, 3],\n                   ' <span style=\"color: #ff0000;\">assists<\/span> ': [2, 2, 5, 5, 4, 7, 5, 3, 9, 8, 4, 4]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n   team points assists\n0 to 4 2\n1 to 4 2\n2 to 2 5\n3 to 8 5\n4 B 9 4\n5 B 5 7\n6 B 5 5\n7 B 7 3\n8 C 8 9\n9 C 8 8\n10 C 4 4\n11 C 3 4\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk membuat tabel pivot di panda yang menampilkan jumlah nilai di kolom <strong>poin<\/strong> dan <strong>bantuan<\/strong> untuk setiap tim:<\/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 = df. <span style=\"color: #3366ff;\">pivot_table<\/span> (index=[' <span style=\"color: #ff0000;\">team<\/span> '], values=[' <span style=\"color: #ff0000;\">points<\/span> ', ' <span style=\"color: #ff0000;\">assists<\/span> '], aggfunc=' <span style=\"color: #ff0000;\">sum<\/span> ')\n\n<span style=\"color: #008080;\">#view pivot table\n<\/span><span style=\"color: #008000;\">print<\/span> (df_pivot)\n\n      assist points\nteam                 \nAt 14 18\nB 19 26\nC 25 23\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Secara default, panda mengurutkan baris tabel pivot berdasarkan abjad berdasarkan nilai kolom indeks, yang merupakan kolom <strong>tim<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, kita bisa menggunakan fungsi <strong>sort_values()<\/strong> untuk mengurutkan baris tabel pivot berdasarkan nilai kolom <strong>titik<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#sort pivot table by value in 'points' column in descending order\n<\/span>sorted_df_pivot = df_pivot. <span style=\"color: #3366ff;\">sort_values<\/span> (by=[' <span style=\"color: #ff0000;\">points<\/span> '], ascending= <span style=\"color: #008000;\">False<\/span> )\n\n<span style=\"color: #008080;\">#view sorted pivot table\n<\/span><span style=\"color: #008000;\">print<\/span> (sorted_df_pivot)\n\n      assist points\nteam                 \nB 19 26\nC 25 23\nAt 14 18\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa baris PivotTable kini diurutkan berdasarkan nilai di kolom <strong>Poin<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa jika Anda menghilangkan argumen <strong>ascending=False<\/strong> , baris akan diurutkan berdasarkan nilai di kolom <strong>titik<\/strong> dalam urutan menaik:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#sort pivot table by value in 'points' column in ascending order\n<\/span>sorted_df_pivot = df_pivot. <span style=\"color: #3366ff;\">sort_values<\/span> (by=[' <span style=\"color: #ff0000;\">points<\/span> '])\n\n<span style=\"color: #008080;\">#view sorted pivot table\n<\/span><span style=\"color: #008000;\">print<\/span> (sorted_df_pivot)\n\n      assist points\nteam                 \nAt 14 18\nC 25 23\nB 19 26\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa baris PivotTable kini diurutkan berdasarkan nilai kolom <strong>titik<\/strong> dalam urutan menaik (terkecil hingga terbesar).<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan #1:<\/strong> Anda juga dapat mengurutkan beberapa kolom dalam tabel pivot dengan meneruskan beberapa nilai ke argumen <strong>by<\/strong> dalam fungsi <strong>sort_values()<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan #2<\/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<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\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 dasar berikut untuk mengurutkan tabel pivot pandas berdasarkan nilai kolom: my_pivot_table. sort_values (by=[&#8216; some_column &#8216;], ascending= False ) Contoh khusus ini mengurutkan nilai tabel pivot yang disebut my_pivot_table berdasarkan nilai some_column dalam urutan menurun. Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh: Urutkan tabel pivot Pandas berdasarkan nilai di [&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 mengurutkan tabel pivot berdasarkan nilai dalam kolom - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengurutkan tabel pivot pandas berdasarkan nilai kolom tertentu, beserta 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\/mantra-tabel-pivot-panda\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara mengurutkan tabel pivot berdasarkan nilai dalam kolom - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengurutkan tabel pivot pandas berdasarkan nilai kolom tertentu, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/mantra-tabel-pivot-panda\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T14:49:31+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\/mantra-tabel-pivot-panda\/\",\"url\":\"https:\/\/statorials.org\/id\/mantra-tabel-pivot-panda\/\",\"name\":\"Pandas: Cara mengurutkan tabel pivot berdasarkan nilai dalam kolom - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T14:49:31+00:00\",\"dateModified\":\"2023-07-15T14:49:31+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengurutkan tabel pivot pandas berdasarkan nilai kolom tertentu, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/mantra-tabel-pivot-panda\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/mantra-tabel-pivot-panda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/mantra-tabel-pivot-panda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara mengurutkan tabel pivot berdasarkan nilai di kolom\"}]},{\"@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 mengurutkan tabel pivot berdasarkan nilai dalam kolom - Statorials","description":"Tutorial ini menjelaskan cara mengurutkan tabel pivot pandas berdasarkan nilai kolom tertentu, beserta 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\/mantra-tabel-pivot-panda\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara mengurutkan tabel pivot berdasarkan nilai dalam kolom - Statorials","og_description":"Tutorial ini menjelaskan cara mengurutkan tabel pivot pandas berdasarkan nilai kolom tertentu, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/mantra-tabel-pivot-panda\/","og_site_name":"Statorials","article_published_time":"2023-07-15T14:49:31+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\/mantra-tabel-pivot-panda\/","url":"https:\/\/statorials.org\/id\/mantra-tabel-pivot-panda\/","name":"Pandas: Cara mengurutkan tabel pivot berdasarkan nilai dalam kolom - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T14:49:31+00:00","dateModified":"2023-07-15T14:49:31+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengurutkan tabel pivot pandas berdasarkan nilai kolom tertentu, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/mantra-tabel-pivot-panda\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/mantra-tabel-pivot-panda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/mantra-tabel-pivot-panda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara mengurutkan tabel pivot berdasarkan nilai di kolom"}]},{"@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\/3777"}],"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=3777"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3777\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3777"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3777"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3777"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}