In [1]:
%less demos/dataset/vmstat_loadtest.log
In [2]:
import pandas as pd
raw = pd.read_csv("demos/dataset/vmstat_loadtest.log", skiprows=1)
raw.head()
Out[2]:
In [20]:
columns = raw.columns.str.split().values[0]
print(columns)
In [21]:
data = raw.iloc[:,0].str.split(n=len(columns)-1).apply(pd.Series)
data.head()
Out[21]:
In [22]:
data.columns = columns
data.head()
Out[22]:
In [26]:
vmstat = data.iloc[:,:-1].apply(pd.to_numeric)
vmstat['UTC'] = pd.to_datetime(data['UTC'])
vmstat.head()
Out[26]:
In [27]:
cpu = vmstat[['us','sy','id','wa', 'st']]
cpu.head()
Out[27]:
In [28]:
cpu.plot.area()
Out[28]: