{"id":56381,"date":"2019-05-21T17:16:11","date_gmt":"2019-05-21T11:46:11","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=56381"},"modified":"2019-05-21T17:16:47","modified_gmt":"2019-05-21T11:46:47","slug":"sort-pandas-dataframes-series-array","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/sort-pandas-dataframes-series-array\/","title":{"rendered":"Easy Steps to Sort Pandas DataFrames, Series, Arrays with Examples"},"content":{"rendered":"<div class='__iawmlf-post-loop-links' style='display:none;' data-iawmlf-post-links='[{&quot;id&quot;:1559,&quot;href&quot;:&quot;https:\\\/\\\/pandas.pydata.org\\\/pandas-docs\\\/version\\\/0.19\\\/generated\\\/pandas.DataFrame.sort.html&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20250710203432\\\/https:\\\/\\\/pandas.pydata.org\\\/pandas-docs\\\/version\\\/0.19\\\/generated\\\/pandas.DataFrame.sort.html&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-09 11:09:11&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-13 12:14:39&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-23 03:16:17&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-04 16:39:07&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-20 10:49:53&quot;,&quot;http_code&quot;:404},{&quot;date&quot;:&quot;2026-04-29 18:43:23&quot;,&quot;http_code&quot;:404},{&quot;date&quot;:&quot;2026-06-12 19:02:38&quot;,&quot;http_code&quot;:404}],&quot;broken&quot;:true,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-06-12 19:02:38&quot;,&quot;http_code&quot;:404},&quot;process&quot;:&quot;done&quot;}]'><\/div>\n<p>Sorting refers to the<em> act of arranging the items systematically and the sequence is decided by some or the other criterion<\/em>. In this Python Sorting tutorial, we are going to learn how to sort Pandas Dataframes, Series and array by rows and columns with examples.<\/p>\n<h2>1. Pandas Sorting<\/h2>\n<p>Sorting is not something exclusive to Pandas only. It is one of the most common algorithms one uses in coding and is generally linked with structures like an array or in our case, Series and DataFrames.<\/p>\n<h2>2. Parameters used in Pandas Sorting<\/h2>\n<p>Before starting to sort, let us get to know the parameters involved in sorting:<\/p>\n<p>1. <strong>columns<\/strong>: You have to pass an object.\u00a0You have to pass the column name or names.<\/p>\n<p>2. <strong>ascending<\/strong>: You have to pass a Boolean value. The default value is True.\u00a0This decides whether it gets sorted in the descending or the ascending order.<\/p>\n<p>3. <strong>axis<\/strong>: You can pass 0 or 1; or \u2018index\u2019 or \u2018columns\u2019 for index and columns\u00a0respectively. The default value is 0.\u00a0This decides whether you sort by index or columns.<\/p>\n<p><strong>4. inplace:<\/strong> You pass a Boolean value. The default value is false.\u00a0This does not create a new instance while sorting the DataFrame.<\/p>\n<p><strong>5. kind: \u2018<\/strong>heapsport\u2019, \u2018mergesport\u2019, \u2018quicksort\u2019.\u00a0This is optional and is to be applied only when you sort a single column or labels.<\/p>\n<p>6<strong>. na_position:<\/strong> \u2018first\u2019, \u2018last\u2019. The default optional is \u2018last\u2019.\u00a0Quite expectedly, \u2018first\u2019 puts NaNs at the beginning, while \u2018last\u2019 puts NaNs at the end.<\/p>\n<p><strong>It&#8217;s the right time to learn<\/strong> &#8211; <strong><a href=\"https:\/\/data-flair.training\/blogs\/basic-functionality-in-pandas\/\">4 Basic Functionalities Used by Data Scientists<\/a><\/strong><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-in-pandas.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-56420\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-in-pandas.jpg\" alt=\"How to sort Dataframes in Pandas\" width=\"802\" height=\"420\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-in-pandas.jpg 802w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-in-pandas-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-in-pandas-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-in-pandas-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-in-pandas-520x272.jpg 520w\" sizes=\"auto, (max-width: 802px) 100vw, 802px\" \/><\/a><\/p>\n<h2>3. How to Sort Arrays with Pandas?<\/h2>\n<p>Before we start sorting, let&#8217;s create a NumPy array-<\/p>\n<h3>3.1. Creating a NumPy Array<\/h3>\n<p>For creating a NumPy array, you will have to import NumPy.<\/p>\n<p>Type:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&gt;&gt;&gt;import pandas as pd\r\n&gt;&gt;&gt;import numpy as np<\/pre>\n<p>NumPy arrays can be constructed directly via the numpy.array constructor.<\/p>\n<p>For creating a <strong>1-dimensional array<\/strong>, type:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&gt;&gt;&gt;dataflair_ar1=np.array([4,5,6,7])<\/pre>\n<p>For creating a <strong>2-dimensional array<\/strong>, type:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&gt;&gt;&gt; dataflair_ar2=np.array ([[4,5,6],[7,8,9]])<\/pre>\n<p>After initializing both these arrays, when you access them, the output will be:<\/p>\n<p><strong>Output-<\/strong><\/p>\n<p>array([4,5,6,7]) <strong>#1D<\/strong><br \/>\narray([[4,5,6],<br \/>\n[7,8,9]]) <strong>#2D<\/strong><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Array-in-Pandas.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-56416\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Array-in-Pandas.png\" alt=\"Sorting of Arrays with Pandas\" width=\"1366\" height=\"627\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Array-in-Pandas.png 1366w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Array-in-Pandas-150x69.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Array-in-Pandas-300x138.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Array-in-Pandas-768x353.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Array-in-Pandas-1024x470.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Array-in-Pandas-980x450.png 980w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Array-in-Pandas-520x239.png 520w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><\/a><\/p>\n<h3>3.2 How to Sort 1D array in Pandas?<\/h3>\n<p>We create an unsorted 1D array:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&gt;&gt;&gt; dataflair_ar3=np.array([5,9,7])\r\n&gt;&gt;&gt; dataflair_ar3.sort()\r\n&gt;&gt;&gt; dataflair_ar3<\/pre>\n<p>The <strong>output<\/strong> is:<\/p>\n<p>array([5,7,9])<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-1d-Array-in-Pandas.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-56417\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-1d-Array-in-Pandas.png\" alt=\"How to Sort One Dimensional Array in Pandas\" width=\"1366\" height=\"576\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-1d-Array-in-Pandas.png 1366w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-1d-Array-in-Pandas-150x63.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-1d-Array-in-Pandas-300x127.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-1d-Array-in-Pandas-768x324.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-1d-Array-in-Pandas-1024x432.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-1d-Array-in-Pandas-520x219.png 520w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><\/a><\/p>\n<h3>3.3 How to Sort 2D Array in Pandas?<\/h3>\n<p>We create a 2D array are as:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&gt;&gt;&gt; dataflair_ar4=np.array([[9,8],[11,0]])<\/pre>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/pandas-library-architecture\/\">Do you know the File Hierarchy in Pandas?<\/a><\/strong><\/p>\n<p><strong>3.3.1 First we sort it along X axis:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&gt;&gt;&gt;&gt;\u00a0dataflair_ar4=np.array([[9,8],[11,0]])\r\n&gt;&gt;&gt; dataflair_ar4.sort(axis=0)\r\n&gt;&gt;&gt; dataflair_ar4<\/pre>\n<p>The <strong>output<\/strong> is:<\/p>\n<p>array([[ 9, 0],<br \/>\n[11,8]])<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-2D-array-on-X-axis-in-Pandas.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-56418\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-2D-array-on-X-axis-in-Pandas.png\" alt=\"How to sort 2D array on X axis \" width=\"1366\" height=\"601\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-2D-array-on-X-axis-in-Pandas.png 1366w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-2D-array-on-X-axis-in-Pandas-150x66.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-2D-array-on-X-axis-in-Pandas-300x132.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-2D-array-on-X-axis-in-Pandas-768x338.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-2D-array-on-X-axis-in-Pandas-1024x451.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-2D-array-on-X-axis-in-Pandas-520x229.png 520w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><\/a><\/p>\n<p><strong>3.3.2\u00a0Now we sort it along Y axis:<\/strong><\/p>\n<p>We recreate the 2D array a4 as:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&gt;&gt;&gt; dataflair_ar4=np.array([[9,8],[11,0]])\r\n&gt;&gt;&gt; dataflair_ar4.sort(axis=1)\r\n&gt;&gt;&gt; dataflair_ar4<\/pre>\n<p>The <strong>output<\/strong> is:<\/p>\n<p>array([[ 8, 9],<br \/>\n[0,11]])<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-2D-Array-in-Y-axis-in-Pandas-.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-56419\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-2D-Array-in-Y-axis-in-Pandas-.png\" alt=\"Sorting of 2D array in Pandas\" width=\"1366\" height=\"578\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-2D-Array-in-Y-axis-in-Pandas-.png 1366w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-2D-Array-in-Y-axis-in-Pandas--150x63.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-2D-Array-in-Y-axis-in-Pandas--300x127.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-2D-Array-in-Y-axis-in-Pandas--768x325.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-2D-Array-in-Y-axis-in-Pandas--1024x433.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-2D-Array-in-Y-axis-in-Pandas--520x220.png 520w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><\/a><\/p>\n<h2>4. How to Sort a Series with Pandas?<\/h2>\n<p>Before we start Pandas Sorting, let&#8217;s create a series-<\/p>\n<h3>4.1 Creating a Series in Pandas<\/h3>\n<p>Create a series by the following code:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&gt;&gt;&gt; dataflair_se = pd.Series([np.nan, 3, 7, 11, 8])<\/pre>\n<p>The <strong>output<\/strong> will be:<\/p>\n<p>0\u00a0 \u00a0NaN<br \/>\n1\u00a0 \u00a0 3.0<br \/>\n2\u00a0 \u00a0 7.0<br \/>\n3\u00a0 \u00a0 11.0<br \/>\n4\u00a0 \u00a0 \u00a08.0<br \/>\ndtype:\u00a0 \u00a0float64<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Creating-a-Series-in-Pandas.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-56422\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Creating-a-Series-in-Pandas.png\" alt=\"How to Create Pandas Series\" width=\"1366\" height=\"658\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Creating-a-Series-in-Pandas.png 1366w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Creating-a-Series-in-Pandas-150x72.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Creating-a-Series-in-Pandas-300x145.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Creating-a-Series-in-Pandas-768x370.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Creating-a-Series-in-Pandas-1024x493.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Creating-a-Series-in-Pandas-520x250.png 520w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><\/a><\/p>\n<h3>4.2 How to Sort a Series in Pandas?<\/h3>\n<h4>4.2.1 Sorting a Pandas Series in an ascending order<\/h4>\n<p>The following syntax enables us to sort the series in ascending order:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&gt;&gt;&gt; dataflair_se.sort_values(ascending=True)<\/pre>\n<p>The <strong>output<\/strong> is:<\/p>\n<p>1\u00a0 \u00a0 \u00a0 \u00a03.0<br \/>\n2\u00a0 \u00a0 \u00a0 \u00a07.0<br \/>\n4\u00a0 \u00a0 \u00a0 \u00a08.0<br \/>\n3\u00a0 \u00a0 \u00a0 11.0<br \/>\n0\u00a0 \u00a0 \u00a0 \u00a0NaN<br \/>\ndtype: float64<br \/>\n<a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-a-Pandas-Series-in-an-ascending-order.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-56425\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-a-Pandas-Series-in-an-ascending-order.png\" alt=\"Sorting a series in an ascending order\" width=\"1366\" height=\"656\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-a-Pandas-Series-in-an-ascending-order.png 1366w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-a-Pandas-Series-in-an-ascending-order-150x72.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-a-Pandas-Series-in-an-ascending-order-300x144.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-a-Pandas-Series-in-an-ascending-order-768x369.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-a-Pandas-Series-in-an-ascending-order-1024x492.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-a-Pandas-Series-in-an-ascending-order-520x250.png 520w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><\/a><\/p>\n<h4>4.2.2 Sorting a Pandas Series in a descending order<\/h4>\n<p>The following syntax enables us to sort the series in ascending order:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&gt;&gt;&gt; dataflair_se.sort_values(ascending=False)<\/pre>\n<p>3\u00a0 \u00a011.0<br \/>\n4\u00a0 \u00a0 8.0<br \/>\n2\u00a0 \u00a0 7.0<br \/>\n1\u00a0 \u00a0 3.0<br \/>\n0\u00a0 \u00a0NaN<\/p>\n<p>dtype: float64<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sorting-in-descending-order.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-56430\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sorting-in-descending-order.png\" alt=\"Sorting of Series in descending order\" width=\"1364\" height=\"637\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sorting-in-descending-order.png 1364w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sorting-in-descending-order-150x70.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sorting-in-descending-order-300x140.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sorting-in-descending-order-768x359.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sorting-in-descending-order-1024x478.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sorting-in-descending-order-520x243.png 520w\" sizes=\"auto, (max-width: 1364px) 100vw, 1364px\" \/><\/a><\/p>\n<h4>4.2.3 Sorting values inplace<\/h4>\n<p>The following syntax enables us to sort the series inplace:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&gt;&gt;&gt; dataflair_se.sort_values(ascending=False, inplace=True)\r\n&gt;&gt;&gt; dataflair_se<\/pre>\n<p>The <strong>output<\/strong> is:<\/p>\n<p>3\u00a0 \u00a011.0<br \/>\n4\u00a0 \u00a0 8.0<br \/>\n2\u00a0 \u00a0 7.0<br \/>\n1\u00a0 \u00a0 3.0<br \/>\n0 NaN<br \/>\ndtype: float64<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-a-Pandas-Series-in-a-descending-order.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-56426 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-a-Pandas-Series-in-a-descending-order.png\" alt=\"Sorting values inplace\" width=\"1365\" height=\"628\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-a-Pandas-Series-in-a-descending-order.png 1365w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-a-Pandas-Series-in-a-descending-order-150x69.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-a-Pandas-Series-in-a-descending-order-300x138.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-a-Pandas-Series-in-a-descending-order-768x353.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-a-Pandas-Series-in-a-descending-order-1024x471.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-a-Pandas-Series-in-a-descending-order-980x450.png 980w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-a-Pandas-Series-in-a-descending-order-520x239.png 520w\" sizes=\"auto, (max-width: 1365px) 100vw, 1365px\" \/><\/a><\/p>\n<h4>4.2.4 Sorting values while putting Na first<\/h4>\n<p>The following syntax enables us to sort the series while putting Na first:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&gt;&gt;&gt; dataflair_se.sort_values(na_position='first')<\/pre>\n<p>Your <strong>output<\/strong> will be:<\/p>\n<p>0\u00a0 \u00a0 NaN<br \/>\n1\u00a0 \u00a0 3.0<br \/>\n2\u00a0 \u00a0 7.0<br \/>\n4\u00a0 \u00a0 8.0<br \/>\n3\u00a0 \u00a0 11.0<br \/>\ndtype: float64<br \/>\n<a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-values-by-NA-first.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-56431\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-values-by-NA-first.png\" alt=\"How to sort pandas series by NA first\" width=\"1366\" height=\"625\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-values-by-NA-first.png 1366w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-values-by-NA-first-150x69.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-values-by-NA-first-300x137.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-values-by-NA-first-768x351.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-values-by-NA-first-1024x469.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-values-by-NA-first-520x238.png 520w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><\/a><\/p>\n<h2>5. How to Sort a DataFrame with Pandas?<\/h2>\n<h3>5.1 Creating a DataFrame in Pandas<\/h3>\n<p>Create a DataFrame using the following code:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&gt;&gt;&gt; dataflair_df1 = pd.DataFrame({'col1' : [5, 2, 5, 2, 2, 1],'col2' : ['C', 'B', 'A', np.nan, 'C', 'D'],'col3': [9, 6, 0, 7, 5, 8]})\r\n&gt;&gt;&gt; dataflair_df1<\/pre>\n<p><strong>Output-<\/strong><\/p>\n<p>.\u00a0 \u00a0Col1\u00a0 \u00a0Col2\u00a0 \u00a0Col3<\/p>\n<p>0\u00a0 \u00a0 \u00a0 \u00a05\u00a0 \u00a0 \u00a0 \u00a0 C\u00a0 \u00a0 \u00a0 \u00a09<\/p>\n<p>1\u00a0 \u00a0 \u00a0 \u00a02\u00a0 \u00a0 \u00a0 \u00a0 B\u00a0 \u00a0 \u00a0 6<\/p>\n<p>2\u00a0 \u00a0 \u00a0 \u00a05\u00a0 \u00a0 \u00a0 \u00a0 A\u00a0 \u00a0 \u00a0 0<\/p>\n<p>3\u00a0 \u00a0 \u00a0 \u00a02\u00a0 \u00a0 \u00a0 NaN\u00a0 \u00a07<\/p>\n<p>4\u00a0 \u00a0 \u00a0 2\u00a0 \u00a0 \u00a0 \u00a0 C\u00a0 \u00a0 \u00a0 \u00a0 \u00a05<\/p>\n<p>5\u00a0 \u00a0 \u00a0 \u00a01\u00a0 \u00a0 \u00a0 D\u00a0 \u00a0 \u00a0 \u00a0 \u00a08<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Creating-a-dataframe-in-pandas.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-56432\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Creating-a-dataframe-in-pandas.png\" alt=\"How to create a Pandas Dataframe\" width=\"1366\" height=\"586\" \/><\/a><\/p>\n<h3>5.2 Sorting the DataFrame<\/h3>\n<h4>5.2.1 How to Sort Pandas DataFrames in Ascending Order?<\/h4>\n<p>We\u2019ll see that pandas sorts DataFrame in the ascending order by default.<\/p>\n<p>When we have to <strong>sort by a single column,<\/strong> we type:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&gt;&gt;&gt; dataflair_df1.sort_values(by=['col1'])<\/pre>\n<p>The <strong>output<\/strong>, as shown on your screen, is:<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Pandas-DataFrames-in-Ascending-Order.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-56433\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Pandas-DataFrames-in-Ascending-Order.png\" alt=\"How to sort dataframes in Pandas \" width=\"1366\" height=\"562\" \/><\/a><\/p>\n<p>When we have to<strong> sort by multiple columns<\/strong>, we type:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&gt;&gt;&gt; dataflair_df1.sort_values(by=['col1', 'col2'])<\/pre>\n<p>The output, as shown on your screen, is:<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-sort-by-multiple-columns.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-56500\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-sort-by-multiple-columns.png\" alt=\"How Pandas Sort by Multiple coloumns\" width=\"1366\" height=\"594\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-sort-by-multiple-columns.png 1366w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-sort-by-multiple-columns-150x65.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-sort-by-multiple-columns-300x130.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-sort-by-multiple-columns-768x334.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-sort-by-multiple-columns-1024x445.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-sort-by-multiple-columns-520x226.png 520w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><\/a><\/p>\n<h4>5.2.2 How to Sort Pandas in Descending Order?<\/h4>\n<p>When we have to <strong>sort by a single column<\/strong>, we type:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&gt;&gt;&gt; dataflair_df1.sort_values(by='col1', ascending=False)<\/pre>\n<p>The output, as shown on your screen, is:<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Pandas-in-Descending-Order.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-56501\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Pandas-in-Descending-Order.png\" alt=\" Sort Pandas in Descending Order\" width=\"1366\" height=\"611\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Pandas-in-Descending-Order.png 1366w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Pandas-in-Descending-Order-150x67.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Pandas-in-Descending-Order-300x134.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Pandas-in-Descending-Order-768x344.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Pandas-in-Descending-Order-1024x458.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Pandas-in-Descending-Order-520x233.png 520w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><\/a><\/p>\n<p><strong>When we have to sort by multiple columns, we type:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&gt;&gt;&gt; dataflair_df1.sort_values(by=['col1', 'col2'], ascending=False)<\/pre>\n<p>The output, as shown on your screen, is:<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sort-multiple-coloumns-in-decending-order.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-56502\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sort-multiple-coloumns-in-decending-order.png\" alt=\"Sorting of Pandas Dataframes in descending order\" width=\"1366\" height=\"639\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sort-multiple-coloumns-in-decending-order.png 1366w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sort-multiple-coloumns-in-decending-order-150x70.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sort-multiple-coloumns-in-decending-order-300x140.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sort-multiple-coloumns-in-decending-order-768x359.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sort-multiple-coloumns-in-decending-order-1024x479.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sort-multiple-coloumns-in-decending-order-520x243.png 520w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><\/a><\/p>\n<h3>5.3 Sorting while putting Na first<\/h3>\n<p>To put the NaN values on the top, we have to specify the code as:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&gt;&gt;&gt; dataflair_df1.sort_values(by='col2', ascending=False, na_position='first')<\/pre>\n<p>The output, as shown on your screen, is:<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-while-putting-Na-first-in-pandas.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-56503\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-while-putting-Na-first-in-pandas.png\" alt=\" Sorting while putting Na first\" width=\"1366\" height=\"618\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-while-putting-Na-first-in-pandas.png 1366w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-while-putting-Na-first-in-pandas-150x68.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-while-putting-Na-first-in-pandas-300x136.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-while-putting-Na-first-in-pandas-768x347.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-while-putting-Na-first-in-pandas-1024x463.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-while-putting-Na-first-in-pandas-520x235.png 520w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><\/a><\/p>\n<h3>5.4 How to Sort Pandas DataFrames by Index?<\/h3>\n<p>Let&#8217;s understand with an example-<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&gt;&gt;&gt; dataflair_df1 = pd.DataFrame({'col3' : [9, 6, 0, 7, 5, 8],'col1' : ['C', 'B', 'A', np.nan, 'C', 'D'],'col2': [20, 3, 5, 18, 15, 1],})\r\n&gt;&gt;&gt; dataflair_df1<\/pre>\n<p>The <strong>output<\/strong> will be like-<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Pandas-DataFrames-by-Index.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-56504\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Pandas-DataFrames-by-Index.png\" alt=\"Pandas Dataframes are sorted by index\" width=\"1366\" height=\"617\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Pandas-DataFrames-by-Index.png 1366w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Pandas-DataFrames-by-Index-150x68.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Pandas-DataFrames-by-Index-300x136.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Pandas-DataFrames-by-Index-768x347.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Pandas-DataFrames-by-Index-1024x463.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Pandas-DataFrames-by-Index-520x235.png 520w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><\/a><\/p>\n<p><strong>Input-<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&gt;&gt;&gt; dataflair_df1.sort_index(axis = 1,inplace = True)\r\n&gt;&gt;&gt; dataflair_df1<\/pre>\n<p><strong>Output<\/strong>:<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Pandas-DataFrames-by-Index-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-56505\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Pandas-DataFrames-by-Index-1.png\" alt=\"How to sort pandas dataframes by indexing\" width=\"1366\" height=\"605\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Pandas-DataFrames-by-Index-1.png 1366w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Pandas-DataFrames-by-Index-1-150x66.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Pandas-DataFrames-by-Index-1-300x133.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Pandas-DataFrames-by-Index-1-768x340.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Pandas-DataFrames-by-Index-1-1024x454.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sort-Pandas-DataFrames-by-Index-1-520x230.png 520w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><\/a><\/p>\n<h3>5.5 How to Sort Pandas DataFrames are by Column name?<\/h3>\n<p>Follow this example to know how to sort dataframes by column names-<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&gt;&gt;&gt; L = ['col3','col1','col2']\r\n&gt;&gt;&gt; dataflair_df1=dataflair_df1[L]\r\n&gt;&gt;&gt; dataflair_df1<\/pre>\n<p>The <strong>output<\/strong> will like-<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sort-by-column-name.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-56506\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sort-by-column-name.png\" alt=\"How to sort pandas datafranes by columns name\" width=\"1365\" height=\"580\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sort-by-column-name.png 1365w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sort-by-column-name-150x64.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sort-by-column-name-300x127.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sort-by-column-name-768x326.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sort-by-column-name-1024x435.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sort-by-column-name-520x221.png 520w\" sizes=\"auto, (max-width: 1365px) 100vw, 1365px\" \/><\/a><\/p>\n<p><strong>We will sort using:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&gt;&gt;&gt; dataflair_df1 = dataflair_df1.reindex(sorted(dataflair_df1.columns), axis=1)\r\n<\/pre>\n<p><strong>Output:<\/strong><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sort.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-56507\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sort.png\" alt=\"Sorting in pandas\" width=\"1366\" height=\"632\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sort.png 1366w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sort-150x69.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sort-300x139.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sort-768x355.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sort-1024x474.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-Sort-520x241.png 520w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><\/a><\/p>\n<h3>5.6 How to Sort Pandas DataFrames by Rows?<\/h3>\n<p>Keep in mind that for <a href=\"https:\/\/pandas.pydata.org\/pandas-docs\/version\/0.19\/generated\/pandas.DataFrame.sort.html\">sorting by rows<\/a>, all elements have to be of the same type. So we will <strong>create a new DataFrame<\/strong> here, and we will have to label the index as well.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&gt;&gt;&gt; dataflair_df1 = pd.DataFrame({'col3' : [4,8,7,9,3,5],'col1' : [14,18,27,29,6,1],'col2': [3,6,9,2,4,8]},index=['A','B','C','D','E','F'])\r\n&gt;&gt;&gt; dataflair_df1\r\n<\/pre>\n<p><strong>Output<\/strong> &#8211;<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/How-to-Sort-Pandas-DataFrames-Rows.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-56526 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/How-to-Sort-Pandas-DataFrames-Rows.png\" alt=\"DataFrames are sorted by rows\" width=\"1366\" height=\"768\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/How-to-Sort-Pandas-DataFrames-Rows.png 1366w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/How-to-Sort-Pandas-DataFrames-Rows-150x84.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/How-to-Sort-Pandas-DataFrames-Rows-300x169.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/How-to-Sort-Pandas-DataFrames-Rows-768x432.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/How-to-Sort-Pandas-DataFrames-Rows-1024x576.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/How-to-Sort-Pandas-DataFrames-Rows-520x292.png 520w\" sizes=\"auto, (max-width: 1366px) 100vw, 1366px\" \/><\/a><\/p>\n<p>Now we will sort with<strong> respect to rows<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&gt;&gt;&gt; dataflair_df1 = dataflair_df1.sort_values(by='D', axis=1)\r\n&gt;&gt;&gt; dataflair_df1<\/pre>\n<p><strong>Output<\/strong>:<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-datframes-are-sorted-by-respected-rows.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-56509 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-datframes-are-sorted-by-respected-rows.png\" alt=\"Dataframes are sorted by rows\" width=\"1365\" height=\"624\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-datframes-are-sorted-by-respected-rows.png 1365w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-datframes-are-sorted-by-respected-rows-150x69.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-datframes-are-sorted-by-respected-rows-300x137.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-datframes-are-sorted-by-respected-rows-768x351.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-datframes-are-sorted-by-respected-rows-1024x468.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Pandas-datframes-are-sorted-by-respected-rows-520x238.png 520w\" sizes=\"auto, (max-width: 1365px) 100vw, 1365px\" \/><\/a><\/p>\n<h2>Summary<\/h2>\n<p>Sorting in NumPy Array and Pandas Series and DataFrame is quite straightforward. You will have to mention your preferences explicitly if they are not the default options. If you still have any doubts during runtime, feel free to ask them in the comment section below.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sorting refers to the act of arranging the items systematically and the sequence is decided by some or the other criterion. In this Python Sorting tutorial, we are going to learn how to sort&#46;&#46;&#46;<\/p>\n","protected":false},"author":5,"featured_media":56420,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19475],"tags":[19781,19784,19782,19783],"class_list":["post-56381","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pandas","tag-pandas-sorting","tag-sort-pandas-array","tag-sort-pandas-datafarmes","tag-sort-pandas-series"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Easy Steps to Sort Pandas DataFrames, Series, Arrays with Examples - DataFlair<\/title>\n<meta name=\"description\" content=\"Get Easy steps for to sort dataframes, series, arrays with examples. With the help of pandas sort, we can sort by columns, rows, index, names\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/sort-pandas-dataframes-series-array\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Easy Steps to Sort Pandas DataFrames, Series, Arrays with Examples - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Get Easy steps for to sort dataframes, series, arrays with examples. With the help of pandas sort, we can sort by columns, rows, index, names\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/sort-pandas-dataframes-series-array\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-05-21T11:46:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-05-21T11:46:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-in-pandas.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"802\" \/>\n\t<meta property=\"og:image:height\" content=\"420\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Easy Steps to Sort Pandas DataFrames, Series, Arrays with Examples - DataFlair","description":"Get Easy steps for to sort dataframes, series, arrays with examples. With the help of pandas sort, we can sort by columns, rows, index, names","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:\/\/data-flair.training\/blogs\/sort-pandas-dataframes-series-array\/","og_locale":"en_US","og_type":"article","og_title":"Easy Steps to Sort Pandas DataFrames, Series, Arrays with Examples - DataFlair","og_description":"Get Easy steps for to sort dataframes, series, arrays with examples. With the help of pandas sort, we can sort by columns, rows, index, names","og_url":"https:\/\/data-flair.training\/blogs\/sort-pandas-dataframes-series-array\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2019-05-21T11:46:11+00:00","article_modified_time":"2019-05-21T11:46:47+00:00","og_image":[{"width":802,"height":420,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-in-pandas.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/sort-pandas-dataframes-series-array\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/sort-pandas-dataframes-series-array\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823"},"headline":"Easy Steps to Sort Pandas DataFrames, Series, Arrays with Examples","datePublished":"2019-05-21T11:46:11+00:00","dateModified":"2019-05-21T11:46:47+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sort-pandas-dataframes-series-array\/"},"wordCount":851,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sort-pandas-dataframes-series-array\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-in-pandas.jpg","keywords":["Pandas Sorting","Sort Pandas array","Sort Pandas Datafarmes","Sort Pandas series"],"articleSection":["Pandas Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/sort-pandas-dataframes-series-array\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/sort-pandas-dataframes-series-array\/","url":"https:\/\/data-flair.training\/blogs\/sort-pandas-dataframes-series-array\/","name":"Easy Steps to Sort Pandas DataFrames, Series, Arrays with Examples - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sort-pandas-dataframes-series-array\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sort-pandas-dataframes-series-array\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-in-pandas.jpg","datePublished":"2019-05-21T11:46:11+00:00","dateModified":"2019-05-21T11:46:47+00:00","description":"Get Easy steps for to sort dataframes, series, arrays with examples. With the help of pandas sort, we can sort by columns, rows, index, names","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/sort-pandas-dataframes-series-array\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/sort-pandas-dataframes-series-array\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/sort-pandas-dataframes-series-array\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-in-pandas.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Sorting-in-pandas.jpg","width":802,"height":420,"caption":"How to sort Dataframes in Pandas"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/sort-pandas-dataframes-series-array\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Pandas Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/pandas\/"},{"@type":"ListItem","position":3,"name":"Easy Steps to Sort Pandas DataFrames, Series, Arrays with Examples"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team creates expert-level guides on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our goal is to empower learners with easy-to-understand content. Explore our resources for career growth and practical learning.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam1\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/56381","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=56381"}],"version-history":[{"count":7,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/56381\/revisions"}],"predecessor-version":[{"id":56587,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/56381\/revisions\/56587"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/56420"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=56381"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=56381"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=56381"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}