Converting Pandas DataFrame to a table of hourly blocks

[Abedin]

Hello everyone,

I have a data frame that I'd like to visualize as a table (see attached file). Is that possible with pandas? Your help will be very much appreciated.

import pandas as pd
import numpy as np

df = pd.DataFrame({'courseid':['CHEM1250', 'CHEM1250', 'CHEM1250', 'PHYS1200', 'PHYS1200', 'BIOL1150', 'BIOL1150'], \
                   'coursesec':['L01', 'L02', 'L03', 'L01','L02','L01','L01'], \
                   'Day':['Monday','Tuesday','Friday','Tuesday','Thursday','Wednesday','Wednesday'], \
                   'starttime':['8:00', '12:00', '13:00', '9:00', '11:00', '8:00', '13:00'], \
                   'endtime':['9:30', '12:30', '14:00', '10:30','12:00', '9:30', '14:30'], \
                   'instructorid':['John', 'John', 'Bob', 'Jenna', 'Michel', 'Michel', 'Alice']})

print(df)