{"id":6655,"date":"2021-05-22T09:06:40","date_gmt":"2021-05-22T03:36:40","guid":{"rendered":"https:\/\/python-programs.com\/?p=6655"},"modified":"2021-11-22T18:45:25","modified_gmt":"2021-11-22T13:15:25","slug":"pandas-sort-a-dataframe-based-on-column-names-or-row-index-labels-using-dataframe-sort_index","status":"publish","type":"post","link":"https:\/\/python-programs.com\/pandas-sort-a-dataframe-based-on-column-names-or-row-index-labels-using-dataframe-sort_index\/","title":{"rendered":"Pandas : Sort a DataFrame based on column names or row index labels using Dataframe.sort_index()"},"content":{"rendered":"
In this article we will discuss how we organize the content of data entered based on column names or line reference labels using In the Python Pandas Library, the Dataframe section provides a member sort sort_index () to edit DataFrame based on label names next to the axis i.e.<\/p>\n Where,<\/p>\n It returns the edited data object. Also, if the location dispute is untrue then it will return a duplicate copy of the provided data, instead of replacing the original Dataframe. While, if the internal dispute is true it will cause the current file name to be edited.<\/p>\n Let’s understand some examples,<\/p>\n Now let’s see how we organize this DataFrame based on labels i.e. columns or line reference labels,<\/p>\n Sorting by line index labels we can call As we can see in the output lines it is sorted based on the reference labels now. Instead of changing the original name data backed up an edited copy of the dataframe.<\/p>\n Sorting based on line index labels in descending order we need to pass the As we can see in the output lines it is sorted by destructive sequence based on the current reference labels. Also, instead of changing the original data name it restored the edited copy of the data.<\/p>\n Filtering a local data name instead of finding the default copy transfer To edit DataFrame based on column names we can say sort_index () in a DataFrame object with an axis= 1 i.e.<\/p>\n As we can see, instead of changing the original data name it returns a fixed copy of the data data based on the column names.<\/p>\n By sorting DataFrame based on column names in descending order, we can call Instead of changing the original data name restore the edited copy of the data based on the column names (sorted by order)<\/p>\n Editing a local data name instead of obtaining an approved copy pass input = True and axis = 1 in sort_index () function in the dataframe object to filter the local data name by column names i.e.<\/p>\n Want to expert in the python programming language? Exploring\u00a0Python Data Analysis using Pandas<\/a>\u00a0tutorial changes your knowledge from basic to advance level in python concepts.<\/p>\n Read more Articles on Python Data Analysis Using Padas \u2013 Modify a Dataframe<\/strong><\/p>\n Sorting a DataFrame based on column names or row index labels using Dataframe.sort_index() in Python In this article we will discuss how we organize the content of data entered based on column names or line reference labels using Dataframe.sort_index (). Dataframe.sort_index(): In the Python Pandas Library, the Dataframe section provides a member sort sort_index () …<\/p>\nDataframe.sort_index ().<\/code><\/p>\n
Dataframe.sort_index():<\/h3>\n
DataFrame.sort_index(axis=0, level=None, ascending=True, inplace=False, kind='quicksort', na_position='last', sort_remaining=True, by=None)<\/pre>\n
\n
# Program :\r\n\r\nimport pandas as pd\r\n# List of Tuples\r\nstudents = [ ('Rama', 31, 'canada') ,\r\n ('Symon', 23, 'Chennai' ) ,\r\n ('Arati', 16, 'Maharastra') ,\r\n ('Bhabani', 32, 'Kolkata' ) ,\r\n ('Modi', 33, 'Uttarpradesh' ) ,\r\n ('Heeron', 39, 'Hyderabad' )\r\n ]\r\n# Create a DataFrame object\r\ndfObj = pd.DataFrame(students, columns=['Name', 'Marks', 'City'], index=['b', 'a', 'f', 'e', 'd', 'c'])\r\nprint(dfObj)\r\n<\/pre>\n
Output :\r\n\u00a0 \u00a0 Name\u00a0 \u00a0Marks\u00a0 City\r\nb\u00a0 Rama\u00a0 \u00a0 \u00a031\u00a0 \u00a0canada\r\na\u00a0 Symon\u00a0 \u00a023\u00a0 \u00a0Chennai\r\nf\u00a0 \u00a0Arati\u00a0 \u00a0 \u00a0 16\u00a0 \u00a0Maharastra\r\ne\u00a0 Bhabani\u00a0 32\u00a0 Kolkata\r\nd\u00a0 Modi\u00a0 \u00a0 \u00a0 33\u00a0 Uttarpradesh\r\nc\u00a0 Heeron\u00a0 39\u00a0 \u00a0Hyderabad<\/pre>\n
Sort rows of a Dataframe based on Row index labels :<\/span><\/h3>\n
sort_index()<\/code> in the data name item.<\/p>\n
import pandas as pd\r\n# The List of Tuples\r\nstudents = [ ('Rama', 31, 'canada') ,\r\n ('Symon', 23, 'Chennai' ) ,\r\n ('Arati', 16, 'Maharastra') ,\r\n ('Bhabani', 32, 'Kolkata' ) ,\r\n ('Modi', 33, 'Uttarpradesh' ) ,\r\n ('Heeron', 39, 'Hyderabad' )\r\n ]\r\n# To create DataFrame object \r\ndfObj = pd.DataFrame(students, columns=['Name', 'Marks', 'City'], index=['b', 'a', 'f', 'e', 'd', 'c'])\r\n# By sorting the rows of dataframe based on row index label names\r\nmodDFObj = dfObj.sort_index()\r\nprint(' Dataframes are in sorted oreder of index value given:')\r\nprint(modDFObj)<\/pre>\n
Output :\r\nDataframes are in sorted oreder of index value given:\r\n\u00a0 \u00a0 Name\u00a0 \u00a0 Marks\u00a0 \u00a0 \u00a0 \u00a0 City\r\na Symon\u00a0 \u00a0 \u00a0 23\u00a0 \u00a0 \u00a0 \u00a0 \u00a0Chennai\r\nb Rama\u00a0 \u00a0 \u00a0 \u00a0 31\u00a0 \u00a0 \u00a0 \u00a0 \u00a0canada\r\nc Heeron\u00a0 \u00a0 \u00a039\u00a0 \u00a0 \u00a0 \u00a0 \u00a0Hyderabad\r\nd Modi\u00a0 \u00a0 \u00a0 \u00a0 33\u00a0 \u00a0 \u00a0 \u00a0 \u00a0Uttarpradesh\r\ne Bhabani\u00a0 \u00a0 32\u00a0 \u00a0 \u00a0 \u00a0 \u00a0Kolkata\r\nf Arati\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 16\u00a0 \u00a0 \u00a0 \u00a0 \u00a0Maharastra<\/pre>\n
Sort rows of a Dataframe in Descending Order based on Row index labels :<\/h3>\n
argument = False<\/code> in
sort_index()<\/code> function in the data object object.<\/p>\n
import pandas as pd\r\n# The List of Tuples\r\nstudents = [ ('Rama', 31, 'canada') ,\r\n ('Symon', 23, 'Chennai' ) ,\r\n ('Arati', 16, 'Maharastra') ,\r\n ('Bhabani', 32, 'Kolkata' ) ,\r\n ('Modi', 33, 'Uttarpradesh' ) ,\r\n ('Heeron', 39, 'Hyderabad' )\r\n ]\r\n# To create DataFrame object \r\ndfObj = pd.DataFrame(students, columns=['Name', 'Marks', 'City'], index=['b', 'a', 'f', 'e', 'd', 'c'])\r\n# By sorting the rows of dataframe in descending order based on row index label names\r\nconObj = dfObj.sort_index(ascending=False)\r\nprint('The Contents of Dataframe are sorted in descending Order based on Row Index Labels are of :')\r\nprint(conObj)\r\n<\/pre>\n
The Contents of Dataframe are sorted in descending Order based on Row Index Labels are of :\r\n Name\u00a0 Marks\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 City\r\nf\u00a0\u00a0\u00a0 Arati\u00a0\u00a0\u00a0\u00a0 16\u00a0\u00a0\u00a0 Maharastra\r\ne\u00a0 Bhabani\u00a0\u00a0\u00a0\u00a0 32\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Kolkata\r\nd\u00a0\u00a0\u00a0\u00a0 Modi\u00a0\u00a0\u00a0\u00a0 33\u00a0 Uttarpradesh\r\nc\u00a0\u00a0 Heeron\u00a0\u00a0\u00a0\u00a0 39\u00a0\u00a0\u00a0\u00a0 Hyderabad\r\nb\u00a0\u00a0\u00a0\u00a0 Rama\u00a0\u00a0\u00a0\u00a0 31\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 canada\r\na\u00a0\u00a0\u00a0 Symon\u00a0\u00a0\u00a0\u00a0 23\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Chennai<\/pre>\n
Sort rows of a Dataframe based on Row index labels in Place :<\/h3>\n
inplace = True<\/code> in
sort_index ()<\/code> function in the data object object to filter the data name with local reference label labels i.e.<\/p>\n
import pandas as pd\r\n# The List of Tuples\r\nstudents = [ ('Rama', 31, 'canada') ,\r\n ('Symon', 23, 'Chennai' ) ,\r\n ('Arati', 16, 'Maharastra') ,\r\n ('Bhabani', 32, 'Kolkata' ) ,\r\n ('Modi', 33, 'Uttarpradesh' ) ,\r\n ('Heeron', 39, 'Hyderabad' )\r\n ]\r\n# To create DataFrame object \r\ndfObj = pd.DataFrame(students, columns=['Name', 'Marks', 'City'], index=['b', 'a', 'f', 'e', 'd', 'c'])\r\n#By sorting the rows of dataframe in Place based on row index label names\r\ndfObj.sort_index(inplace=True)\r\nprint('The Contents of Dataframe are sorted in Place based on Row Index Labels are of :')\r\nprint(dfObj)\r\n<\/pre>\n
Output :\r\nThe Contents of Dataframe are sorted in Place based on Row Index Labels are of :\r\n \u00a0 \u00a0Name\u00a0 \u00a0 \u00a0Marks\u00a0 \u00a0 \u00a0 City\r\na\u00a0\u00a0\u00a0 Symon\u00a0\u00a0\u00a0\u00a0 23\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Chennai\r\nb\u00a0\u00a0\u00a0\u00a0 Rama\u00a0\u00a0\u00a0\u00a0 31\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 canada\r\nc\u00a0\u00a0 Heeron\u00a0\u00a0\u00a0\u00a0 39\u00a0\u00a0\u00a0\u00a0 Hyderabad\r\nd\u00a0\u00a0\u00a0\u00a0 Modi\u00a0\u00a0\u00a0\u00a0 33\u00a0 \u00a0 \u00a0Uttarpradesh\r\ne\u00a0 Bhabani\u00a0\u00a0\u00a0\u00a0 32\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Kolkata\r\nf\u00a0\u00a0\u00a0 Arati\u00a0 \u00a0 \u00a0 \u00a016\u00a0 \u00a0 \u00a0 \u00a0Maharastra<\/pre>\n
Sort Columns of a Dataframe based on Column Names :<\/h3>\n
import pandas as pd\r\n# The List of Tuples\r\nstudents = [ ('Rama', 31, 'canada') ,\r\n ('Symon', 23, 'Chennai' ) ,\r\n ('Arati', 16, 'Maharastra') ,\r\n ('Bhabani', 32, 'Kolkata' ) ,\r\n ('Modi', 33, 'Uttarpradesh' ) ,\r\n ('Heeron', 39, 'Hyderabad' )\r\n ]\r\n# To create DataFrame object \r\ndfObj = pd.DataFrame(students, columns=['Name', 'Marks', 'City'], index=['b', 'a', 'f', 'e', 'd', 'c'])\r\n# By sorting a dataframe based on column names\r\nconObj = dfObj.sort_index(axis=1)\r\nprint('The Contents are of Dataframe sorted based on Column Names are in the type :')\r\nprint(conObj)\r\n\r\n<\/pre>\n
Output :\r\nThe Contents are of Dataframe sorted based on Column Names are in the type :\r\n City\u00a0 Marks\u00a0\u00a0\u00a0\u00a0 Name\r\nb\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 canada\u00a0\u00a0\u00a0\u00a0 31\u00a0\u00a0\u00a0\u00a0 Rama\r\na\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Chennai\u00a0\u00a0\u00a0\u00a0 23\u00a0\u00a0\u00a0 Symon\r\nf\u00a0\u00a0\u00a0 Maharastra\u00a0\u00a0\u00a0\u00a0 16\u00a0\u00a0\u00a0 Arati\r\ne\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Kolkata\u00a0\u00a0\u00a0\u00a0 32\u00a0 Bhabani\r\nd\u00a0 Uttarpradesh\u00a0\u00a0\u00a0\u00a0 33\u00a0\u00a0\u00a0\u00a0 Modi\r\nc\u00a0\u00a0\u00a0\u00a0 Hyderabad\u00a0\u00a0\u00a0\u00a0 39\u00a0\u00a0 Heeron<\/pre>\n
Sort Columns of a Dataframe in Descending Order based on Column Names :<\/h3>\n
sort_index ()<\/code> in the DataFrame item with axis = 1 and ascending = False i.e.<\/p>\n
import pandas as pd\r\n# The List of Tuples\r\nstudents = [ ('Rama', 31, 'canada') ,\r\n ('Symon', 23, 'Chennai' ) ,\r\n ('Arati', 16, 'Maharastra') ,\r\n ('Bhabani', 32, 'Kolkata' ) ,\r\n ('Modi', 33, 'Uttarpradesh' ) ,\r\n ('Heeron', 39, 'Hyderabad' )\r\n ]\r\n# To create DataFrame object \r\ndfObj = pd.DataFrame(students, columns=['Name', 'Marks', 'City'], index=['b', 'a', 'f', 'e', 'd', 'c'])\r\n# By sorting a dataframe in descending order based on column names\r\nconObj = dfObj.sort_index(ascending=False, axis=1)\r\nprint('The Contents of Dataframe sorted in Descending Order based on Column Names are of :')\r\nprint(conObj)\r\n<\/pre>\n
Output :\r\nThe Contents of Dataframe sorted in Descending Order based on Column Names are of :\r\nName\u00a0 Marks\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 City\r\nb\u00a0\u00a0\u00a0\u00a0 Rama\u00a0\u00a0\u00a0\u00a0 31\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 canada\r\na\u00a0\u00a0\u00a0 Symon\u00a0\u00a0\u00a0\u00a0 23\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Chennai\r\nf\u00a0\u00a0\u00a0 Arati\u00a0\u00a0\u00a0\u00a0 16\u00a0\u00a0\u00a0 Maharastra\r\ne\u00a0 Bhabani\u00a0\u00a0\u00a0\u00a0 32\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Kolkata\r\nd\u00a0\u00a0\u00a0\u00a0 Modi\u00a0\u00a0\u00a0\u00a0 33\u00a0 Uttarpradesh\r\nc\u00a0\u00a0 Heeron\u00a0\u00a0\u00a0\u00a0 39\u00a0\u00a0\u00a0\u00a0 Hyderabad<\/pre>\n
Sort Columns of a Dataframe in Place based on Column Names :<\/h3>\n
import pandas as pd\r\n# The List of Tuples\r\nstudents = [ ('Rama', 31, 'canada') ,\r\n ('Symon', 23, 'Chennai' ) ,\r\n ('Arati', 16, 'Maharastra') ,\r\n ('Bhabani', 32, 'Kolkata' ) ,\r\n ('Modi', 33, 'Uttarpradesh' ) ,\r\n ('Heeron', 39, 'Hyderabad' )\r\n ]\r\n# To create DataFrame object \r\ndfObj = pd.DataFrame(students, columns=['Name', 'Marks', 'City'], index=['b', 'a', 'f', 'e', 'd', 'c'])\r\n# By sorting a dataframe in place based on column names\r\ndfObj.sort_index(inplace=True, axis=1)\r\nprint('The Contents of Dataframe sorted in Place based on Column Names are of:')\r\nprint(dfObj)\r\n\r\n<\/pre>\n
Output :\r\nThe Contents of Dataframe sorted in Place based on Column Names are of:\r\nCity\u00a0 Marks\u00a0\u00a0\u00a0\u00a0 Name\r\nb\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 canada\u00a0\u00a0\u00a0\u00a0 31\u00a0\u00a0\u00a0\u00a0 Rama\r\na\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Chennai\u00a0\u00a0\u00a0\u00a0 23\u00a0\u00a0\u00a0 Symon\r\nf\u00a0\u00a0\u00a0 Maharastra\u00a0\u00a0\u00a0\u00a0 16\u00a0\u00a0\u00a0 Arati\r\ne\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Kolkata\u00a0\u00a0\u00a0\u00a0 32\u00a0 Bhabani\r\nd\u00a0 Uttarpradesh\u00a0\u00a0\u00a0\u00a0 33\u00a0\u00a0\u00a0\u00a0 Modi\r\nc\u00a0\u00a0\u00a0\u00a0 Hyderabad\u00a0\u00a0\u00a0\u00a0 39\u00a0\u00a0 Heeron<\/pre>\n
\n