medium Data Analysis

Filter Sales by Date Range

The Brief

A line manager wants to see only the sales between two specific dates. Convert the Date column to proper pandas datetime values, then filter the DataFrame to rows that fall between two dates inclusive. Print the resulting subset and its total revenue.

Acceptance Criteria

Tap a criterion to mark it off as you work. Tap a category header to expand or collapse.

1 Load the dataset and parse the Date column to datetime using pd.to_datetime or the parse_dates argument

2 Define a start date and end date (use 2024-05-03 and 2024-05-06)

3 Filter rows where Date is between start and end inclusive using .between() or boolean comparison

5 Print the total revenue for the filtered rows formatted with 2 decimal places

4 Print the filtered DataFrame

💡 Hints 0 / 3

Guest Mode Attempt this challenge freely, or log in to earn EXP & CodeCoins.

solution.py

Python 3

import pandas as pd
import io

data = """Date,Product,Revenue
2024-05-01,Widget A,100.00
2024-05-02,Widget B,150.00
2024-05-03,Widget A,200.00
2024-05-04,Widget C,75.00
2024-05-05,Widget B,180.00
2024-05-06,Widget A,220.00
2024-05-07,Widget C,90.00
2024-05-08,Widget B,140.00"""

df = pd.read_csv(io.StringIO(data))

# Parse Date as datetime
# Filter between 2024-05-03 and 2024-05-06 inclusive
# Print the subset and its total revenue

Console