Hamilton Computer Mentor

Script to parse xls file of Hamilton Computer Mentor Data

I want to skiprows on the excelfile when it open it like i do with read_excel. Other option is to get the excel file sheets saved off as

Script to write the excel file. It knows the date and time (fridays 1-3 for me). It knows my name (william). It asks for input on the help I provided, and amount of people assisted.

Clean up current data. reduced date down to set, need to join times and date, recreate the data entry.

Make it a json object.

update for a login. name, date/time,

import pandas
import numpy as np

menfor = pandas.read_excel('/home/wcmckee/Desktop/mentorform.xlsx', skiprows=5)

shenam = pandas.ExcelFile('/home/wcmckee/Desktop/mentorform.xlsx')

menlis = list()

blahmen =menfor.Mentor.get_values()

lisitem = list()

setitem = set(lisitem)

setitem

lisppl = list()

for blst in set(blahmen):
    print (blst)
    lisppl.append(blst)

for lisp in lisppl[1:]:
    print(lisp.lower())

tidaf = pandas.DataFrame(pandas.to_datetime(menfor.Time))

tidaf

datpan = pandas.DataFrame(pandas.to_datetime(menfor.Date))

retpan = pandas.DataFrame(tidaf + datpan)

tidap = tidaf.join(datpan)

tidap.count()

tidap.columns

(tidap.index)

tidate = tidap.Date

tival = set(tidate.values)

len(tival)

for tiv in tival:
    print(tiv)

for ti in tival:
    print(ti)
    pantimes = pandas.DataFrame(ti)

datpan

for men in menfor:
    print(men)

for mef in menfor.Comments:
    print(mef)

for bla in blahmen:
    print(bla)
    lisitem.append(bla)

menlis.append(menfor.Mentor)

menlis

shn = shenam.sheet_names

shelist = list()

shn

for sh in shn:
    #print(sh)
    shelist.append((shenam.parse(sh)))

hamlend = len(shelist)

hamlend

lisshez = list()

li

for lish in range(hamlend):
    print(lisshez[lish])

for lisz in lisshez:
    print(lisz.to_html)

for shl in range(hamlend):
    print(shelist[shl])
    lisshez.append((shelist[shl]))

lisshez

lenlis = len(lisshez)

lisho = lisshez[3]

lide = lisho[4:]

lide

for lel in range(lenlis):
    print (lisshez[lel])

liszer = lisshez[0]

for lisk in liszer:
    print(lisk)

mentim = menfor.Time

menvals = mentim.values

lismev = list()

for mev in menvals:
    print(mev)
    lismev.append(mev)

lisde = set(lismev)

lisfix = list()

a = lisde[~np.is(lisde)]

a

for ilre in lisde:
    print (ilre)
    #print(type(ilre))
    #print (ilre[:])
    #lisfix.append(ilre)
    #il = (ilre.replace(' ', ''))
    #print(il)

for lis in lisfix:
    print(str(lis.replace(' ', '')))

allibs = menfor.Library.valuesal

albs = set(allibs)

albs