%pylab inline import matplotlib.pylab as pylab import pandas as pd import StringIO import matplotlib.pylab as plt import numpy as np pylab.rcParams['figure.figsize'] = 8, 8 # that's default image size for this interactive session pd.options.display.width = 200 from datetime import datetime, timedelta df = pd.read_fwf('wc.log', colspecs=[(0,14),(15,173)], header=None, parse_dates=[0]) df[0] = pd.to_datetime(df[0]) df # calls taking more than 1 second idxs = (df[0].diff() > np.timedelta64(1,'s')).values df.iloc[idxs.nonzero()[0] - 1] # overall time print df[0].max()-df[0].min() df[0].plot() plt.title('Calls vs timestamp') plt.ylabel('time (s)') # y axis max is 35 seconds