Python Forum
time difference bettwenn logs
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
time difference bettwenn logs
#2
(Nov-20-2023, 09:25 AM)enkliy Wrote: So any help would be great. I have tried with pandas but that not possible...
You should show what you have tried,can do it Pandas but also there has parse the string first.
To help first step which should be is to parse time out and make it a time format.
>>> import re
>>> from datetime import datetime
>>> 
>>> s = '<150>Nov  7 07:38:33 DrayTek: Local User (MAC=B0-8C-75-C0-FF-8F): 172.16.91.7:57422 -> 17.57.172.11:443 (TCP)' 
>>> r = re.search(r'\d{2}:\d{2}:\d{2}', s)
>>> time_str = r.group()
>>> time_str
'07:38:33'
>>> datetime.strptime(time_str, '%H:%M:%S')
datetime.datetime(1900, 1, 1, 7, 38, 33)
When have time format can use timedelta between times.
Reply


Messages In This Thread
time difference bettwenn logs - by enkliy - Nov-20-2023, 09:25 AM
RE: time difference bettwenn logs - by snippsat - Nov-20-2023, 10:32 AM
RE: time difference bettwenn logs - by rob101 - Nov-20-2023, 11:33 AM
RE: time difference bettwenn logs - by enkliy - Nov-20-2023, 01:18 PM
RE: time difference bettwenn logs - by deanhystad - Nov-20-2023, 08:43 PM
RE: time difference bettwenn logs - by Larz60+ - Nov-21-2023, 10:32 AM
RE: time difference bettwenn logs - by Pedroski55 - Nov-21-2023, 11:04 AM
RE: time difference bettwenn logs - by enkliy - Nov-21-2023, 02:05 PM
RE: time difference bettwenn logs - by rob101 - Nov-21-2023, 02:26 PM
RE: time difference bettwenn logs - by enkliy - Nov-21-2023, 02:41 PM
RE: time difference bettwenn logs - by rob101 - Nov-21-2023, 03:00 PM
RE: time difference bettwenn logs - by enkliy - Nov-21-2023, 03:36 PM
RE: time difference bettwenn logs - by rob101 - Nov-21-2023, 03:39 PM
RE: time difference bettwenn logs - by deanhystad - Nov-21-2023, 04:43 PM
RE: time difference bettwenn logs - by rob101 - Nov-21-2023, 04:51 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Hard time trying to figure out the difference between two strings carecavoador 2 755 Aug-16-2023, 04:53 PM
Last Post: carecavoador
  Sum up Time difference tester_V 10 2,846 Apr-06-2023, 06:54 AM
Last Post: Gribouillis
  Bot refuses to count logs. M1racle 0 1,305 Dec-13-2021, 06:42 PM
Last Post: M1racle
  Get Azure activity logs using python script raham3406 4 3,681 Apr-27-2021, 05:10 AM
Last Post: raham3406
  How to get indices of minimum time difference Mekala 1 2,229 Nov-10-2020, 11:09 PM
Last Post: deanhystad
  How to calculate time difference between each row of dataframe in seconds Mekala 1 2,667 Jul-16-2020, 12:57 PM
Last Post: Larz60+
  python realtime parsing logs anna 2 2,972 Jul-05-2020, 06:36 AM
Last Post: anna
  capture logs on specific port anna 1 1,818 Jun-27-2019, 03:47 PM
Last Post: Larz60+
  Correlation of Incidents using time difference Rajhesh 1 1,894 Jun-27-2019, 03:44 PM
Last Post: Larz60+
  Time Difference in Epoch Microseconds then convert to human readable firesh 4 11,756 Feb-27-2018, 09:08 AM
Last Post: firesh

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020