Series sorting in Data Analysis Python - Mini Project: Build & Apply

Series sorting

📖 Scenario: You work in a small shop and keep track of daily sales using a list of numbers. You want to organize these sales numbers to see which days had the highest and lowest sales.

🎯 Goal: Sort a pandas Series of daily sales numbers in ascending and descending order to understand sales trends.

📋 What You'll Learn

Create a pandas Series with exact daily sales values

Create a variable to hold the sorting order

Sort the Series using the variable for ascending or descending order

Print the sorted Series

💡 Why This Matters

🌍 Real World

Sorting sales data helps shop owners quickly see which days perform best or worst, aiding in planning and stock management.

💼 Career

Data analysts often sort data to find trends and make decisions based on ordered information.

1

Create the sales data Series

Create a pandas Series called sales with these exact daily sales values: 250, 400, 150, 300, 500.

Data Analysis Python

import pandas as pd
# Create the sales Series with the exact values
# Your code here

Need a hint?

Use pd.Series and pass the list of sales numbers inside square brackets.

2

Set the sorting order

Create a variable called ascending_order and set it to True to sort the sales in ascending order.

Data Analysis Python

import pandas as pd
sales = pd.Series([250, 400, 150, 300, 500])
# Create the variable ascending_order and set it to True
# Your code here

Need a hint?

Just assign the value True to the variable ascending_order.

3

Sort the sales Series

Create a new Series called sorted_sales by sorting the sales Series using the ascending_order variable to decide the order.

Data Analysis Python

import pandas as pd
sales = pd.Series([250, 400, 150, 300, 500])
ascending_order = True
# Sort the sales Series using ascending_order and save it as sorted_sales
# Your code here

Need a hint?

Use the sort_values() method on sales and pass ascending=ascending_order.

4

Print the sorted sales

Print the sorted_sales Series to see the sales sorted in ascending order.

Data Analysis Python

import pandas as pd
sales = pd.Series([250, 400, 150, 300, 500])
ascending_order = True
sorted_sales = sales.sort_values(ascending=ascending_order)
# Print the sorted_sales Series
# Your code here

Need a hint?

Use print(sorted_sales) to display the sorted Series.