#!/usr/bin/env python

import csv
import binascii

def somedecode(filename):
  with open(filename, 'rb') as csvfile:
    spamreader = csv.reader(csvfile, delimiter=',', quotechar='"')
    header = None
    bits = ""
    
    for row in spamreader:
      if header is None:
        header = row
        continue
      
      if row[2] == '192.168.67.81':
        bits += "{0:06b}".format(int(row[7]))

    print binascii.unhexlify('%x' % int(bits, 2))

if __name__ == "__main__":
	somedecode("transmission.csv")

