{"id":7305,"date":"2024-03-14T05:20:58","date_gmt":"2024-03-14T05:20:58","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-specify-index-order-in-python\/"},"modified":"2025-08-02T14:30:06","modified_gmt":"2025-08-02T14:30:06","slug":"how-to-specify-index-order-in-python","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-specify-index-order-in-python\/","title":{"rendered":"Python sort_index(): Order DataFrame Index"},"content":{"rendered":"<p>In Python, you can specify the order of the index by using the sort_index() method. This method takes an ascending parameter where setting it to True will sort the index in ascending order and setting it to False will sort the index in descending order.<\/p>\n<p>The following is an example code:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">import<\/span> pandas <span class=\"hljs-keyword\">as<\/span> pd\r\n\r\n<span class=\"hljs-comment\"># \u521b\u5efa\u4e00\u4e2aDataFrame<\/span>\r\ndata = {<span class=\"hljs-string\">'A'<\/span>: [<span class=\"hljs-number\">1<\/span>, <span class=\"hljs-number\">2<\/span>, <span class=\"hljs-number\">3<\/span>], <span class=\"hljs-string\">'B'<\/span>: [<span class=\"hljs-number\">4<\/span>, <span class=\"hljs-number\">5<\/span>, <span class=\"hljs-number\">6<\/span>]}\r\ndf = pd.DataFrame(data, index=[<span class=\"hljs-string\">'c'<\/span>, <span class=\"hljs-string\">'a'<\/span>, <span class=\"hljs-string\">'b'<\/span>])\r\n\r\n<span class=\"hljs-comment\"># \u6309\u7d22\u5f15\u5347\u5e8f\u6392\u5e8f<\/span>\r\ndf_sorted_ascending = df.sort_index(ascending=<span class=\"hljs-literal\">True<\/span>)\r\n<span class=\"hljs-built_in\">print<\/span>(<span class=\"hljs-string\">\"\u6309\u7d22\u5f15\u5347\u5e8f\u6392\u5e8f\uff1a\"<\/span>)\r\n<span class=\"hljs-built_in\">print<\/span>(df_sorted_ascending)\r\n\r\n<span class=\"hljs-comment\"># \u6309\u7d22\u5f15\u964d\u5e8f\u6392\u5e8f<\/span>\r\ndf_sorted_descending = df.sort_index(ascending=<span class=\"hljs-literal\">False<\/span>)\r\n<span class=\"hljs-built_in\">print<\/span>(<span class=\"hljs-string\">\"\\n\u6309\u7d22\u5f15\u964d\u5e8f\u6392\u5e8f\uff1a\"<\/span>)\r\n<span class=\"hljs-built_in\">print<\/span>(df_sorted_descending)\r\n<\/code><\/pre>\n<p>Running the above code will sort the DataFrame in ascending and descending order based on the index, respectively.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Python, you can specify the order of the index by using the sort_index() method. This method takes an ascending parameter where setting it to True will sort the index in ascending order and setting it to False will sort the index in descending order. The following is an example code: import pandas as pd [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[1096,9319,1094,72,9318],"class_list":["post-7305","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-dataframe","tag-index-sorting","tag-pandas","tag-python","tag-sort_index"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Python sort_index(): Order DataFrame Index - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to use sort_index() in pandas to control DataFrame index order. Examples for ascending and descending sorting in Python.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-to-specify-index-order-in-python\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Python sort_index(): Order DataFrame Index\" \/>\n<meta property=\"og:description\" content=\"Learn how to use sort_index() in pandas to control DataFrame index order. Examples for ascending and descending sorting in Python.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-specify-index-order-in-python\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T05:20:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-02T14:30:06+00:00\" \/>\n<meta name=\"author\" content=\"Ava Mitchell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ava Mitchell\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-specify-index-order-in-python\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-specify-index-order-in-python\/\"},\"author\":{\"name\":\"Ava Mitchell\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64\"},\"headline\":\"Python sort_index(): Order DataFrame Index\",\"datePublished\":\"2024-03-14T05:20:58+00:00\",\"dateModified\":\"2025-08-02T14:30:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-specify-index-order-in-python\/\"},\"wordCount\":76,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"DataFrame\",\"index sorting\",\"pandas\",\"Python\",\"sort_index\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-specify-index-order-in-python\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-specify-index-order-in-python\/\",\"name\":\"Python sort_index(): Order DataFrame Index - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T05:20:58+00:00\",\"dateModified\":\"2025-08-02T14:30:06+00:00\",\"description\":\"Learn how to use sort_index() in pandas to control DataFrame index order. Examples for ascending and descending sorting in Python.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-specify-index-order-in-python\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-specify-index-order-in-python\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-specify-index-order-in-python\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Python sort_index(): Order DataFrame Index\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64\",\"name\":\"Ava Mitchell\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"caption\":\"Ava Mitchell\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Python sort_index(): Order DataFrame Index - Blog - Silicon Cloud","description":"Learn how to use sort_index() in pandas to control DataFrame index order. Examples for ascending and descending sorting in Python.","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:\/\/www.silicloud.com\/blog\/how-to-specify-index-order-in-python\/","og_locale":"en_US","og_type":"article","og_title":"Python sort_index(): Order DataFrame Index","og_description":"Learn how to use sort_index() in pandas to control DataFrame index order. Examples for ascending and descending sorting in Python.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-specify-index-order-in-python\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T05:20:58+00:00","article_modified_time":"2025-08-02T14:30:06+00:00","author":"Ava Mitchell","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Ava Mitchell","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-specify-index-order-in-python\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-specify-index-order-in-python\/"},"author":{"name":"Ava Mitchell","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64"},"headline":"Python sort_index(): Order DataFrame Index","datePublished":"2024-03-14T05:20:58+00:00","dateModified":"2025-08-02T14:30:06+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-specify-index-order-in-python\/"},"wordCount":76,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["DataFrame","index sorting","pandas","Python","sort_index"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-specify-index-order-in-python\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-specify-index-order-in-python\/","name":"Python sort_index(): Order DataFrame Index - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T05:20:58+00:00","dateModified":"2025-08-02T14:30:06+00:00","description":"Learn how to use sort_index() in pandas to control DataFrame index order. Examples for ascending and descending sorting in Python.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-specify-index-order-in-python\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-specify-index-order-in-python\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-specify-index-order-in-python\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Python sort_index(): Order DataFrame Index"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64","name":"Ava Mitchell","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","caption":"Ava Mitchell"},"url":"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/7305","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=7305"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/7305\/revisions"}],"predecessor-version":[{"id":152080,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/7305\/revisions\/152080"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=7305"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=7305"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=7305"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}