Skip to content
Snippets Groups Projects
DataAnalyzer.py 2.62 KiB
Newer Older
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()