This is the holiday list

  • 1-Jan-21 New Year
  • 16-Jan-21 Shankaranthi
  • 26-Jan-21 Republic Day
  • 18-Feb-21 ID Day
  • 1-May-21 May Day
  • 15-Aug-21 Independence Day
  • 1-Nov-21 Karanataka Day

I have created a .CSV file and imported my holiday list as dataframe.

H = pd.read_csv('HolidayC.csv')
H1 = H.drop(['Holi_id'], axis = 1)

Output of Holidayc.csv I then later imported my shift timings

sft = pd.read_csv('SHIFT.csv')

Output of shift timings I have created the the following code to generate Dates from 1/Jan/2021 to 31/dec/2021:

    import pandas as pd
    import numpy as np
    import datetime as dt
    from datetime import datetime
    import random
    start_date = dt.date(2021,1,1)
    end_date = dt.date(2021,12,31)
    rstr=pd.DataFrame(columns=['Date','Reason','Day','Name','shift_desc','Start Time','End Time',])
   required_date = []
weekday = []

daterange = pd.date_range(start_date, end_date)
for single_date in daterange:

rstr['Date'] = required_date
rstr['Day'] = weekday  

I want to Know how I can replace holiday dates with reason in my rstr table. Kindly help.

Anonymous Asked question May 14, 2021