ts_clip = ts.iloc[np.argwhere(ts.index.hour.__eq__(17)).ravel()[0]:]
ts_clip_shift = ts_clip.tshift(-17, freq='H')
df = pd.pivot_table(ts_clip_shift, index=ts_clip_shift.index + pd.offsets.
    Day(n=1), columns=ts_clip_shift.index.time, values=0)
df.columns = ts_clip.iloc[:len(df.columns)].index.time
How to pivot a pandas dataframe using a modified index?