Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Selected Reading
Write a program in Python to sort all the elements in a given series in descending order
Sorting a Pandas Series in descending order is a common data manipulation task. We can use the sort_values() method with the ascending=False parameter to achieve this.
Creating a Sample Series
First, let's create a Pandas Series with string elements ?
import pandas as pd
data_list = ["abdef", "ijkl", "Abdef", "oUijl"]
series = pd.Series(data_list)
print("Original Series:")
print(series)
Original Series: 0 abdef 1 ijkl 2 Abdef 3 oUijl dtype: object
Sorting in Descending Order
Use the sort_values() method with ascending=False to sort elements in descending order ?
import pandas as pd
data_list = ["abdef", "ijkl", "Abdef", "oUijl"]
series = pd.Series(data_list)
sorted_series = series.sort_values(ascending=False)
print("Sorted Series (Descending):")
print(sorted_series)
Sorted Series (Descending): 3 oUijl 1 ijkl 0 abdef 2 Abdef dtype: object
How String Sorting Works
Pandas sorts strings lexicographically (alphabetically). In descending order:
- Lowercase letters come after uppercase letters in ASCII
- "oUijl" comes first (starts with lowercase 'o')
- "ijkl" comes second (starts with lowercase 'i')
- "abdef" comes third (starts with lowercase 'a')
- "Abdef" comes last (starts with uppercase 'A')
Sorting Numeric Series
The same method works for numeric data ?
import pandas as pd
numbers = [23, 8, 45, 12, 67]
numeric_series = pd.Series(numbers)
sorted_numeric = numeric_series.sort_values(ascending=False)
print("Numeric Series (Descending):")
print(sorted_numeric)
Numeric Series (Descending): 4 67 2 45 0 23 3 12 1 8 dtype: int64
Conclusion
Use sort_values(ascending=False) to sort a Pandas Series in descending order. The original index positions are preserved, making it easy to track where each element came from in the original Series.
Advertisements
