Fill the obtained day classification in its hour interval? Pandas Python

Question

I am trying to fill an hour interval DataFrame with a whole Day classification, you can copy/paste the code, it should run:

import pandas as pd
from datetime import timedelta, date

colum2 = [1, 2, 3, 4, 7, 8, 9, 10]
colum1 = [item for item in range(1, 74)]
colum3 = pd.date_range('1998-01-01 00:00', freq='h', periods=73, tz ='Etc/GMT+0' )
colum4 = ['1998-01-01 00:00:00', '1998-01-01 01:00:00', '1998-01-01 02:00:00', '1998-01-01 03:00:00 ', 
          '1998-01-01 06:00:00', '1998-01-01 07:00:00', '1998-01-01 08:00:00', '1998-01-01 09:00:00']
colum5 = ['1998-01-01', '1998-01-02', '1998-01-03']
colum6 = ['Overcast', 'Clear', 'High']

dtst_1 = pd.DataFrame()
dtst_1['colum1'] = colum1
dtst_1.set_index(colum3, inplace=True)

dtst_2 = pd.DataFrame()
dtst_2['colum2'] = colum2
dtst_2['colum4'] = colum4
dtst_2['colum4'] = pd.to_datetime(dtst_2['colum4'])
dtst_2.set_index('colum4', inplace=True)

dtst_3 = pd.DataFrame()
dtst_3['colum6'] = colum6
dtst_3['colum5'] = colum5
dtst_3['colum5'] = pd.to_datetime(dtst_3['colum5'])
dtst_3.set_index('colum5', inplace=True)


dtst_2.index = pd.to_datetime(dtst_2.index).tz_localize('Etc/GMT+0')
dtst_3.index = pd.to_datetime(dtst_3.index).tz_localize('Etc/GMT+0')
dtst_2 = dtst_2.merge(dtst_1['colum1'], how = 'right', left_index=True, right_index=True)

def daterange_tst(start_date_tst, end_date_tst):
    for n in range(int ((end_date_tst - start_date_tst).days)):
        yield start_date_tst + timedelta(n)

start_date_tst = date(1998, 1, 1)
end_date_tst = date(1998, 1, 2)

for single_date_tst in daterange_tst(start_date_tst, end_date_tst):
    print(single_date_tst)
    dtst_2 = dtst_2.join(dtst_3['colum6'], how = 'outer')

dtst_2.head(49)

and you should see this result:dataframe

Is there any way to fill the NaN gaps in colum6 with the day classification? (day 1 fill with Overcast, day 2 fill with Clear... etc...? Assuming, of course, that this is just a small section of a huge dataset, so is there any way to insert the classified day into the intra-hour range of that day? Thank you so much.

Answer 1

Is this what you are trying to do ?

dtst_2['colum6'].ffill(inplace=True)