expedite_report_aggregator.py

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

# In[2]:


import pandas as pd
import seaborn as sns

get_ipython().run_line_magic('matplotlib', 'inline')


# In[28]:


dfs = []
for i in range(1, 10):
    filename = 'normal_run_{:d}.txt'.format(i)
    name = 'normal_{:02d}'.format(i)
    new = pd.read_csv(filename, names=[name, 'Test'], error_bad_lines=False, index_col=1)
    dfs.append(new)
dfs

result = pd.concat(dfs, axis=1)
result.transpose().describe()


# In[30]:


mean = result.transpose().mean().reset_index()
mean = mean.reindex(columns=[0, 'Test'])

mean.to_csv('test.csv', header=False, float_format='%.2f', index=False)
mean