🎉 AI Engineers: Join our free webinar on how to improve your RAG performance. Secure your spot >

Aporia How to's

How to Sort a DataFrame by Values in a Column?

2 min read
sort dataframe by values in column pandas pyspark

In this short how-to article, we will learn how to sort the rows of a DataFrame by the value in a column in Pandas and PySpark.

Sort DataFrame by Column Values DataFrame - Pandas PySpark


The sort_values function can be used for this task. We just need to give it the column name.


By default, the index of the rows prior to sorting are kept, which is not an ideal situation. We can change this behavior by using the ignore_index parameter.

df.sort_values(by="Age", ignore_index=True)

By default, the values are sorted in ascending order and this can be changed using the ascending parameter.

df.sort_values(by="Age", ignore_index=True, ascending=False)


The orderBy function can be used for this task. The syntax is similar to that of the sort_values function of Pandas.


The orderBy also sorts rows in ascending order. We can use the ascending parameter to sort in descending order.

df.orderBy("number", ascending=False)

This question is also being asked as:

  • How to sort Pandas DataFrame by column?

People have also asked for:

Green Background

Control All your GenAI Apps in minutes