Elapsed Time (sec) generalization

In [1]:

    

import numpy as np
import pandas as pd
import pylab as pl
import matplotlib.pyplot as plt

%matplotlib inline

df = pd.read_csv('tmp/session_d.csv')


    

In [2]:

    

df.dtypes


    

    
Out[2]:





Unnamed: 0              int64
Unnamed: 0.1            int64
Unnamed: 0.1.1          int64
ID                      int64
Serial                  int64
SrcIP                  object
DstIP                  object
SessionID               int64
SrcPort                 int64
DstPort                 int64
Flags                  object
Proto                  object
SrcPortCls0           float64
SrcPortCls1           float64
SrcPortCls2           float64
SrcPortCls3           float64
SrcPortCls4           float64
SrcPortCls5           float64
DstPortCls0           float64
DstPortCls1           float64
DstPortCls2           float64
DstPortCls3           float64
DstPortCls4           float64
DstPortCls5           float64
Bytes                   int64
Bytes Sent              int64
Bytes Received          int64
Packets                 int64
Start Time             object
Elapsed Time (sec)      int64
Bytes2                float64
Bytes3                float64
dtype: object

In [5]:

    

pl.figure(figsize=(12, 6))
p=df.groupby('Elapsed Time (sec)')['Elapsed Time (sec)'].count().plot.bar(width=2,edgecolor='blue',color='blue')
p.tick_params(labelbottom='off',top='off',bottom='off')
p.set_yscale('log')
fig = p.get_figure()
fig.savefig('tmp/ElapsedTime000.png')


    

In [6]:

    

df['ElapsedTime2']=np.floor(df['Elapsed Time (sec)']/10)*10+10
pl.figure(figsize=(12, 6))
p=df.groupby('ElapsedTime2')['ElapsedTime2'].count().plot.bar(width=2,edgecolor='blue',color='blue')
p.tick_params(labelbottom='off',top='off',bottom='off')
p.set_yscale('log')
fig = p.get_figure()
fig.savefig('tmp/ElapsedTime001.png')


    

In [7]:

    

df['ElapsedTime3']=np.floor(df['Elapsed Time (sec)']/100)*100+100
pl.figure(figsize=(12, 6))
p=df.groupby('ElapsedTime3')['ElapsedTime3'].count().plot.bar(width=2,edgecolor='blue',color='blue')
p.tick_params(labelbottom='off',top='off',bottom='off')
p.set_yscale('log')
fig = p.get_figure()
fig.savefig('tmp/ElapsedTime002.png')


    

In [8]:

    

df.to_csv('tmp/session_e.csv')


    

In [ ]: