As I have searched in website to get the number of weekdays in python, but I need the date of the weekdays too.
My input will be:
start date = 01-03-2019
end_date = 15-03-2019
days = monday , tuesday
Expected Output:
which I need is to print the number of mondays and tuesdays along with the date.
Use pandas.to_datetime and pandas.date_range:
import pandas as pd
start_date = '01-03-2019'
end_date = '15-03-2019'
days = ['Monday', 'Tuesday']
dates = pd.to_datetime([start_date, end_date], format='%d-%m-%Y')
pd.date_range(dates[0],dates[1],freq='1d').day_name().value_counts()[days]
Monday 2
Tuesday 2
dtype: int64
Try this :
start_date = '01-03-2019' # Considering 03 is the month, 01 is the day
end_date = '15-03-2019' # Considering 03 is the month, 15 is the day
start_date = [int(i) for i in start_date.split("-")]
end_date = [int(i) for i in end_date.split("-")]
days = 'monday' , 'tuesday'
from datetime import timedelta, date
start_date = date(start_date[-1], start_date[1], start_date[0])
end_date = date(end_date[-1], end_date[1], end_date[0])
# Now check in the range of start_date and end_date with condition .weekday() Monday is 0 and Tuesday is 1.
def daterange(start_date, end_date):
for n in range(int ((end_date - start_date).days)):
yield start_date + timedelta(n)
for single_date in daterange(start_date, end_date):
if single_date.weekday() ==0:
print("Monday : ", single_date)
if single_date.weekday() == 1:
print("Tuesday : ", single_date)
start_date = datetime.strptime(start_date, '%Y-%m-%d')
end_date = datetime.strptime(send_date, '%Y-%m-%d')
step = timedelta(days=1)
while start_date <= end_date:
for day in days:
if day == calendar.day_name[start_date.date().weekday()]:
print calendar.day_name[start_date.date()]
start_date += step
