import pandas as pd
loansData = pd.read_csv('http://spark-public.s3.amazonaws.com/dataanalysis/loansData.csv')

loansData['Interest.Rate'][0:5]

/Users/nitin/dl/mangodata.csv

mangoData = pd.read_csv('/Users/nitin/dl/mangodata.csv')

mangoData

mangoData2 = pd.read_csv('/Users/nitin/dl/mangodata2.csv')

mangoData2

# plot missed by dow 
# plot delay by dow
# plot delay by num of days into program
# plot on time %

lisin = mangoData2['med'== 'lisinopril']

lisin = mangoData2[0:5]

lisin


lisin = mangoData2[mangoData2['med'] == 'lisinopril']

ator =  mangoData2[mangoData2['med'] == 'atorvastatin']

import datetime as dt
import dt.time as tm
def mk_hr_min(stime):
    (hr,min) = [ int(x) for x in stime.split(':') ]
    
def tdiff(s1, s2):
    h1,m1 = mk_hr_min(s1)
    h2,m2 = mk_hr_min(s2)
    t1 = tm(h1,m1,0)
    t2 = tm(h2,m2,0)
    td = t2 - t1
    return 60*td.hours + td.minutes