In [1]:
from __future__ import division
import datetime
import pandas
import numpy
import matplotlib.pyplot as plt
import seaborn
seaborn.set_style("whitegrid")
seaborn.despine()
%matplotlib inline
%config InlineBackend.figure_formats = {'svg',}
In [22]:
df = pandas.read_csv('../data/profiles.data', skiprows=8)
df.drop(0, axis=0, inplace=True)
columns = ['node' + str(index) for index in range(1, len(df.columns))]
columns.insert(0, 'date')
df.columns = columns
df.date = df.date.apply(lambda x: datetime.datetime.strptime(x, '%Y-%m-%d %H:%M'))
df.set_index('date', inplace=True)
In [28]:
l = ["node_d3", "node_c6", "node_b7", "node_d11", "node_b5", "node_d12", "node_b8", "node_b1", "node_c8", "node_d4", "node_d6", "node_d1", "node_a2", "node_b2", "node_b6", "node_d2", "node_d7", "node_c2", "node_c5", "node_d10", "node_c4", "node_b9", "node_c7", "node_b4", "node_c12", "node_d5", "node_d9", "node_a1", "node_c1", "node_d8", "node_c11", "node_a3", "node_c10", "node_b10", "node_b3", "node_c3", "node_c9"]
len(l)
Out[28]:
In [39]:
start = datetime.datetime(2014, 6, 17, 0, 0, 0)
end = datetime.datetime(2014, 6, 18, 0, 0, 0)
plt.figure(figsize=(11, 5))
plt.plot(df[['node' + str(index) for index in range(10, 20)]].sum(axis=1)[start:end])
plt.show()
In [38]:
df.head()
Out[38]: