In [1]:

    

import warnings
warnings.filterwarnings('ignore')


    

In [2]:

    

from datetime import date, time
import pandas as pd
import pylab as pl
import numpy as np
import seaborn as sns
%matplotlib inline


    

In [3]:

    

df = pd.read_csv('/media/rafael/KINGSTON/Daten/2014_BAB_S.txt', sep=';')


    

In [4]:

    

df = df[(df.Zst == 9627) | (df.Zst == 9629)]


    

In [5]:

    

df.columns


    

    
Out[5]:





Index([u'TKNR', u'Zst', u'Land', u'Strklas', u'Strnum', u'Datum', u'Wotag',
       u'Fahrtzw', u'Stunde', u'KFZ_R1', u'K_KFZ_R1', u'KFZ_R2', u'K_KFZ_R2',
       u'Lkw_R1', u'K_Lkw_R1', u'Lkw_R2', u'K_Lkw_R2', u'PLZ_R1', u'K_PLZ_R1',
       u'Pkw_R1', u'K_Pkw_R1', u'Lfw_R1', u'K_Lfw_R1', u'Mot_R1', u'K_Mot_R1',
       u'PmA_R1', u'K_PmA_R1', u'Bus_R1', u'K_Bus_R1', u'LoA_R1', u'K_LoA_R1',
       u'Lzg_R1', u'K_Lzg_R1', u'Sat_R1', u'K_Sat_R1', u'Son_R1', u'K_Son_R1',
       u'PLZ_R2', u'K_PLZ_R2', u'Pkw_R2', u'K_Pkw_R2', u'Lfw_R2', u'K_Lfw_R2',
       u'Mot_R2', u'K_Mot_R2', u'PmA_R2', u'K_PmA_R2', u'Bus_R2', u'K_Bus_R2',
       u'LoA_R2', u'K_LoA_R2', u'Lzg_R2', u'K_Lzg_R2', u'Sat_R2', u'K_Sat_R2',
       u'Son_R2', u'K_Son_R2'],
      dtype='object')

In [6]:

    

kurz = df[df.Zst == 9627]
lang = df[df.Zst == 9629]


    

In [7]:

    

pl.figure()
frame = pd.DataFrame({'kurz': kurz.groupby('Wotag').mean()['Lkw_R1'],
                      'lang': lang.groupby('Wotag').mean()['Lkw_R1']})
frame.plot(kind='bar', figsize=(16, 9))
pl.title('Wochentag - Richtung 1', fontsize=20);


    

    






<matplotlib.figure.Figure at 0x7f194ab8edd0>






    

In [8]:

    

pl.figure()
frame = pd.DataFrame({'kurz': kurz.groupby('Wotag').mean()['Lkw_R2'],
                      'lang': lang.groupby('Wotag').mean()['Lkw_R2']})
frame.plot(kind='bar', figsize=(16, 9))
pl.title('Wochentag - Richtung 2', fontsize=20);


    

    






<matplotlib.figure.Figure at 0x7f194ab8ec90>






    

In [9]:

    

pl.figure()
frame = pd.DataFrame({'kurz': kurz.groupby('Stunde').mean()['Lkw_R1'],
                      'lang': lang.groupby('Stunde').mean()['Lkw_R1']})
frame.plot(kind='bar', figsize=(16, 9))
pl.title('Stunde - Richtung 1', fontsize=20);


    

    






<matplotlib.figure.Figure at 0x7f194a8f8e50>






    

In [10]:

    

pl.figure()
frame = pd.DataFrame({'kurz': kurz.groupby('Stunde').mean()['Lkw_R2'],
                      'lang': lang.groupby('Stunde').mean()['Lkw_R2']})
frame.plot(kind='bar', figsize=(16, 9))
pl.title('Wochentag - Richtung 2', fontsize=20);


    

    






<matplotlib.figure.Figure at 0x7f194a84a710>






    

In [11]:

    

pl.figure()
frame = pd.DataFrame({'LKW': kurz.groupby('Fahrtzw').mean()['Lkw_R1'],
                      'PKW': kurz.groupby('Fahrtzw').mean()['Pkw_R1']})
frame.plot(kind='bar', figsize=(16, 9))
pl.title('Fahrzw - Richtung 1', fontsize=20);


    

    






<matplotlib.figure.Figure at 0x7f19463596d0>