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,



In [ ]:



In [ ]:

    
import pandas
import numpy as np



In [ ]:

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



In [ ]:

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



In [ ]:

    
menlis = list()



In [ ]:

    
blahmen =menfor.Mentor.get_values()



In [ ]:

    
lisitem = list()



In [ ]:

    
setitem = set(lisitem)



In [ ]:

    
setitem



In [ ]:

    
lisppl = list()



In [ ]:

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



In [ ]:

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



In [ ]:



In [ ]:



In [ ]:



In [ ]:

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



In [ ]:

    
tidaf



In [ ]:

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



In [ ]:

    
retpan = pandas.DataFrame(tidaf + datpan)



In [ ]:

    
tidap = tidaf.join(datpan)



In [ ]:

    
tidap.count()



In [ ]:

    
tidap.columns



In [ ]:

    
(tidap.index)



In [ ]:

    
tidate = tidap.Date



In [ ]:

    
tival = set(tidate.values)



In [ ]:

    
len(tival)



In [ ]:

    
for tiv in tival:
    print(tiv)



In [ ]:

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



In [ ]:

    
datpan



In [ ]:

    
for men in menfor:
    print(men)



In [ ]:

    
for mef in menfor.Comments:
    print(mef)



In [ ]:

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



In [ ]:

    
menlis.append(menfor.Mentor)



In [ ]:

    
menlis



In [ ]:

    
shn = shenam.sheet_names



In [ ]:

    
shelist = list()



In [ ]:

    
shn



In [ ]:

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



In [ ]:

    
hamlend = len(shelist)



In [ ]:

    
hamlend



In [ ]:

    
lisshez = list()



In [ ]:

    
li



In [ ]:

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



In [ ]:



In [ ]:

    
for lisz in lisshez:
    print(lisz.to_html)



In [ ]:

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



In [ ]:



In [ ]:

    
lisshez



In [ ]:

    
lenlis = len(lisshez)



In [ ]:

    
lisho = lisshez[3]



In [ ]:

    
lide = lisho[4:]



In [ ]:

    
lide



In [ ]:

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



In [ ]:



In [ ]:



In [ ]:

    
liszer = lisshez[0]



In [ ]:

    
for lisk in liszer:
    print(lisk)



In [ ]:

    
mentim = menfor.Time



In [ ]:

    
menvals = mentim.values



In [ ]:

    
lismev = list()



In [ ]:



In [ ]:

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



In [ ]:

    
lisde = set(lismev)



In [ ]:

    
lisfix = list()



In [ ]:

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



In [ ]:

    
a



In [ ]:



In [ ]:

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



In [ ]:

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



In [ ]:

    
allibs = menfor.Library.valuesal



In [ ]:

    
albs = set(allibs)



In [ ]:

    
albs