{"id":1700,"date":"2023-07-25T08:14:36","date_gmt":"2023-07-25T08:14:36","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-mengurutkan-berdasarkan-indeks-dan-kolom\/"},"modified":"2023-07-25T08:14:36","modified_gmt":"2023-07-25T08:14:36","slug":"panda-mengurutkan-berdasarkan-indeks-dan-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-mengurutkan-berdasarkan-indeks-dan-kolom\/","title":{"rendered":"Pandas: urutkan dataframe berdasarkan indeks dan kolom"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk mengurutkan pandas DataFrame berdasarkan indeks dan kolom:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df = df. <span style=\"color: #3366ff;\">sort_values<\/span> (by = [' <span style=\"color: #ff0000;\">column_name<\/span> ', ' <span style=\"color: #ff0000;\">index<\/span> '], ascending = [ <span style=\"color: #008000;\">False<\/span> , <span style=\"color: #008000;\">True<\/span> ])\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h3> <strong>Contoh: mengurutkan DataFrame berdasarkan indeks dan kolom<\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mengurutkan pandas DataFrame berdasarkan kolom bernama <strong>poin<\/strong> dan kemudian berdasarkan kolom <strong>indeks<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #107d3f;\">import<\/span> pandas <span style=\"color: #107d3f;\">as<\/span> pd\n\n<span style=\"color: #008080;\">#createDataFrame<\/span>\ndf = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">id<\/span> ': [1, 2, 3, 4, 5, 6, 7, 8],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [25, 15, 15, 14, 20, 20, 25, 29],\n                   ' <span style=\"color: #ff0000;\">assists<\/span> ': [5, 7, 7, 9, 12, 9, 9, 4],\n                   ' <span style=\"color: #ff0000;\">rebounds<\/span> ': [11, 8, 10, 6, 6, 5, 9, 12]}). <span style=\"color: #3366ff;\">set_index<\/span> (' <span style=\"color: #ff0000;\">id<\/span> ')\n\n<span style=\"color: #008080;\">#view first few rows\n<\/span>df. <span style=\"color: #3366ff;\">head<\/span> ()\n\n\tpoints assists rebounds\nid\t\t\t\n1 25 5 11\n2 15 7 8\n3 15 7 10\n4 14 9 6\n5 20 12 6\n\n<span style=\"color: #008080;\">#sort by points and then by index<\/span>\ndf. <span style=\"color: #3366ff;\">sort_values<\/span> (by = [' <span style=\"color: #ff0000;\">points<\/span> ', ' <span style=\"color: #ff0000;\">id<\/span> '], ascending = [ <span style=\"color: #008000;\">False<\/span> , <span style=\"color: #008000;\">True<\/span> ])\n\n\tpoints assists rebounds\nid\t\t\t\n8 29 4 12\n1 25 5 11\n7 25 9 9\n5 20 12 6\n6 20 9 5\n2 15 7 8\n3 15 7 10\n4 14 9 6\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">DataFrame yang dihasilkan diurutkan berdasarkan poin dalam urutan menurun kemudian berdasarkan indeks dalam urutan menaik (jika ada dua pemain yang mencetak jumlah poin yang sama).<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa jika kita tidak menggunakan argumen <strong>ascending<\/strong> , maka setiap kolom akan menggunakan urutan ascending sebagai metode pengurutan default:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#sort by points and then by index<\/span>\ndf. <span style=\"color: #3366ff;\">sort_values<\/span> (by = [' <span style=\"color: #ff0000;\">points<\/span> ', ' <span style=\"color: #ff0000;\">id<\/span> '])\n\n        points assists rebounds\nid\t\t\t\n4 14 9 6\n2 15 7 8\n3 15 7 10\n5 20 12 6\n6 20 9 5\n1 25 5 11\n7 25 9 9\n8 29 4 12\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Jika kolom indeks saat ini tidak disebutkan namanya, Anda dapat mengganti namanya lalu mengurutkannya sesuai:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#sort by points and then by index<\/span>\ndf. <span style=\"color: #3366ff;\">rename_axis<\/span> (' <span style=\"color: #ff0000;\">index<\/span> '). <span style=\"color: #3366ff;\">sort_values<\/span> (by = [' <span style=\"color: #ff0000;\">points<\/span> ', ' <span style=\"color: #ff0000;\">id<\/span> '])\n\n        points assists rebounds\nid\t\t\t\n4 14 9 6\n2 15 7 8\n3 15 7 10\n5 20 12 6\n6 20 9 5\n1 25 5 11\n7 25 9 9\n8 29 4 12<\/strong><\/pre>\n<h3> <strong>Sumber daya tambahan<\/strong><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/panda-mengurutkan-kolom-berdasarkan-nama\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara mengurutkan kolom berdasarkan nama<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-diurutkan-berdasarkan-tanggal\/\" target=\"_blank\" rel=\"noopener\">Pandas: urutkan DataFrame berdasarkan tanggal<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-menjatuhkan-duplikat\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara menghapus baris duplikat<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk mengurutkan pandas DataFrame berdasarkan indeks dan kolom: df = df. sort_values (by = [&#8216; column_name &#8216;, &#8216; index &#8216;], ascending = [ False , True ]) Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh: mengurutkan DataFrame berdasarkan indeks dan kolom Kode berikut menunjukkan cara mengurutkan pandas DataFrame [&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: urutkan DataFrame berdasarkan indeks dan kolom<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengurutkan pandas DataFrame berdasarkan indeks dan kolom, 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-mengurutkan-berdasarkan-indeks-dan-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: urutkan DataFrame berdasarkan indeks dan kolom\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengurutkan pandas DataFrame berdasarkan indeks dan kolom, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-mengurutkan-berdasarkan-indeks-dan-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-25T08:14:36+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\/panda-mengurutkan-berdasarkan-indeks-dan-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-mengurutkan-berdasarkan-indeks-dan-kolom\/\",\"name\":\"Pandas: urutkan DataFrame berdasarkan indeks dan kolom\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-25T08:14:36+00:00\",\"dateModified\":\"2023-07-25T08:14:36+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengurutkan pandas DataFrame berdasarkan indeks dan kolom, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-mengurutkan-berdasarkan-indeks-dan-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-mengurutkan-berdasarkan-indeks-dan-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-mengurutkan-berdasarkan-indeks-dan-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: urutkan dataframe berdasarkan indeks dan 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: urutkan DataFrame berdasarkan indeks dan kolom","description":"Tutorial ini menjelaskan cara mengurutkan pandas DataFrame berdasarkan indeks dan kolom, 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-mengurutkan-berdasarkan-indeks-dan-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: urutkan DataFrame berdasarkan indeks dan kolom","og_description":"Tutorial ini menjelaskan cara mengurutkan pandas DataFrame berdasarkan indeks dan kolom, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/panda-mengurutkan-berdasarkan-indeks-dan-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-25T08:14:36+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\/panda-mengurutkan-berdasarkan-indeks-dan-kolom\/","url":"https:\/\/statorials.org\/id\/panda-mengurutkan-berdasarkan-indeks-dan-kolom\/","name":"Pandas: urutkan DataFrame berdasarkan indeks dan kolom","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-25T08:14:36+00:00","dateModified":"2023-07-25T08:14:36+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengurutkan pandas DataFrame berdasarkan indeks dan kolom, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-mengurutkan-berdasarkan-indeks-dan-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-mengurutkan-berdasarkan-indeks-dan-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-mengurutkan-berdasarkan-indeks-dan-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: urutkan dataframe berdasarkan indeks dan 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\/1700"}],"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=1700"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1700\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1700"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1700"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1700"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}