Log file manipulation using python

Question

I'm the following log file structure. I want to find out the maximum response time and want to print the log file which is having the highest response time(R.T) using python 2.7.11.

The structure of my log file:

00.00.00.000 - - [dd/mm/yyyy:hr:mm:se +0800] GET Url HTTP/1.1 200 dataconsumed R.T
00.00.00.000 - - [dd/mm/yyyy:hr:mm:se +0800] GET Url HTTP/1.1 200 dataconsumed R.T
00.00.00.000 - - [dd/mm/yyyy:hr:mm:se +0800] GET Url HTTP/1.1 200 dataconsumed R.T

Code Used:

file =open(r"log.txt","r")
for line in file:
line_array = line.split(" ")
print line_array[10]

OUTPUT:

R.T
R.T
R.T

Until now I could able to print all the response time from the log file. I couldn't able to get the highest response time (R.T) out of it.

Help me to find the highest response time with the whole log file printed as an output.

Jacques de Hooge · Accepted Answer · 2017-01-29 11:01:36Z

1

Staying close to your own code and assuming it indeed gives the output as you describe:

file =open(r"log.txt","r")
highest = -1
for line in file:
    line_array = line.split(" ")
    highest = max (highest, float (line_array[10]))

print (highest)
file.close ()

answered Jan 29, 2017 at 11:01

Jacques de Hooge

7,0002 gold badges33 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

VBB · Accepted Answer · 2017-01-29 11:01:12Z

0

Start with an empty list BEFORE your loop

response_times = []

Instead of just printing the line element, add it to this list WITHIN the loop:

response_times.append(line_array[10])

Finally, print the maximum AFTER /outside the for loop:

print max(response_times)

answered Jan 29, 2017 at 11:01

VBB

1,3357 silver badges18 bronze badges

Comments

Ofer Arial · Accepted Answer · 2017-01-29 14:30:36Z

0

You should get the actual response time (R.T) that will be in the R.T label (I guess), save it and then get the max one. So your code should look like:

file = open(r"log.txt","r")
rts = []
for line in file:
    line_array = line.split(" ")
    rts.append(float(line_array[10]))

#Now find max
max_rt = max(rts)
print "Max R.T is :", max_rt
file.close()

edited Jan 29, 2017 at 14:30

answered Jan 29, 2017 at 11:00

Ofer Arial

1,1391 gold badge12 silver badges27 bronze badges

Collectives™ on Stack Overflow

Log file manipulation using python

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related