- Get List of Months Between Two Dates in Python
- Python Create List Of Dates Within Range
- Table of contents
- How to create a list of dates within a date range in Python
- Example: create a list of dates within a range of dates
- Example 3: Create a list of the previous 7 dates starting from the current date
- Generate a date range using pandas
- Example 1: Create a date range by specifying the start and end date with the default daily frequency.
- Example 2: create a date range by specifying the start date and number of dates you want
- Example 3: Createa monthly date range
- About Vishal
- Related Tutorial Topics:
- Python Exercises and Quizzes
- Python: Get a list of dates between two dates
- Visualize Python code execution:
- Python: Tips of the Day
- List All Dates Between Two Dates in Python Example
- You might also like.
Get List of Months Between Two Dates in Python
To get the list of months between two specified dates in Python:
- Use pandas’s period_range() to get list of months between start date and end date with freq=’M’ .
- Use list comprehension to iterate over list of months.
- For each month, use strftime() method to convert it in appropriate format.
The execution of the above program will print the following on the console.
The pandas library is a powerful data analysis and manipulation tool for Python. It provides data structures and operations for manipulating numerical tables and time series.
It supports high-level data structures and functions for working with relational or labelled data. The pandas library provides the pd.period_range() method that creates a TimeSeries object from a date range and returns a tuple of the days between two dates.
It holds start , end , period , and freq as arguments. Of the three parameters: start , end , and period , exactly two must be specified; otherwise, the method will return a ValueError .
We used pd.period_range() to find the months between start_date and end_date by providing the Month end frequency M as an offset alias to the freq .
The strftime() function in Python formats date and time objects into strings according to the specified format. It is a part of the datetime module, which provides various functions for working with dates and times.
Once we got the month_list , we used list comprehension to apply the strftime() method to format every month of month_list using %b-%Y as format codes. There are many other format codes documented.
To print every month in month_list , we provided the print() method with sep=», » to the print statement to print the list separated by a comma.
Python Create List Of Dates Within Range
This step-by-step guide lets you know how to create a list of dates within a range of dates in Python. For example, you may want to create a list of dates from 1st January 2022 to 30th June 2022. Or you may want to generate a list of dates from today to the next/previous 30 days.
Goals of this lesson:
- Generate a list of dates between two dates.
- Iterate through a range of dates.
- Generate a list of dates between two dates using pandas.
- Generate a list of dates so that the difference between each date is 1 month.
Table of contents
How to create a list of dates within a date range in Python
Use the below steps to create a list of dates between two dates in Python using the date and timedelta classes from the datetime module.
- Import the date and timedelta class from a datetime module Use the date class to create dates and the timedelta class to specify the frequency. Frequency means the difference between the current and next date in the result list.
- Define the start date and end date Set the start date and end date using the date class. Dates will get generated between these two dates.
- Specify the frequency using timedelta Use the timedelta class to specify the increment value. This can be anything like 1 second, 1 hour, or 1 day.
Example: create a list of dates within a range of dates
In this example, we specify two dates and create a list with all the dates in between them.
from datetime import date, timedelta start_dt = date(2022, 6, 10) end_dt = date(2022, 6, 15) # difference between current and previous date delta = timedelta(days=1) # store the dates between two dates in a list dates = [] while start_dt Dates between 2022-06-16 and 2022-06-15 [datetime.date(2022, 6, 10), datetime.date(2022, 6, 11), datetime.date(2022, 6, 12), datetime.date(2022, 6, 13), datetime.date(2022, 6, 14), datetime.date(2022, 6, 15)]
Example 2: Create a list of the next 7 dates starting from the current date
Here we’ll use list comprehension to get the desired result.
import datetime num_of_dates = 3 start = datetime.datetime.today() date_list = [start.date() + datetime.timedelta(days=x) for x in range(num_of_dates)] print('Next 3 days starting from today') print(date_list)Next 3 days starting from today [datetime.date(2023, 2, 16), datetime.date(2023, 2, 17), datetime.date(2023, 2, 18)]
Example 3: Create a list of the previous 7 dates starting from the current date
import datetime num_of_dates = 3 start = datetime.datetime.today() date_list = [start.date() - datetime.timedelta(days=x) for x in range(num_of_dates)] print('Previous 3 days starting from today') print(date_list)Previous 3 days starting from today [datetime.date(2023, 2, 16), datetime.date(2023, 2, 15), datetime.date(2023, 2, 14)]
Generate a date range using pandas
We can also use the pandas date_range() to create a list of dates within a date range.
We need to pass the following parameters to the date_range() function.
- start : str or datetime object. The Start date (Left bound for generating dates).
- end : str or datetime object. The end date (Right bound for generating dates).
- periods : Number of periods to generate.
- freq : default ‘D’, which is a calendar day. i.e., Each next date in the list is generated by adding one day to a preceding date. Read this for a list of all frequency aliases.
Of the four parameters, the start, end, periods, and freq, exactly three must be specified.
Example 1: Create a date range by specifying the start and end date with the default daily frequency.
from datetime import datetime import pandas as pd # start date start_date = datetime.strptime("2022-10-17", "%Y-%m-%d") end_date = datetime.strptime("2022-10-23", "%Y-%m-%d") # difference between each date. D means one day D = 'D' date_list = pd.date_range(start_date, end_date, freq=D) print(f"Creating list of dates starting from to ") print(date_list) # if you want dates in string format then convert it into string print(date_list.strftime("%Y-%m-%d")) Creating list of dates starting from 2022-10-17 00:00:00 to 2022-10-23 00:00:00 DatetimeIndex(['2022-10-17', '2022-10-18', '2022-10-19', '2022-10-20', '2022-10-21', '2022-10-22', '2022-10-23'], dtype='datetime64[ns]', freq='D') Index(['2022-10-17', '2022-10-18', '2022-10-19', '2022-10-20', '2022-10-21', '2022-10-22', '2022-10-23'], dtype='object')
Example 2: create a date range by specifying the start date and number of dates you want
from datetime import datetime import pandas as pd start_date = datetime.strptime("2022-10-20", "%Y-%m-%d") # periods means how many dates you want date_list = pd.date_range(start_date, periods=5, freq='D') print(f"Creating list of 5 dates starting from ") print(date_list)Creating list of, 5 dates starting from 2022-10-20 00:00:00 DatetimeIndex(['2022-10-20', '2022-10-21', '2022-10-22', '2022-10-23', '2022-10-24'], dtype='datetime64[ns]', freq='D')
Example 3: Createa monthly date range
Let’s see how to create a date range on specific dates for each month. We need to change the freq (frequency) to ‘M’ (month-end frequency).
from datetime import datetime import pandas as pd start_date = datetime.strptime("2022-10-20", "%Y-%m-%d") date_list = pd.date_range(start_date, periods=5, freq='M') print(f"Creating list of 5 dates starting from with difference in each date is 1 month") print(date_list) # frequency of 6 months print(f"Creating list of 5 dates starting from with difference in each date is 6 month") date_list = pd.date_range(start_date, periods=5, freq='6M') print(date_list)Creating list of 5 dates starting from 2022-10-20 00:00:00 with difference in each date is 1 month DatetimeIndex(['2022-10-31', '2022-11-30', '2022-12-31', '2023-01-31', '2023-02-28'], dtype='datetime64[ns]', freq='M') Creating list of 5 dates starting from 2022-10-20 00:00:00 with difference in each date is 6 month DatetimeIndex(['2022-10-31', '2023-04-30', '2023-10-31', '2024-04-30', '2024-10-31'], dtype='datetime64[ns]', freq='6M')
Did you find this page helpful? Let others know about it. Sharing helps me continue to create free Python resources.
About Vishal
I’m Vishal Hule, Founder of PYnative.com. I am a Python developer, and I love to write articles to help students, developers, and learners. Follow me on Twitter
Related Tutorial Topics:
Python Exercises and Quizzes
Free coding exercises and quizzes cover Python basics, data structure, data analytics, and more.
- 15+ Topic-specific Exercises and Quizzes
- Each Exercise contains 10 questions
- Each Quiz contains 12-15 MCQ
Python: Get a list of dates between two dates
Write a Python program to get a list of dates between two dates.
Sample Solution:
Python Code:
from datetime import timedelta, date def daterange(date1, date2): for n in range(int ((date2 - date1).days)+1): yield date1 + timedelta(n) start_dt = date(2015, 12, 20) end_dt = date(2016, 1, 11) for dt in daterange(start_dt, end_dt): print(dt.strftime("%Y-%m-%d")) 2015-12-20 2015-12-21 2015-12-22 2015-12-23 2015-12-24 2015-12-25 2015-12-26 2015-12-27 2015-12-28 2015-12-29 2015-12-30 2015-12-31 ------- 2016-01-08 2016-01-09 2016-01-10 2016-01-11
Visualize Python code execution:
The following tool visualize what the computer is doing step-by-step as it executes the said program:
Python Code Editor:
Contribute your code and comments through Disqus.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.
Follow us on Facebook and Twitter for latest update.
Python: Tips of the Day
Converting string into datetime:
datetime.strptime is the main routine for parsing strings into datetimes. It can handle all sorts of formats, with the format determined by a format string you give it:
from datetime import datetime datetime_object = datetime.strptime('Jun 1 2005 1:33PM', '%b %d %Y %I:%M%p') The resulting datetime object is timezone-naive.
- Python documentation for strptime: Python 2, Python 3
- Python documentation for strptime/strftime format strings: Python 2, Python 3
- strftime.org is also a really nice reference for strftime
- strptime = "string parse time"
- strftime = "string format time"
- Pronounce it out loud today & you won't have to search for it again in 6 months.
- Weekly Trends
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- JavaScript String Exercises
- JavaScript HTML Form Validation
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join
- JavaScript functions Exercises
- Python Tutorial
- Python Array Exercises
- SQL Cross Join
- C# Sharp Array Exercises
We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook
List All Dates Between Two Dates in Python Example
In this tutorial, you will learn list all dates between two dates in python example. I would like to share with you how to get date range between two dates in python. I would like to show you python get all dates between two dates. We will use python list all dates between two dates.
In this example, I will give two examples one example will get all dates between two dates using datetime and timedelta, and the second example find all dates between two dates using pandas. so let's see both examples and use them for you.
so let's see following examples with output:
from datetime import datetime, timedelta
# Create Custom Function
def date_range(start, end):
delta = end - start
days = [start + timedelta(days=i) for i in range(delta.days + 1)]
return days
startDate = datetime(2022, 6, 1)
endDate = datetime(2022, 6, 10)
datesRange = date_range(startDate, endDate);
print(datesRange)
[
datetime.datetime(2022, 6, 1, 0, 0),
datetime.datetime(2022, 6, 2, 0, 0),
datetime.datetime(2022, 6, 3, 0, 0),
datetime.datetime(2022, 6, 4, 0, 0),
datetime.datetime(2022, 6, 5, 0, 0),
datetime.datetime(2022, 6, 6, 0, 0),
datetime.datetime(2022, 6, 7, 0, 0),
datetime.datetime(2022, 6, 8, 0, 0),
datetime.datetime(2022, 6, 9, 0, 0),
datetime.datetime(2022, 6, 10, 0, 0)
]
import pandas
from datetime import datetime, timedelta
startDate = datetime(2022, 6, 1)
endDate = datetime(2022, 6, 10)
# Getting List of Days using pandas
datesRange = pandas.date_range(startDate,endDate-timedelta(days=1),freq='d')
print(datesRange);
DatetimeIndex(['2022-06-01', '2022-06-02', '2022-06-03', '2022-06-04',
'2022-06-05', '2022-06-06', '2022-06-07', '2022-06-08',
'2022-06-09'
],
dtype='datetime64[ns]', freq='D')
✌️ Like this article? Follow me on Twitter and Facebook. You can also subscribe to RSS Feed.