{"id":3028,"date":"2023-07-19T13:53:40","date_gmt":"2023-07-19T13:53:40","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-mengurutkan-berdasarkan-abjad\/"},"modified":"2023-07-19T13:53:40","modified_gmt":"2023-07-19T13:53:40","slug":"panda-mengurutkan-berdasarkan-abjad","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-mengurutkan-berdasarkan-abjad\/","title":{"rendered":"Pandas: cara mengurutkan dataframes berdasarkan abjad"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut untuk mengurutkan baris pandas DataFrame berdasarkan abjad:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Urutkan berdasarkan kolom menurut abjad<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#sort A to Z<\/span>\ndf. <span style=\"color: #3366ff;\">sort_values<\/span> (' <span style=\"color: #ff0000;\">column1<\/span> ')\n<span style=\"color: #008080;\">\n#sort Z to A<\/span>\ndf. <span style=\"color: #3366ff;\">sort_values<\/span> (' <span style=\"color: #ff0000;\">column1<\/span> ', ascending= <span style=\"color: #008000;\">False <span style=\"color: #000000;\">)<\/span><\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Urutkan berdasarkan beberapa kolom menurut abjad<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#sort by column1 from Z to A, then by column2 from A to Z<\/span>\ndf. <span style=\"color: #3366ff;\">sort_values<\/span> ([' <span style=\"color: #ff0000;\">column1<\/span> ', ' <span style=\"color: #ff0000;\">column2<\/span> '], ascending=( <span style=\"color: #008000;\">False<\/span> , <span style=\"color: #008000;\">True<\/span> ))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap metode dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Urutkan berdasarkan kolom menurut abjad<\/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> ': ['Mavs', 'Spurs', 'Lakers', 'Nuggets', 'Hawks'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [120, 108, 99, 104, 115]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n      team points\n0 Mavs 120\n1 Spurs 108\n2 Lakers 99\n3 Nuggets 104\n4 Hawks 115<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk mengurutkan baris DataFrame berdasarkan nama tim dari <strong>A sampai Z<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#sort by team name A to Z<span style=\"color: #000000;\">\ndf_sorted = df. <span style=\"color: #3366ff;\">sort_values<\/span> (' <span style=\"color: #ff0000;\">team<\/span> ')\n\n<span style=\"color: #008080;\">#view sorted DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df_sorted)\n\n      team points\n4 Hawks 115\n2 Lakers 99\n0 Mavs 120\n3 Nuggets 104\n1 Spurs 108<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa baris sekarang diurutkan berdasarkan nama tim AZ.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita juga bisa mengurutkan dari <strong>Z ke A<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#sort by team name Z to A<span style=\"color: #000000;\">\ndf_sorted = df. <span style=\"color: #3366ff;\">sort_values<\/span> (' <span style=\"color: #ff0000;\">team<\/span> ', ascending= <span style=\"color: #008000;\">False<\/span> )\n\n<span style=\"color: #008080;\">#view sorted DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df_sorted)\n\n      team points\n1 Spurs 108\n3 Nuggets 104\n0 Mavs 120\n2 Lakers 99\n4 Hawks 115<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Dan kita juga bisa menggunakan fungsi <strong>reset_index()<\/strong> untuk mengatur ulang nilai indeks dalam DataFrame yang diurutkan:<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#sort by team name A to Z and reset index<span style=\"color: #000000;\">\ndf_sorted = df. <span style=\"color: #3366ff;\">sort_values<\/span> (' <span style=\"color: #ff0000;\">team<\/span> '). <span style=\"color: #3366ff;\">reset_index<\/span> (drop= <span style=\"color: #008000;\">True<\/span> )\n\n<span style=\"color: #008080;\">#view sorted DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df_sorted)\n\n      team points\n0 Hawks 115\n1 Lakers 99\n2 Mavs 120\n3 Nuggets 104\n4 Spurs 108\n<\/span><\/span><\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Urutkan berdasarkan beberapa kolom berdasarkan abjad<\/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;\"> <span style=\"color: #000000;\"><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;\">conference<\/span> ': ['West', 'West', 'West', 'East', 'East'],\n                   ' <span style=\"color: #ff0000;\">team<\/span> ': ['Mavs', 'Spurs', 'Lakers', 'Heat', 'Hawks'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [120, 108, 99, 104, 115]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n  conference team points\n0 West Mavs 120\n1 West Spurs 108\n2 West Lakers 99\n3 East Heat 104\n4 East Hawks 115\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Sintaks berikut dapat digunakan untuk mengurutkan baris DataFrame berdasarkan nama konferensi dari A hingga Z, lalu berdasarkan nama tim dari Z ke A:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#sort by conference name A to Z, then by team name Z to A<span style=\"color: #000000;\">\ndf_sorted = df. <span style=\"color: #3366ff;\">sort_values<\/span> ([' <span style=\"color: #ff0000;\">conference<\/span> ', ' <span style=\"color: #ff0000;\">team<\/span> '], ascending=( <span style=\"color: #008000;\">True<\/span> , <span style=\"color: #008000;\">False<\/span> ))\n\n<span style=\"color: #008080;\">#view sorted DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df_sorted)\n\n  conference team points\n3 East Heat 104\n4 East Hawks 115\n1 West Spurs 108\n0 West Mavs 120\n2 West Lakers 99\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Baris diurutkan berdasarkan nama konferensi AZ, kemudian berdasarkan nama tim ZA.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi pandas <strong>sort_values()<\/strong> <a href=\"https:\/\/pandas.pydata.org\/docs\/reference\/api\/pandas.DataFrame.sort_values.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\/panda-diurutkan-berdasarkan-tanggal\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara mengurutkan berdasarkan tanggal<\/a><br \/> <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-mengurutkan-berdasarkan-indeks-dan-kolom\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara mengurutkan berdasarkan indeks dan kolom<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode berikut untuk mengurutkan baris pandas DataFrame berdasarkan abjad: Metode 1: Urutkan berdasarkan kolom menurut abjad #sort A to Z df. sort_values (&#8216; column1 &#8216;) #sort Z to A df. sort_values (&#8216; column1 &#8216;, ascending= False ) Metode 2: Urutkan berdasarkan beberapa kolom menurut abjad #sort by column1 from Z to A, [&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 DataFrames berdasarkan abjad \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengurutkan pandas DataFrame berdasarkan abjad, 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-abjad\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara mengurutkan DataFrames berdasarkan abjad \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengurutkan pandas DataFrame berdasarkan abjad, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-mengurutkan-berdasarkan-abjad\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-19T13:53:40+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-mengurutkan-berdasarkan-abjad\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-mengurutkan-berdasarkan-abjad\/\",\"name\":\"Pandas: Cara mengurutkan DataFrames berdasarkan abjad \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-19T13:53:40+00:00\",\"dateModified\":\"2023-07-19T13:53:40+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengurutkan pandas DataFrame berdasarkan abjad, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-mengurutkan-berdasarkan-abjad\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-mengurutkan-berdasarkan-abjad\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-mengurutkan-berdasarkan-abjad\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara mengurutkan dataframes berdasarkan abjad\"}]},{\"@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 DataFrames berdasarkan abjad \u2013 Statorial","description":"Tutorial ini menjelaskan cara mengurutkan pandas DataFrame berdasarkan abjad, 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-abjad\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara mengurutkan DataFrames berdasarkan abjad \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara mengurutkan pandas DataFrame berdasarkan abjad, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/panda-mengurutkan-berdasarkan-abjad\/","og_site_name":"Statorials","article_published_time":"2023-07-19T13:53:40+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-mengurutkan-berdasarkan-abjad\/","url":"https:\/\/statorials.org\/id\/panda-mengurutkan-berdasarkan-abjad\/","name":"Pandas: Cara mengurutkan DataFrames berdasarkan abjad \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-19T13:53:40+00:00","dateModified":"2023-07-19T13:53:40+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengurutkan pandas DataFrame berdasarkan abjad, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-mengurutkan-berdasarkan-abjad\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-mengurutkan-berdasarkan-abjad\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-mengurutkan-berdasarkan-abjad\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara mengurutkan dataframes berdasarkan abjad"}]},{"@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\/3028"}],"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=3028"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3028\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3028"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3028"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3028"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}