Correct multiple record
I have a hourly time_series dataset in which I need to correct an attribute multiple times
DataSet is Date_time (dd/mm/yy hh:mm), Holiday (polynominal/name of holiday), temperature (kelvin)
The error holiday is only applied to the first record of the day eg 25/12/18 12:00am rather than applied to every hour of the day. I need to correct the data set so that for each hour of the day the record has the holiday associated with it.
25/12/18 12:00am = Christmas
25/12/18 1:00am = None
25/12/18 2:00am = None
I can generate a subset of the holidays but I can't work out how to correct all the incorrect examples
Any guidance on how to approach this would be fantastic'