%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
Welcome to pylab, a matplotlib-based Python environment [backend: module://IPython.zmq.pylab.backend_inline]. For more information, type 'help(pylab)'.
df = pd.read_fwf('wc_normal.log', colspecs=[(0,14),(15,173)], header=None, parse_dates=[0])
df[0] = pd.to_datetime(df[0])
df
<class 'pandas.core.frame.DataFrame'> Int64Index: 1911 entries, 0 to 1910 Data columns (total 2 columns): 0 1911 non-null values 1 1911 non-null values dtypes: datetime64[ns](1), object(1)
# calls taking more than 1 second
idxs = (df[0].diff() > np.timedelta64(1,'s')).values
df.iloc[idxs.nonzero()[0] - 1]
Int64Index([], dtype=int64) | Empty DataFrame |
# overall time
print df[0].max()-df[0].min()
0:00:00.550690
df[0].plot()
plt.title('Calls vs timestamp')
plt.ylabel('time (s)')
# y axis max is 0.6 seconds
<matplotlib.text.Text at 0x803c450>