In [1]:

    

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt


    

In [2]:

    

adjusted = pd.read_csv('../data/4mo_deadhead_cost_adjusted_results.csv')


    

In [3]:

    

adjusted.head()


    

    
Out[3]:






  

    

      

      
ServiceDate
      
Run
      
CostProxy
      
PctDeadhead
    
  
  

    

      
0
      
0015-01-01
      
9701
      
2460.000000
      
0.372764
    
    

      
1
      
0015-01-01
      
9706
      
3218.444444
      
0.414486
    
    

      
2
      
0015-01-01
      
9702
      
3466.666667
      
0.330865
    
    

      
3
      
0015-01-01
      
9703
      
3003.000000
      
0.199606
    
    

      
4
      
0015-01-01
      
9704
      
3843.500000
      
0.426727
    
  

In [4]:

    

len(adjusted[adjusted.CostProxy == 14400])


    

    
Out[4]:





19

In [5]:

    

data = pd.read_csv('../data/UW_Trip_Data_4mo_QC_capacity.csv')


    

    




//anaconda/lib/python2.7/site-packages/IPython/core/interactiveshell.py:2717: DtypeWarning: Columns (3) have mixed types. Specify dtype option on import or set low_memory=False.
  interactivity=interactivity, compiler=compiler, result=result)

In [6]:

    

run = data[(data.ServiceDate == '0015-04-11') & (data.Run == '932')]


    

In [7]:

    

from legPct import runTime


    

In [8]:

    

runTime(run['ETA'])/sum(run.NumOn)


    

    
Out[8]:





6900