Skip to content Skip to sidebar Skip to footer

Generating Recurring Dates Using Python?

How can I generate recurring dates using Python? For example I want to generate recurring date for 'Third Friday of every second month'. I want to generate recurring dates for dail

Solution 1:

import dateutil.rrule as dr
import dateutil.parser as dp
import dateutil.relativedelta as drel

start=dp.parse("19/02/2010")   # Third Friday in Feb 2010

This generates the third Friday of every month

rr = dr.rrule(dr.MONTHLY,byweekday=drel.FR(3),dtstart=start, count=10)

This prints every third Friday:

print map(str,rr)
# ['2010-02-19 00:00:00', '2010-03-19 00:00:00', '2010-04-16 00:00:00', '2010-05-21 00:00:00', '2010-06-18 00:00:00', '2010-07-16 00:00:00', '2010-08-20 00:00:00', '2010-09-17 00:00:00', '2010-10-15 00:00:00', '2010-11-19 00:00:00']

rr is an iterable, so you can use slicing notation to pick out every other item. This prints the third Friday of every other month:

print map(str,rr[::2])
# ['2010-02-19 00:00:00', '2010-04-16 00:00:00', '2010-06-18 00:00:00', '2010-08-20 00:00:00', '2010-10-15 00:00:00']

Above, I used str to prettify the output a little bit. For more flexible string formatting of dates, use strftime: See http://au2.php.net/strftime or the man page for strftime for all the options.

print [d.strftime('%d/%m/%Y') for d in rr[::2]]
# ['19/02/2010', '16/04/2010', '18/06/2010', '20/08/2010', '15/10/2010']

Solution 2:

You can give dateutil a try - especially its relativedelta and rrule fetures.

Solution 3:

you may try to write this yourself. you will first need an iterator which generates dates separated by a given interval:

import datetime

defdateiter(start, resolution):
    date = start
    whileTrue:
            yield date
            date += resolution

now, you can generate dates and filter them:

# generate a list of every tuesday of february# this iterates over every day from now, and filtered according to the rules# warning: infinite generator below, there is nothing to end the iteration
tuesdays_of_february = (datefordatein dateiter(datetime.datetime.now(), datetime.timedelta(days=1)) if date.weekday() == 4 and date.month == 2)

you can call the iterator yourself until you have enough dates:

>>>next(tuesdays_of_february)
datetime.datetime(2010, 2, 19, 14, 25, 46, 171000)

now, you need to limit the results:

>>>from itertools import *>>>>>># get the five next valid dates:>>>list(islice(tuesdays_of_february),5)
[datetime.datetime(2010, 2,26, 14, 25, 46, 171000), datetime.datetime(2011, 2, 4
, 14, 25, 46, 171000), datetime.datetime(2011, 2, 11, 14, 25, 46, 171000), datet
ime.datetime(2011, 2, 18, 1    4, 25, 46, 171000), datetime.datetime(2011, 2, 25
, 14, 25, 46, 171000)]
>>>>>># or until a condition is met:>>>list(takewhile( lambda date: date.year < 2014, tuesdays_of_february ))
[datetime.datetime(2012, 2, 3, 14, 25, 46, 171000), datetime.datetime(2012, 2, 1
0, 14, 25, 46, 171000), datetime.datetime(2012, 2, 17, 14, 25, 46, 171000), date
time.datetime(2012, 2, 24, 14, 25, 46, 171000), datetime.datetime(2013, 2, 1, 14
, 25, 46, 171000), datetime.datetime(2013, 2, 8, 14, 25, 46, 171000), datetime.d
atetime(2013, 2, 15, 14, 25, 46, 171000), datetime.datetime(2013, 2, 22, 14, 25,
 46, 171000)]

don't forget to have a look at the documentation for the datetime module.

Post a Comment for "Generating Recurring Dates Using Python?"