Log input: 10.216.113.172 - - [04/Sep/2009:02:57:16 -0700] "GET /images/filmpics/0000/0053/quietman2.jpeg HTTP/1.1" 200 1077924 10.211.47.159 - - [03/Sep/2009:22:19:49 -0700] "GET /quietman4.jpeg HTTP/1.1" 404 212 10.211.47.159 - - [22/Aug/2009:12:58:27 -0700] "GET /assets/img/closelabel.gif HTTP/1.1" 304 - 10.216.113.172 - - [14/Jan/2010:03:09:17 -0800] "GET /images/filmmediablock/229/Shinjuku5.jpg HTTP/1.1" 200 443005 10.211.47.159 - - [15/Oct/2009:21:21:58 -0700] "GET /assets/img/banner/ten-years-banner-grey.jpg HTTP/1.1" 304 - 10.216.113.172 - - [12/Aug/2009:05:57:55 -0700] "GET /about-us/people/ HTTP/1.1" 200 10773 10.211.47.159 - - [24/Aug/2009:13:16:26 -0700] "GET /assets/img/search-button.gif HTTP/1.1" 304 - 10.211.47.159 - - [03/Sep/2009:21:30:27 -0700] "GET /imagesewspics/0000/0017/Mike5_thumb.JPG HTTP/1.1" 304 - 10.211.47.159 - - [15/Oct/2009:20:30:43 -0700] "GET /images/filmpics/0000/0057/quietman4.jpeg HTTP/1.1" 304 - 10.211.47.159 - - [11/Aug/2009:20:34:44 -0700] "GET /assets/img/search-button.gif HTTP/1.1" 304 -

have to store like

Question :Number of unique daily (in UTC time) hosts

Convert timestamp string into datetime type in UTC timezone

The result should be ordered from the earliest date to the latest date

desired output is a list of ints for the log file I provide the desired out put should look like

in python with pandas dataframe

REMEBER WHEN - 7 NOT ALL OF THEM ARE 7 SOME OF THEM ARE 8 OR 4 SO HAVE TO BE FROM THE DATEFRAME['TIMESTAMP']

\begin{tabular}{|l|l|l|l|l|l|l|} \hline host & timestamp & method & url & version & response_code & content_size \\ \hline 199.72.81.55 & 01/Jul/1995:00:00:010400 & GET & /history/apollo/ & HTTP/1.0 & 200 & 6245 \\ \hline unicomp6.unicomp.net & 01/Jul/1995:00:00:06 -0400 & GET & /shuttle/countdown/ & HTTP/1.0 & 200 & 3985 \\ \hline \end{tabular} :[2,1,1,2,1,1]