In [85]:

    

import pandas as pd
import numpy as np


    

In [86]:

    

raw = pd.read_csv("emtu.tsv", delimiter="\t")


    

In [87]:

    

inds = (raw["LINHA"] != "LINHA") | pd.notnull(raw["LINHA"])
raw = raw[inds]


    

In [88]:

    

uinds = raw["INTEGRAÇÃO"] == "-"
dat = raw[uinds]


    

In [89]:

    

len(dat)


    

    
Out[89]:





572

In [91]:

    

3*60 / 572


    

    
Out[91]:





0.3146853146853147

In [ ]: