Skip to content
Snippets Groups Projects
Select Git revision
  • master default protected
1 result
Blame Permalink
DataAnalyser.py 2.62 KiB
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
61
62 







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()