Ascending and descending order in Pandas - Step-by-Step Execution

Concept Flow - Ascending and descending order

Start with DataFrame

↓

Choose column(s) to sort

↓

Apply sort_values()

↓

Set ascending=True or False

↓

Get sorted DataFrame

↓

Use or display sorted data

We start with a DataFrame, pick columns to sort, apply sort_values() with ascending True or False, and get the sorted DataFrame.

Execution Sample

Pandas

import pandas as pd

df = pd.DataFrame({'Name': ['Anna', 'Bob', 'Cara'], 'Age': [25, 30, 22]})
sorted_df = df.sort_values(by='Age', ascending=True)
print(sorted_df)

This code sorts the DataFrame by the 'Age' column in ascending order and prints the result.

Execution Table

Step	Action	DataFrame State	Result
1	Create DataFrame	[{'Name': 'Anna', 'Age': 25}, {'Name': 'Bob', 'Age': 30}, {'Name': 'Cara', 'Age': 22}]	Original DataFrame created
2	Call sort_values(by='Age', ascending=True)	Same as step 1	DataFrame sorted by Age ascending: Cara(22), Anna(25), Bob(30)
3	Print sorted DataFrame	Sorted DataFrame	Output shows rows ordered by Age ascending
4	Call sort_values(by='Age', ascending=False)	Same as step 1	DataFrame sorted by Age descending: Bob(30), Anna(25), Cara(22)
5	Print sorted DataFrame	Sorted DataFrame	Output shows rows ordered by Age descending
6	End	No change	Sorting complete

💡 Sorting ends after printing sorted DataFrames in ascending and descending order.

Variable Tracker

Variable	Start	After Step 2	After Step 4	Final
df	[Anna 25, Bob 30, Cara 22]	[Anna 25, Bob 30, Cara 22]	[Anna 25, Bob 30, Cara 22]	[Anna 25, Bob 30, Cara 22]
sorted_df	None	[Cara 22, Anna 25, Bob 30]	[Bob 30, Anna 25, Cara 22]	[Bob 30, Anna 25, Cara 22]

Key Moments - 2 Insights

Why does the original DataFrame 'df' not change after sorting?

Because sort_values() returns a new sorted DataFrame and does not modify 'df' unless you use inplace=True. See execution_table steps 2 and 4 where 'df' stays the same.

What does the 'ascending' parameter control?

It controls if the sorting is from smallest to largest (True) or largest to smallest (False). See execution_table steps 2 and 4 for ascending=True and ascending=False results.

Visual Quiz - 3 Questions

Look at the execution_table at step 2, what is the order of names in sorted_df?

A Bob, Anna, Cara

B Anna, Bob, Cara

C Cara, Anna, Bob

D Cara, Bob, Anna

💡 Hint

Check the 'Result' column at step 2 in execution_table.

At which step does sorted_df show descending order by Age?

A Step 4

B Step 2

C Step 3

D Step 5

💡 Hint

Look for ascending=False in the 'Action' column in execution_table.

If we set inplace=True in sort_values(), what changes in variable_tracker?

A 'df' would be deleted

B 'df' would change after sorting steps

C 'sorted_df' would be None

D No change in any variable

💡 Hint

Recall that inplace=True modifies the original DataFrame, affecting 'df' in variable_tracker.

Concept Snapshot

pandas.DataFrame.sort_values(by=column, ascending=True)
- Sorts DataFrame rows by column values
- ascending=True for low to high, False for high to low
- Returns new sorted DataFrame unless inplace=True
- Use to organize data for analysis or display

Full Transcript

We start with a DataFrame containing names and ages. We use the pandas function sort_values() to order the rows by the 'Age' column. Setting ascending=True sorts from youngest to oldest. The function returns a new DataFrame sorted accordingly, leaving the original unchanged. Setting ascending=False sorts from oldest to youngest. This helps us see data in order we want without changing the original data unless we specify inplace=True. The variable tracker shows how the sorted DataFrame changes while the original stays the same. This step-by-step trace helps understand sorting in pandas clearly.

Practice

1. What does setting ascending=False do when sorting a pandas DataFrame?

easy

A. Sorts the data from largest to smallest values

B. Sorts the data from smallest to largest values

C. Leaves the data unsorted

D. Sorts the data alphabetically only

Solution

1. Step 1: Understand the ascending parameter

   The ascending parameter controls the order of sorting: True means smallest to largest, False means largest to smallest.

2. Step 2: Apply the meaning of ascending=False

   Setting ascending=False sorts the data from the largest values down to the smallest values.

3. Final Answer:

   Sorts the data from largest to smallest values -> Option A

4. Quick Check:

   ascending=False = largest to smallest [OK]

Hint: False means descending order, largest first [OK]

Common Mistakes:

• Confusing ascending=False with ascending=True
• Thinking it sorts alphabetically only
• Assuming it leaves data unsorted

2. Which of the following is the correct syntax to sort a DataFrame df by column 'age' in ascending order?

easy

A. df.sort('age', ascending=True)

B. df.sort_values('age', ascending=True)

C. df.sort_values(by='age', ascending=True)

D. df.sort_values(by='age', ascending=False)

Solution

1. Step 1: Recall the correct pandas sorting method

   The correct method to sort a DataFrame by column is sort_values() with the parameter by='column_name'.

2. Step 2: Check the ascending parameter and syntax

   To sort ascending, use ascending=True. df.sort_values(by='age', ascending=True) uses the correct method and parameters.

3. Final Answer:

   df.sort_values(by='age', ascending=True) -> Option C

4. Quick Check:

   sort_values(by=col, ascending=True) is correct [OK]

Hint: Use sort_values(by=col, ascending=True) for ascending sort [OK]

Common Mistakes:

• Using df.sort instead of df.sort_values
• Mixing ascending True/False values
• Omitting 'by=' keyword

3. Given the DataFrame:

import pandas as pd
df = pd.DataFrame({'name': ['Anna', 'Bob', 'Cara'], 'score': [88, 92, 85]})
print(df.sort_values(by='score', ascending=False))

What will be the output?

medium

A. Rows sorted by score from highest to lowest

B. Error because ascending must be True

C. Rows sorted by name alphabetically

D. Rows sorted by score from lowest to highest

Solution

1. Step 1: Understand the sorting code

   The code sorts the DataFrame by the 'score' column with ascending=False, meaning from highest to lowest score.

2. Step 2: Predict the sorted order

   Scores are 88, 92, 85. Sorted descending: 92 (Bob), 88 (Anna), 85 (Cara).

3. Final Answer:

   Rows sorted by score from highest to lowest -> Option A

4. Quick Check:

   ascending=False sorts descending [OK]

Hint: False sorts descending, highest first [OK]

Common Mistakes:

• Thinking ascending=False sorts ascending
• Confusing sorting by name vs score
• Expecting an error from ascending=False

4. What is wrong with this code snippet?

df.sort_values(by='height', ascending='False')

medium

A. sort_values does not accept ascending parameter

B. The column name must be a list, not a string

C. No error, code is correct

D. ascending should be a boolean, not a string

Solution

1. Step 1: Check the type of ascending parameter

   The ascending parameter expects a boolean value: True or False, not a string.

2. Step 2: Identify the error in the code

   Here, ascending='False' is a string, which will cause unexpected behavior or error.

3. Final Answer:

   ascending should be a boolean, not a string -> Option D

4. Quick Check:

   ascending must be True/False boolean [OK]

Hint: Use True/False without quotes for ascending [OK]

Common Mistakes:

• Passing 'False' as string instead of boolean
• Thinking column name must be list always
• Assuming no error with wrong ascending type

5. You have a DataFrame df with columns 'city' and 'temperature'. You want to sort it first by 'city' alphabetically ascending, then by 'temperature' descending. Which code does this correctly?

hard

A. df.sort_values(by=['city', 'temperature'], ascending=False)

B. df.sort_values(by=['city', 'temperature'], ascending=[True, False])

C. df.sort_values(by=['temperature', 'city'], ascending=[False, True])

D. df.sort_values(by=['city', 'temperature'], ascending=[False, True])

Solution

1. Step 1: Understand multi-column sorting

   To sort by multiple columns, pass a list to by and a list of booleans to ascending matching each column.

2. Step 2: Match sorting order to columns

   We want 'city' ascending (True) and 'temperature' descending (False), so ascending=[True, False].

3. Final Answer:

   df.sort_values(by=['city', 'temperature'], ascending=[True, False]) -> Option B

4. Quick Check:

   Multi-column sort uses list of booleans [OK]

Hint: Use ascending list matching columns for multi-sort [OK]

Common Mistakes:

• Using single boolean for multi-column ascending
• Swapping column order in by list
• Mixing ascending True/False order