calculate_elapsed_time.py

gistfile1.txt

import sys
import csv
import time
import pandas as pd

def clean_input(start, stop):
    start = time.mktime(time.strptime(start, '%Y-%m-%d %H:%M:%S.%f'))
    stop = float(int(stop))
    return stop, start

if __name__ == '__main__':
    dt = [(x[0], x[1])for x in csv.reader(open(sys.argv[1], 'r'))]
    dt = [clean_input(*x) for x in dt]
    dt = pd.DataFrame([v[0] - v[1] for v in dt])
    print("Avg: {} Min: {} Max: {}".format(dt.mean(), dt.min(), dt.max()))