{"id":982,"date":"2023-07-28T02:45:23","date_gmt":"2023-07-28T02:45:23","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-diurutkan-berdasarkan-tanggal\/"},"modified":"2023-07-28T02:45:23","modified_gmt":"2023-07-28T02:45:23","slug":"panda-diurutkan-berdasarkan-tanggal","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-diurutkan-berdasarkan-tanggal\/","title":{"rendered":"Cara mengurutkan dataframe pandas berdasarkan tanggal (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Seringkali Anda mungkin ingin mengurutkan pandas DataFrame berdasarkan kolom yang berisi tanggal. Untungnya, hal ini mudah dilakukan dengan menggunakan fungsi sort_values()<\/strong><\/a> .<\/span><\/p>\n

Tutorial ini menunjukkan beberapa contoh penggunaan praktis fungsi ini.<\/span><\/p>\n

Contoh 1: Urutkan berdasarkan kolom tanggal<\/strong><\/span><\/h3>\n

Misalkan kita memiliki panda DataFrame berikut:<\/span><\/p>\n

 import<\/span> pandas as<\/span> pd\n\n#createDataFrame<\/span>\ndf = pd.DataFrame({'sales': [4, 11, 13, 9],\n                   'customers': [2, 6, 9, 7],\n                   'date': ['2020-01-25', '2020-01-18', '2020-01-22', '2020-01-21']})\n\n#view DataFrame\n<\/span>print<\/span> (df)\n\n   sales customers date\n0 4 2 2020-01-25\n1 11 6 2020-01-18\n2 13 9 2020-01-22\n3 9 7 2020-01-21\n<\/strong><\/pre>\n
 Pertama, kita perlu menggunakan fungsi to_datetime()<\/strong> untuk mengubah kolom ‘date’ menjadi objek datetime:<\/span><\/p>\n
 df[' date<\/span> '] = pd. to_datetime<\/span> (df[' date<\/span> '])\n<\/strong><\/pre>\n
 Selanjutnya, kita dapat mengurutkan DataFrame berdasarkan kolom ‘tanggal’ menggunakan fungsi sort_values()<\/strong> :<\/span><\/p>\n
 df. sort_values<\/span> (by=' date<\/span> ')\n\n        sales customers date\n1 11 6 2020-01-18\n3 9 7 2020-01-21\n2 13 9 2020-01-22\n0 4 2 2020-01-25\n<\/strong><\/pre>\n
 Secara default, fungsi ini mengurutkan tanggal dalam urutan menaik. Namun, Anda dapat menentukan ascending=False<\/strong> untuk mengurutkan dalam urutan menurun:<\/span><\/p>\n
 df. sort_values<\/span> (by=' date<\/span> ', ascending= False<\/span> )\n\n\tsales customers date\n0 4 2 2020-01-25\n2 13 9 2020-01-22\n3 9 7 2020-01-21\n1 11 6 2020-01-18<\/strong><\/pre>\n
 Contoh 2: urutkan berdasarkan beberapa kolom tanggal<\/strong><\/span><\/h3>\n
 Misalkan kita memiliki panda DataFrame berikut:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#createDataFrame<\/span>\ndf = pd.DataFrame({'person': ['A', 'B', 'C', 'D'],\n                   'order_date': ['2020-01-15', '2020-01-15', '2020-01-20', '2020-01-20'],\n                   'receive_date': ['2020-01-25', '2020-01-18', '2020-01-22', '2020-01-21']})\n\n#view DataFrame\n<\/span>print<\/span> (df)\n\n  person order_date receive_date\n0 A 2020-01-15 2020-01-25\n1 B 2020-01-15 2020-01-18\n2 C 2020-01-20 2020-01-22\n3 D 2020-01-20 2020-01-21<\/strong><\/pre>\n
 Kita dapat menggunakan fungsi sort_values<\/strong> untuk mengurutkan DataFrame pada beberapa kolom hanya dengan memberikan beberapa nama kolom ke fungsi tersebut:<\/span><\/p>\n
 #convert both date columns to datetime objects<\/span>\ndf[['order_date','receive_date']] = df[['order_date','receive_date']]. apply<\/span> (pd. to_datetime<\/span> )\n\n#sort DateFrame by order_date, then by receive_date\n<\/span>df. sort_values<\/span> (by=['order_date', 'receive_date'])\n\n        person order_date receive_date\n1 B 2020-01-15 2020-01-18\n0 A 2020-01-15 2020-01-25\n3 D 2020-01-20 2020-01-21\n2 C 2020-01-20 2020-01-22<\/strong><\/pre>\n
 DataFrame sekarang diurutkan dalam urutan menaik berdasarkan tanggal_pesanan, kemudian dalam urutan menaik berdasarkan tanggal_penerimaan.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Cara memfilter baris Pandas DataFrame berdasarkan tanggal
 Bagaimana cara mengonversi DateTime ke tanggal di Pandas<\/a>
 Cara mengonversi kolom menjadi DateTime di Pandas<\/a>
 Cara mengurutkan berdasarkan indeks dan kolom di Pandas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Seringkali Anda mungkin ingin mengurutkan pandas DataFrame berdasarkan kolom yang berisi tanggal. Untungnya, hal ini mudah dilakukan dengan menggunakan fungsi sort_values() . Tutorial ini menunjukkan beberapa contoh penggunaan praktis fungsi ini. Contoh 1: Urutkan berdasarkan kolom tanggal Misalkan kita memiliki panda DataFrame berikut: import pandas as pd #createDataFrame df = pd.DataFrame({‘sales’: [4, 11, 13, 9], […]<\/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":"\nCara Mengurutkan DataFrame Pandas berdasarkan Tanggal (dengan Contoh)<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana tentang cara mengurutkan pandas DataFrame berdasarkan kolom tanggal, termasuk 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-diurutkan-berdasarkan-tanggal\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mengurutkan DataFrame Pandas berdasarkan Tanggal (dengan Contoh)\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana tentang cara mengurutkan pandas DataFrame berdasarkan kolom tanggal, termasuk beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-diurutkan-berdasarkan-tanggal\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T02:45: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-diurutkan-berdasarkan-tanggal\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-diurutkan-berdasarkan-tanggal\/\",\"name\":\"Cara Mengurutkan DataFrame Pandas berdasarkan Tanggal (dengan Contoh)\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T02:45:23+00:00\",\"dateModified\":\"2023-07-28T02:45:23+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana tentang cara mengurutkan pandas DataFrame berdasarkan kolom tanggal, termasuk beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-diurutkan-berdasarkan-tanggal\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-diurutkan-berdasarkan-tanggal\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-diurutkan-berdasarkan-tanggal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengurutkan dataframe pandas berdasarkan tanggal (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 Mengurutkan DataFrame Pandas berdasarkan Tanggal (dengan Contoh)","description":"Penjelasan sederhana tentang cara mengurutkan pandas DataFrame berdasarkan kolom tanggal, termasuk 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-diurutkan-berdasarkan-tanggal\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mengurutkan DataFrame Pandas berdasarkan Tanggal (dengan Contoh)","og_description":"Penjelasan sederhana tentang cara mengurutkan pandas DataFrame berdasarkan kolom tanggal, termasuk beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/panda-diurutkan-berdasarkan-tanggal\/","og_site_name":"Statorials","article_published_time":"2023-07-28T02:45: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-diurutkan-berdasarkan-tanggal\/","url":"https:\/\/statorials.org\/id\/panda-diurutkan-berdasarkan-tanggal\/","name":"Cara Mengurutkan DataFrame Pandas berdasarkan Tanggal (dengan Contoh)","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T02:45:23+00:00","dateModified":"2023-07-28T02:45:23+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana tentang cara mengurutkan pandas DataFrame berdasarkan kolom tanggal, termasuk beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-diurutkan-berdasarkan-tanggal\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-diurutkan-berdasarkan-tanggal\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-diurutkan-berdasarkan-tanggal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengurutkan dataframe pandas berdasarkan tanggal (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\/982"}],"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=982"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/982\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=982"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=982"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=982"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}