Newer
Older
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
import sys
logdata = open(sys.argv[1])
loggraph = open('LogGraph.csv', 'w')
loggraph.write('ACKNOWLEDGEMENTS,')
columns = 0
for line in logdata:
bits = (line[-3: -1])
columns += 1
if(bits == '00'):
items = line.split(' ')
string = items[2] + ' ' + items[1] + ' ' + items[5] + ' ' + items[3]
loggraph.write(string + ',')
logdata.close()
logdata = open(sys.argv[1])
loggraph.write('\n' + 'SENT,')
for line in logdata:
bits = (line[-3: -1])
if(bits == '10'):
items = line.split(' ')
string = items[2] + ' ' + items[1] + ' ' + items[5] + ' ' + items[3]
loggraph.write(string + ',')
logdata.close()
logdata = open(sys.argv[1])
loggraph.write('\nCLICKED,')
for line in logdata:
bits = (line[-3: -1])
if(bits == '01'):
items = line.split(' ')
string = items[2] + ' ' + items[1] + ' ' + items[5] + ' ' + items[3]
loggraph.write(string + ',')
logdata.close()
logdata = open(sys.argv[1])
loggraph.write('\nGOAL,')
for line in logdata:
bits = (line[-3: -1])
if(bits == '11'):
items = line.split(' ')
string = items[2] + ' ' + items[1] + ' ' + items[5] + ' ' + items[3]
loggraph.write(string + ',')
logdata.close()
logdata = open(sys.argv[1])
loggraph.write('\n\n\n\n\n\n')
columnletter = ""
while columns > 0:
columns, remainder = divmod(columns - 1, 26)
columnletter = chr(65 + remainder) + columnletter
items = logdata.readline().split(' ')
string = items[2] + ' ' + items[1] + ' ' + items[5] + ' 00:00'
loggraph.write(string + ',' + '"=COUNTIFS($B$1:$' + columnletter + '$1, "">"" & A10, $B$1:$' + columnletter + '$1, ""<"" & A11)",')
loggraph.write('"=COUNTIFS($B$2:$' + columnletter + '$2, "">"" & A10, $B$2:$' + columnletter + '$2, ""<"" & A11)",')
loggraph.write('"=COUNTIFS($B$3:$' + columnletter + '$3, "">"" & A10, $B$3:$' + columnletter + '$3, ""<"" & A11)",')
loggraph.write('"=COUNTIFS($B$4:$' + columnletter + '$4, "">"" & A10, $B$4:$' + columnletter + '$4, ""<"" & A11)"\n')
i = 10
while i < 38:
loggraph.write('=A' + str(i) + ' + 6/24,' + '"=COUNTIFS($B$1:$' + columnletter + '$1, "">"" & A'+ str(i+1) + ',$B$1:$' + columnletter + '$1, ""<"" & A' + str(i+2) + ')",')
loggraph.write('"=COUNTIFS($B$2:$' + columnletter + '$2, "">"" & A'+ str(i+1) + ',$B$2:$' + columnletter + '$2, ""<"" & A' + str(i+2) + ')",')
loggraph.write('"=COUNTIFS($B$3:$' + columnletter + '$3, "">"" & A'+ str(i+1) + ',$B$3:$' + columnletter + '$3, ""<"" & A' + str(i+2) + ')",')
loggraph.write('"=COUNTIFS($B$4:$' + columnletter + '$4, "">"" & A'+ str(i+1) + ',$B$4:$' + columnletter + '$4, ""<"" & A' + str(i+2) + ')"\n')
i += 1
loggraph.close()