XQA
Back to Python
2026-02-126 min read

Sort Table (Python Programming)

Learn Sort Table (Python Programming) step by step with clear examples and exercises.

Why This Matters

Sorting data is an essential skill for any programmer, and it's particularly important when working with tables of data. In this lesson, you will learn how to sort a table using Python programming. Understanding this concept can help you tackle real-world problems, such as organizing large datasets or preparing data for analysis.

Sorting data enables us to:

  1. Organize data in a meaningful way for easier interpretation and analysis.
  2. Facilitate the identification of patterns, trends, and outliers within the data.
  3. Improve the efficiency of searching and retrieving specific records from large datasets.
  4. Enhance the visual appeal of tables by presenting data in an orderly fashion.

Prerequisites

To follow this lesson, you should have a basic understanding of the following:

  • Python syntax and variables
  • Lists in Python
  • Basic file I/O operations (reading and writing files)
  • Data structures like dictionaries and tuples
  • Conditional statements (if-else)
  • Understanding the concept of functions, especially the built-in sort() function
  • Familiarity with the pandas library is not required but will be covered in this lesson.

Core Concept

In Python, you can sort a list using the built-in sort() function. However, when dealing with tables, it's more convenient to use libraries like pandas. In this lesson, we will focus on using pandas for sorting tables.

Installing pandas

Before proceeding, make sure you have pandas installed in your Python environment. You can install it using the following command:

pip install pandas

Importing pandas

Start by importing the pandas library:

import pandas as pd

Reading a CSV file

To work with tables, we'll first read a CSV (Comma Separated Values) file using pandas. Here's an example of reading a CSV file named data.csv:

df = pd.read_csv('data.csv')

In the above code, df is a DataFrame object that represents our table.

Sorting a DataFrame

Now that we have our data in a DataFrame, we can sort it using the sort_values() function:

df_sorted = df.sort_values(by='column_name')

Replace 'column_name' with the name of the column you want to sort by. The sort_values() function sorts the DataFrame in ascending order by default. If you want to sort in descending order, set the ascending=False parameter:

df_sorted = df.sort_values(by='column_name', ascending=False)

Saving the sorted DataFrame

Finally, let's save our sorted DataFrame to a new CSV file:

df_sorted.to_csv('sorted_data.csv', index=False)

The index=False parameter prevents pandas from writing row indices into the output file.

Sorting based on multiple columns

You can sort a DataFrame by multiple columns using the by parameter and passing a list of column names:

df_sorted = df.sort_values(by=['column1', 'column2'])

Sorting in place (without creating a new DataFrame)

To sort a DataFrame in place, use the sort_inplace() function:

df.sort_values(by='column_name', inplace=True)

Understanding the built-in sort() function

The built-in sort() function sorts a list, but it only works with lists and does not support sorting multi-dimensional data structures like dictionaries or DataFrames. Here's an example of using the sort() function:

numbers = [5, 3, 1, 4, 2]
numbers.sort()
print(numbers) # Output: [1, 2, 3, 4, 5]

Sorting a list using custom sorting order

You can sort a list using a custom sorting order by providing a comparison function to the sorted() function. Here's an example where we sort a list of strings in reverse alphabetical order:

words = ['apple', 'banana', 'cherry', 'date']
words_sorted = sorted(words, reverse=True)
print(words_sorted) # Output: ['date', 'cherry', 'banana', 'apple']

Worked Example

Let's work through an example to better understand sorting tables in Python using pandas:

  1. First, create a CSV file named data.csv with the following content:
Name,Age,Score
Alice,25,85
Bob,30,90
Charlie,20,70
David,28,80
Eve,35,95
  1. Import pandas and read the CSV file:
import pandas as pd
df = pd.read_csv('data.csv')
  1. Sort the DataFrame by Age in ascending order:
df_sorted = df.sort_values(by='Age')
  1. Save the sorted DataFrame to a new CSV file:
df_sorted.to_csv('sorted_data.csv', index=False)

After running this code, you will find a new file named sorted_data.csv with the following content:

Name,Age,Score
Charlie,20,70
Alice,25,85
David,28,80
Bob,30,90
Eve,35,95

Common Mistakes

  1. Not importing pandas: Make sure you have imported the pandas library before using it in your code.
  1. Incorrect column name: Ensure that you use the correct column name when sorting the DataFrame.
  1. Forgetting to save the sorted DataFrame: After sorting the DataFrame, don't forget to save it to a new CSV file using the to_csv() function.
  1. Not providing the correct parameter for sorting in place: When sorting in place, make sure you set the inplace=True parameter in the sort_values() function.
  1. Sorting based on multiple columns without using a list: When sorting by multiple columns, use a list of column names instead of passing them as separate arguments.
  1. Not understanding the built-in sort() function: Remember that the built-in sort() function only works with lists and does not support multi-dimensional data structures like dictionaries or DataFrames.

Common Mistakes (CONT'D)

  1. Using the wrong sorting method for a specific use case: The built-in sorted() function allows you to choose from various sorting algorithms, each with its own strengths and weaknesses. For example, using MergeSort for small lists might be less efficient than QuickSort or BubbleSort due to their higher constant factors.
  1. Not handling custom sorting order: When working with complex data structures like dictionaries, you may need to implement a custom comparison function to sort the data in a specific order.
  1. Ignoring edge cases: Be aware of edge cases when sorting data, such as handling empty lists or strings, dealing with ties, and ensuring that your code handles unexpected input gracefully.

Practice Questions

  1. Given the following CSV data:
Name,Score
John,80
Mike,95
Sarah,75
Jane,90

Sort the DataFrame by Score in descending order and save it to a new CSV file named sorted_data.csv.

  1. You have a CSV file containing student data with columns Name, Age, and GPA. Write Python code to read this file, sort it by GPA in ascending order, and save the sorted DataFrame to a new CSV file named sorted_data.csv.
  1. Given the following CSV data:
Name,Age,Score
Alice,25,85
Bob,30,90
Charlie,20,70
David,28,80
Eve,35,95

Sort the DataFrame by Age in ascending order and Score in descending order, and save it to a new CSV file named sorted_data.csv.

  1. Write Python code to sort a list of tuples containing student information (Name, Age, GPA) using a custom comparison function that sorts students first by age, then by GPA, and finally by name in alphabetical order. Save the sorted list as a new CSV file named sorted_data.csv.

FAQ

  1. Can I sort a DataFrame by multiple columns?

Yes! You can use the sort_values() function with multiple column names:

df_sorted = df.sort_values(by=['column1', 'column2'])
  1. How do I sort a DataFrame in place (without creating a new DataFrame)?

To sort a DataFrame in place, use the sort_inplace() function:

df.sort_values(by='column_name', inplace=True)
  1. How do I handle ties when sorting by multiple columns?

By default, pandas sorts rows with equal values in the first sorted column before moving on to the next column. If you want to specify a different tie-breaking rule, use the kind parameter:

df_sorted = df.sort_values(by=['column1', 'column2'], kind='mergesort')
  1. What are some common sorting algorithms used in Python?

Python provides several built-in sorting algorithms, including:

  • TimSort (used by the sort() function)
  • MergeSort
  • QuickSort
  • HeapSort
  • BubbleSort

Each algorithm has its own advantages and trade-offs in terms of efficiency and complexity.

  1. How do I sort a list using a custom comparison function?

To sort a list using a custom comparison function, pass the function as an argument to the sorted() function:

def custom_comparison(a, b):

Your custom comparison logic here

return ...

numbers = [5, 3, 1, 4, 2]

numbers_sorted = sorted(numbers, key=custom_comparison)

Sort Table (Python Programming) | Python | XQA Learn