Getting a list of months between two dates

Question

I need to implement the code which will help me to get the list of months between two dates.

I already have the code which will give the month delta , That is the number of months.

Actually, I need the way to achieve getting the list of months between two dates.

Here it is code for getting month delta.

import calendar
import datetime

def calculate_monthdelta(date1, date2):
    def is_last_day_of_the_month(date):
        days_in_month = calendar.monthrange(date.year, date.month)[1]
        return date.day == days_in_month
    imaginary_day_2 = 31 if is_last_day_of_the_month(date2) else date2.day
    monthdelta = (
        (date2.month - date1.month) +
        (date2.year - date1.year) * 12 +
        (-1 if date1.day > imaginary_day_2 else 0)
        )
    print monthdelta
    return monthdelta

date2 = datetime.datetime.today()
date1 = date2.replace(month=01)

calculate_monthdelta(date1, date2)

Now I need the way to get the list of months between the same.

Any help is appreciated If there is any way to get the list of months between two dates.

Note: Please suggest any idea (If available) apart from the code I have used here.

refer : http://stackoverflow.com/questions/4039879/best-way-to-find-the-months-between-two-dates — Harsha Biyani, May 26 '16 at 09:17
https://stackoverflow.com/questions/34898525/generate-list-of-months-between-interval-in-python/34899127 ? — Lev, Jun 06 '19 at 19:32

score 13 · Answer 1 · answered May 26 '16 at 11:21

13

try this

import datetime
import time
from dateutil.rrule import rrule, MONTHLY
months = [dt.strftime("%m") for dt in rrule(MONTHLY, dtstart=date1, until=date2)]
print months

answered May 26 '16 at 11:21

cheng chen

479
1
4
6

score 0 · Answer 2 · answered Nov 28 '22 at 09:40

You can use the datae_range function in pandas library.

import pandas as pd

months = pd.date_range(data1, date2, freq="MS").strftime("%Y-%m").tolist()

It will give you a list of all months with the selected format (here in "%Y-%m") in the range of date1 and date2 which looks like somewhat like this:

['2012-01', '2012-02', '2012-03', '2012-04', '2012-05']

If you want only the distinct months between date1 and date2, you can use datae_range function like this:

months = pd.date_range(date1, date2, freq="MS").strftime("%m").tolist()
months = list(dict.fromkeys(months))

And the output looks like this:

['01', '02', '03', '04', '05']

score -1 · Answer 3 · edited May 26 '16 at 10:32

-1

Change your print statement to:
print calendar.month_name[:monthdelta]

edited May 26 '16 at 10:32

shivsn

7,680
1
26
33

answered May 26 '16 at 09:41

NNNN

1
2

score -1 · Answer 4 · answered May 26 '16 at 09:57

Because I don't know your desired output I can't format mine, but this returns an integer of the total number of months between two dates.

def calculate_monthdelta(date1, date2):
    print abs(date1.year - date2.year) * 12 + abs(date1.month - date2.month)

Getting a list of months between two dates

4 Answers4