- \n
- A quick introduction to Pandas sort_values<\/a><\/li>\n
- The syntax of Pandas sort_values<\/a><\/li>\n
- Pandas sort_values examples<\/a><\/li>\n
- Pandas sort_values FAQ<\/a><\/li>\n<\/ul>\n
Again, if you’re looking for something specific, you can just click on one of the links.<\/p>\n
But if you’re new to Pandas and not really sure how to do data manipulation in Python, you should really read the whole tutorial.<\/p>\n
Ok. Let’s take a high level look at sort_values.<\/p>\n
<\/a><\/p>\n
A quick introduction to the Pandas sort_values method<\/h2>\n
The sort_values method is a data manipulation tool from the Pandas package.<\/p>\n
If you’re not completely familiar with it, the Pandas package<\/a> is a data manipulation toolkit for the Python<\/a> programming language.<\/p>\n
Pandas has a few dozen tools for manipulating data. There are tools for renaming variables, subsetting rows of data<\/a>, selecting DataFrame columns<\/a>, and a variety of other data manipulation tasks. Pandas is really an integrated toolkit for cleaning and shaping data.<\/p>\n
One of the most common data manipulation tasks is sorting data, and Pandas has a tool for that as well.<\/p>\n
sort_values sorts the columns of a dataframe<\/h3>\n
The sort_values method is a Pandas method for sorting the columns of a DataFrame.<\/p>\n
That’s really all it does!<\/p>\n
But there are a few details about how the function works that you should know about.<\/p>\n
To really understand the details of the sort_values method, you need to understand the syntax.<\/p>\n
Let’s take a look.<\/p>\n
<\/a><\/p>\n
The syntax of Pandas sort_values<\/h2>\n
The syntax of the Pandas sort_values method is fairly straightforward.<\/p>\n
When you call the method, you first need to type the name of your DataFrame. That means that before you call the method, you first need an actual DataFrame. For more information about DataFrames, I recommend our tutorial about Pandas DataFrames<\/a>.<\/p>\n
![\"An](\"https:\/\/www.sharpsightlabs.com\/wp-content\/uploads\/2022\/01\/pandas-sort-values_syntax-explanation.png\")
<\/p>\nAfter you type the name of the DataFrame, you need to type a dot (“
.<\/code>“) and then the name of the method:sort_values<\/code>.<\/p>\nThen, inside of the parenthesis there will be a group of arguments and parameters that enable you to specify exactly how to sort the data.<\/p>\n
Let’s look at the parameters of sort_values more carefully.<\/p>\n
The parameters of sort_values<\/h3>\n
The sort_values method actually has several parameters, but we’re going to focus on three:<\/p>\n
- \n
by<\/code><\/li>\nascending<\/code><\/li>\ninplace<\/code><\/li>\n<\/ul>\nThese three parameters are the most common, and they are the ones you will use most often.<\/p>\n
The method also has 3 other parameters \u2013
axis<\/code>,kind<\/code>, andna_position<\/code>. These are less common, so we’re not going to look at them in detail (although I will mentionaxis<\/code> andkind<\/code> in the FAQ section<\/a> towards the end.).<\/p>\nOk … I’m going to quickly explain the
by<\/code>,ascending<\/code>, andinplace<\/code> parameters.<\/p>\nby<\/code><\/h6>\nThe
by<\/code> parameter specifies the column or columns to sort by.<\/p>\nYou can provide a name of an individual column or a list of names.<\/p>\n
When you provide a single column name, you need to provide the column name in the form of a Pandas string (i.e., the column name needs to be enclosed inside of quotation marks).<\/p>\n
When you provide several column names, you need to organize them inside of a list.<\/p>\n
I’ll show you examples of both of these in the examples section of the tutorial<\/a>.<\/p>\n
Note that this is required. You must provide an argument to this parameter.<\/p>\n
ascending<\/code><\/h6>\nThe
ascending<\/code> parameter enables you to specify whether or not you want to sort the DataFrame in ascending order or descending order.<\/p>\nIf you set
ascending = True<\/code>, then sort_values will sort the data in ascending order (i.e., from lowest to highest).<\/p>\nIf you set
ascending = False<\/code>, the sort_values will sort the data in descending order (i.e., from highest to lowest).<\/p>\nThis parameter is not<\/em> required. If you don’t use this parameter, it will default to
ascending = True<\/code> and sort your DataFrame in ascending order.<\/p>\ninplace<\/code><\/h6>\nThis parameter specifies whether or not you want to sort the DataFrame “in place.” <\/p>\n
By default, this parameter is set to
inplace = False<\/code>.<\/p>\nWhen
inplace = False<\/code>, the method will create a new DataFrame as the output, and leave the original DataFrame unchanged. <\/p>\nAs a side note, that’s actually a good thing, because that way you won’t accidentally overwrite your data!<\/p>\n
However, if you set
inplace = True<\/code>, the Pandas sort values method will directly sort the original DataFrame. Be careful! This mean that when you set setinplace = True<\/code>, sort_values will overwrite your original dataset!<\/p>\nThe output of sort_values<\/h3>\n
As I just mentioned, the sort_values method outputs a new Pandas DataFrame by default. <\/p>\n
However, if you set
inplace = True<\/code>, the sort_values method will directly sort the original DataFrame.<\/p>\n<\/a><\/p>\n
Examples: how sort a DataFrame by column with sort_values<\/h2>\n
Now that you’ve learned the syntax of Pandas sort_values, let’s take a look at some examples.<\/p>\n
Examples:<\/strong><\/p>\n
- \n
- Sort DataFrame by a single column<\/a><\/li>\n
- Sort a DataFrame by multiple variables<\/a><\/li>\n
- Arrange a Pandas DataFrame in descending order<\/a><\/li>\n
- Sort a Pandas DataFrame “in place”<\/a><\/li>\n<\/ul>\n
Run this code first<\/h4>\n
Before you run the example code, you need to make sure that you do two things. <\/p>\n
You need to import Pandas and you need to create the DataFrame that we’re going to use.<\/p>\n
Import Pandas<\/h6>\n
You can run this code to import pandas:<\/p>\n
\r\nimport pandas as pd\r\n<\/pre>\n
This imports the Pandas package with the prefix
pd<\/code>.<\/p>\nCreate dataframe<\/h6>\n
Next, let’s create a simple DataFrame.<\/p>\n
Here, we’re going to create a small DataFrame that contains some dummy sales data.<\/p>\n
To do this, we’re just going to call the
pd.DataFrame()<\/code> function and provide the data that we want to turn into a DataFrame.<\/p>\n\r\nsales_data = pd.DataFrame({\"name\":[\"William\",\"Emma\",\"Sofia\",\"Markus\",\"Edward\",\"Thomas\",\"Ethan\",\"Olivia\",\"Arun\",\"Anika\",\"Paulo\"]\r\n,\"region\":[\"East\",\"North\",\"East\",\"South\",\"West\",\"West\",\"South\",\"West\",\"West\",\"East\",\"South\"]\r\n,\"sales\":[50000,52000,90000,34000,42000,72000,49000,55000,67000,65000,67000]\r\n,\"expenses\":[42000,43000,50000,44000,38000,39000,42000,60000,39000,44000,45000]})\r\n<\/pre>\nAnd let’s print it out so you can see the contents:<\/p>\n
\r\nprint(sales_data)\r\n<\/pre>\n
OUT:<\/p>\n
\r\n name region sales expenses\r\n0 William East 50000 42000\r\n1 Emma North 52000 43000\r\n2 Sofia East 90000 50000\r\n3 Markus South 34000 44000\r\n4 Edward West 42000 38000\r\n5 Thomas West 72000 39000\r\n6 Ethan South 49000 42000\r\n7 Olivia West 55000 60000\r\n8 Arun West 67000 39000\r\n9 Anika East 65000 44000\r\n10 Paulo South 67000 45000\r\n<\/pre>\n
The DataFrame contains 11 rows and four columns. The columns are
name<\/code>,region<\/code>,sales<\/code>, andexpenses<\/code>.<\/p>\nWe’ll be able to use several of these variables as our sorting variables.<\/p>\n
For more information about how to create DataFrames like this, you can read our Pandas DataFrame tutorial<\/a>.<\/p>\n
<\/a><\/p>\n
EXAMPLE 1: Sort dataframe by a single column<\/h3>\n
For our first example, we’re going to start simple. <\/p>\n
Here, we’re going to sort by a single variable, the
sales<\/code> variable.<\/p>\nTo do this, we’ll simply call the
sort_variables()<\/code> by typing the name of the DataFrame, and then call the method using “dot” notation. Inside of the method, we specify our sort variable by simply typing the variable name as a string (i.e., enclosed in quotation marks).<\/p>\nHere’s the code:<\/p>\n
\r\nsales_data.sort_values('sales')\r\n<\/pre>\nAnd here is the output when you run the code:<\/p>\n
\r\n name region sales expenses\r\n3 Markus South 34000 44000\r\n4 Edward West 42000 38000\r\n6 Ethan South 49000 42000\r\n0 William East 50000 42000\r\n1 Emma North 52000 43000\r\n7 Olivia West 55000 60000\r\n9 Anika East 65000 44000\r\n8 Arun West 67000 39000\r\n10 Paulo South 67000 45000\r\n5 Thomas West 72000 39000\r\n2 Sofia East 90000 50000\r\n<\/pre>\n
Notice that the output DataFrame is sorted by the
sales<\/code> variable, from the lowest value to the highest value.<\/p>\nRemember: by default, the
ascending<\/code> parameter is set toascending = True<\/code>. Because we did not manually set theascending<\/code> variable, the method defaulted toascending = True<\/code>, so the output is sorted bysales<\/code> in ascending order.<\/p>\n<\/a><\/p>\n
EXAMPLE 2: sort a DataFrame by multiple variables<\/h3>\n
Next, let’s make things a little more complicated.<\/p>\n
Here, we’re going to sort our DataFrame by multiple variables.<\/p>\n
The syntax is almost exactly the same as the code for the previous example.<\/p>\n
However, instead of providing a single variable to the method, we’re going to provide a list<\/em> of variables. <\/p>\n
Let’s take a look at the syntax and run it, and then I’ll explain more.<\/p>\n
\r\nsales_data.sort_values(['region','sales'])\r\n<\/pre>\n
And here is the output DataFrame:<\/p>\n
\r\n name region sales expenses\r\n0 William East 50000 42000\r\n9 Anika East 65000 44000\r\n2 Sofia East 90000 50000\r\n1 Emma North 52000 43000\r\n3 Markus South 34000 44000\r\n6 Ethan South 49000 42000\r\n10 Paulo South 67000 45000\r\n4 Edward West 42000 38000\r\n7 Olivia West 55000 60000\r\n8 Arun West 67000 39000\r\n5 Thomas West 72000 39000\r\n<\/pre>\n
Notice that the output is sorted by two variables. It’s sorted alphabetically by
region<\/code>, and then within each region, the rows are sorted bysales<\/code>.<\/p>\nThis output corresponds to the syntax. When we called the method, we provided a list of two variables as the input. The method call was
.sort_values(['region','sales'])<\/code>. Notice that inside of the method call, we have a Python list that contains the two variable names. <\/p>\nThe output is simply sorted by those two variables.<\/p>\n
Keep in mind that here, we sorted by two variables. We could sort by three (try it yourself). Or if you have a very large DataFrame with many variables, you can sort by a very large number of variables, if you need to. Just provide the sorting variables to the method in the form of a Python list.<\/p>\n
<\/a><\/p>\n
EXAMPLE 3: sort a Pandas DataFrame in descending order<\/h3>\n
Now, let’s sort our DataFrame in descending order.<\/p>\n
Remember that by default, the
ascending<\/code> parameter is set toascending = True<\/code>. That automatically sorts the data in ascending order.<\/p>\nTo change that and sort in descending<\/em> order, we’re going to set
ascending = False<\/code>.<\/p>\nHere’s the code:<\/p>\n
\r\nsales_data.sort_values('sales', ascending = False)\r\n<\/pre>\nAnd here’s the output:<\/p>\n
\r\n name region sales expenses\r\n2 Sofia East 90000 50000\r\n5 Thomas West 72000 39000\r\n8 Arun West 67000 39000\r\n10 Paulo South 67000 45000\r\n9 Anika East 65000 44000\r\n7 Olivia West 55000 60000\r\n1 Emma North 52000 43000\r\n0 William East 50000 42000\r\n6 Ethan South 49000 42000\r\n4 Edward West 42000 38000\r\n3 Markus South 34000 44000\r\n<\/pre>\n
Notice that in this case, the output are sorted by
sales<\/code> in descending order … i.e., from highest to lowest. <\/p>\n<\/a><\/p>\n
EXAMPLE 4: sort a Pandas DataFrame in place<\/h3>\n
Finally, we’re going to sort our data “in place”.<\/p>\n
That might be a little confusing, so let me quickly explain.<\/p>\n
Notice that whenever we’ve run our sort code in the previous examples, the code creates a new DataFrame as an output. If you’re working in Spyder or a similar Python IDE, the output is just sent right to the console window.<\/p>\n
However, if, after running the above examples, you print out the original DataFrame with the code
print(sales_data)<\/code>, you’ll find that the original dataframe (sales_data<\/code>) is exactly the same. Unsorted.<\/p>\nSyntactically, this is because the
inplace<\/code> parameter is set toinplace = False<\/code> by default. If we do not reference theinplace<\/code> parameter in our code, it just defaults toFalse<\/code>. That means that the method does not modify the original DataFrame (e.g.,sales_data<\/code>) directly. It does not modify the original DataFrame “in place”. Instead, ifinplace<\/code> is set toFalse<\/code>, it just creates a new dataset.<\/p>\nWhat if we want to modify the original DataFrame though?<\/p>\n
Easy.<\/p>\n
We just set
inplace = True<\/code>. <\/p>\nLet’s take a look.<\/p>\n
Here, before we modify our DataFrame “in place”, we’re going to create a copy.<\/p>\n
This is just so we don’t overwrite the original DataFrame. (I want to leave the original DataFrame intact for you, so we’ll just create a copy that we can modify in place.)<\/p>\n
\r\nsales_data_copy = sales_data.copy()\r\n<\/pre>\n
And now, here is the code to modify the data in place:<\/p>\n
\r\nsales_data_copy.sort_values('sales', inplace = True)\r\n<\/pre>\nAfter you run the code, there should not be any direct output. This is because the sort_values method has modified
sales_data_copy<\/code> directly.<\/p>\nThat being the case, to see the sorted DataFrame, we need to print it out. <\/p>\n
We can do that with the following code:<\/p>\n
\r\nprint(sales_data_copy)\r\n<\/pre>\n
OUT:<\/p>\n
\r\n name region sales expenses\r\n3 Markus South 34000 44000\r\n4 Edward West 42000 38000\r\n6 Ethan South 49000 42000\r\n0 William East 50000 42000\r\n1 Emma North 52000 43000\r\n7 Olivia West 55000 60000\r\n9 Anika East 65000 44000\r\n8 Arun West 67000 39000\r\n10 Paulo South 67000 45000\r\n5 Thomas West 72000 39000\r\n2 Sofia East 90000 50000\r\n<\/pre>\n
Notice that the
sales_data_copy<\/code> DataFrame is sorted onsales<\/code> from low to high.<\/p>\nBecause we sorted the data in place, that change to
sales_data_copy<\/code> is permanent.<\/p>\nAt the same time though, the original
sales_data<\/code> DataFrame is still unchanged.<\/p>\n<\/a><\/p>\n
Frequently asked questions about Pandas sort_values<\/h2>\n
Ok …. let’s take a look at a couple questions about the sort_values method.<\/p>\n
Frequently asked questions:<\/strong><\/p>\n
- \n
- Is it possible to sort the data along axis 1?<\/a><\/li>\n
- How can you sort by ascending order and descending order for different variables?<\/a><\/li>\n<\/ul>\n
<\/a><\/p>\n
Question 1: Is it possible to sort the data along axis 1?<\/h3>\n
So far in this tutorial, we’ve been using the sort_values method to sort the rows of data.<\/p>\n
Technically, sorting the rows is equivalent to saying that we’re sorting axis 0 of the DataFrame. (This is a bit technical … you need to understand Pandas axes to understand this.)<\/p>\n
I haven’t mentioned though, that it’s actually possible to sort the columns as well. You can use sort_values to sort the columns of a DataFrame just like you can sort the rows.<\/p>\n
To do this, you can set the
axis<\/code> parameter toaxis = 1<\/code> in your code.<\/p>\nHaving said that, it’s extremely rare to have to do this. <\/p>\n
If you have a typical DataFrame with rows and columns, you should almost never need to set
axis = 1<\/code>.<\/p>\n<\/a><\/p>\n
Question 2:How can you sort by ascending order and descending order for different variables?<\/h3>\n
What if you want to sort by one variable in ascending order and sort by a second variable in descending order. Is that possible?<\/p>\n
Yes.<\/p>\n
You can just past a list of boolean values to the
ascending<\/code> parameter.<\/p>\nTry it! <\/p>\n
You can run this code on the
sales_data<\/code> DataFrame we created above:<\/p>\n\r\nsales_data.sort_values(['region','sales'], ascending = [False, True])\r\n<\/pre>\n
Leave your other questions in the comments below<\/h5>\n
Do you have more questions about the Pandas sort_values method?<\/p>\n
Leave your questions in the comments section below.<\/p>\n
Join our course to learn more about Pandas<\/h2>\n
If you’re serious about learning Pandas, you should enroll in our premium Pandas course called Pandas Mastery<\/em>.<\/p>\n
Pandas Mastery will teach you everything you need to know about Pandas, including:<\/p>\n
- \n
- How to subset your Python data<\/li>\n
- Data aggregation with Pandas<\/li>\n
- How to reshape your data<\/li>\n
- and more …<\/li>\n<\/ul>\n
Moreover, it will help you completely master<\/em> the syntax within a few weeks. You’ll discover how to become “fluent” in writing Pandas code to manipulate your data.<\/p>\n
Find out more here:<\/p>\n
\nLearn More About Pandas Mastery<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
This tutorial will show you how to use the Pandas sort_values method to sort a DataFrame by column. The sort_values method is fairly straightforward to use, but this tutorial will explain everything step by step. I’ll explain what the sort values method does. I’ll explain the syntax. And then I’ll provide clear, step-by-step examples of … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":4715,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","om_disable_all_campaigns":false,"footnotes":""},"categories":[58,68],"tags":[35,69,59],"publishpress_future_action":{"enabled":false,"date":"2024-05-04 00:23:11","action":"change-status","newStatus":"draft","terms":[],"taxonomy":"category"},"_links":{"self":[{"href":"https:\/\/www.sharpsightlabs.com\/wp-json\/wp\/v2\/posts\/4706"}],"collection":[{"href":"https:\/\/www.sharpsightlabs.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sharpsightlabs.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sharpsightlabs.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sharpsightlabs.com\/wp-json\/wp\/v2\/comments?post=4706"}],"version-history":[{"count":0,"href":"https:\/\/www.sharpsightlabs.com\/wp-json\/wp\/v2\/posts\/4706\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sharpsightlabs.com\/wp-json\/wp\/v2\/media\/4715"}],"wp:attachment":[{"href":"https:\/\/www.sharpsightlabs.com\/wp-json\/wp\/v2\/media?parent=4706"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sharpsightlabs.com\/wp-json\/wp\/v2\/categories?post=4706"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sharpsightlabs.com\/wp-json\/wp\/v2\/tags?post=4706"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- How can you sort by ascending order and descending order for different variables?<\/a><\/li>\n<\/ul>\n
- Sort a DataFrame by multiple variables<\/a><\/li>\n
- The syntax of Pandas sort_values<\/a><\/li>\n