Parse a UVic grade sheet. Obviously a lot is hardcoded

parsegrades.py

import pandas

df = pandas.read_excel('ClassListGradeEntry_07-02-2017_11-15-08_AM.xls')

for ii in range(6):
    for col in range(len(df.loc[ii])-2):
        if (col in [11,15]):
            print('--------------------------------------------------------------')
        if col in [0,1,16]:
            print('%20s: %20s'%(df.keys()[col],df.loc[ii][col]))
        else:
            print('%20s: %20s  out of %1s'%(df.keys()[col],df.loc[ii][col],df.loc[6][col]))
    print('\n\n')