Date range creation with date_range in Pandas - Mini Project: Build & Apply

Date range creation with date_range

📖 Scenario: You work in a small business that tracks daily sales. You want to create a list of dates to analyze sales data for a specific period.

🎯 Goal: Create a date range using pandas date_range function to generate daily dates between two given dates.

📋 What You'll Learn

Use pandas library

Create a date range from a start date to an end date

Store the date range in a variable

Print the date range

💡 Why This Matters

🌍 Real World

Businesses often need to analyze data over specific time periods. Creating date ranges helps organize and prepare data for daily, weekly, or monthly reports.

💼 Career

Data analysts and scientists frequently generate date ranges to filter, group, or visualize time series data in their work.

1

Import pandas and create start and end date strings

Import the pandas library as pd. Then create two string variables: start_date with value '2024-01-01' and end_date with value '2024-01-07'.

Pandas

import pandas as pd
# Create start_date and end_date strings
# Your code here

Need a hint?

Use import pandas as pd to import pandas. Assign the dates as strings to variables start_date and end_date.

2

Create a date range variable using pd.date_range

Create a variable called dates that uses pd.date_range with start_date and end_date as arguments to generate daily dates.

Pandas

import pandas as pd
start_date = '2024-01-01'
end_date = '2024-01-07'
# Create dates using pd.date_range with start_date and end_date
# Your code here

Need a hint?

Use pd.date_range(start=start_date, end=end_date) to create the date range.

3

Check the type and length of the date range

Use a print statement to display the type of dates using type(dates) and the length of dates using len(dates).

Pandas

import pandas as pd
start_date = '2024-01-01'
end_date = '2024-01-07'
dates = pd.date_range(start=start_date, end=end_date)
# Print the type and length of dates
# Your code here

Need a hint?

Use print(type(dates)) and print(len(dates)) to check the object and how many dates it contains.

4

Print the full date range

Print the variable dates to display all the dates in the range.

Pandas

import pandas as pd
start_date = '2024-01-01'
end_date = '2024-01-07'
dates = pd.date_range(start=start_date, end=end_date)
print(type(dates))
print(len(dates))
# Print the dates variable
# Your code here

Need a hint?

Use print(dates) to show all the dates in the range.