#!/usr/bin/env python
# coding: utf-8

# In[4]:


import pandas as pd
import numpy as np
metrics = pd.read_csv('./src/metrics.csv', index_col=0)
metrics[:30]


# In[7]:


metrics.groupby(['node_id', 'http_status']).latency.aggregate(np.mean)


# In[8]:


metrics.groupby(['node_id', 'http_status']).latency.aggregate(np.percentile, 99.999)


# In[9]:


metrics.groupby(['http_endpoint', 'http_method']).latency.aggregate(np.percentile, 99)


# In[6]:


get_ipython().run_line_magic('matplotlib', 'inline')
latency = metrics['latency']
rolling_average = latency.rolling(window=100, center=False, min_periods=1).mean()
rolling_average.plot(title='Rolling average over 100 observations', use_index=True)


# In[7]:


metrics.plot.hist(y='latency')


# In[ ]: