Interesting numbers from Trillian Pro’s logs

’bout a few months ago, I grepped through my Trillian log files to look for a particular URL that I had lost, and I eventually found it by sorting the URLs by frequency. While I found the URL, it was cool to observe all the URLs I had sent in the previous few months, and I thought that it would be even cooler if I had more statistics to eyeball. That thought didn’t really get anywhere; ’til today, at least.

So I whipped up a Python script to get some more statistics. It currently outputs something along the lines of this example:

=== # of Messages Received (From) ===
 1405 Alex Tase
 1208 Michael Soctts
 1122 Jesse Sanders
 1096 Lucas Thresh
 1039 Jon Dobb
  996 Robby Staff
  979 Zach Garcia
  940 Baltassar Dani
  722 Carver Agnes
  456 Mark Doover
  453 James Thawbuck
...

=== # of Messages Sent (To) ===
 4612 Alex Tase
 2136 Jack Hau
 1396 Lucas Thresh
  968 Michael Soctts
  945 Baltassar Dani
  871 Jon Dobb
  622 Jesse Sanders
  426 Robby Staff
...

=== Longest Times You Kept the Window Open ===
  8d 20h 12m 40s Frank Shell
  6d 23h 31m  8s James Thawbuck
  5d  5h 40m 34s Frank Swatch
  4d  7h 30m 41s Alex Helmer
  3d 19h 13m 52s Rob Jim
  3d 12h 33m 21s Jeremy Apple
  2d 15h 42m 14s Mark Scotts
...

=== Top Lines You Said ===
  300 o.o
  267 what
  257 haha
  182 o-o
  162 oic
...

=== Top Words You Said ===
 2251 i
 1622 the
 1421 you
 1353 a
 1206 to
  838 and
  826 it
  748 *
  685 is
  675 that
  613 so
  593 of
  522 in
  510 have
  440 no
...

=== Top URLs Sent/Received ===
   19 http://www.example.com/url1
   16 http://www.example.com/url2
   13 http://www.example.com/url3
   12 http://www.example.com/url4
...

TrillStat analyzes your log files to compute the statistics. You need a working installation of Trillian Pro (or at least its data files) because it uses your buddy list to group the individual contacts of metacontacts together. You need Python (2.6 preferred), but there should be no other requirements.

It’s a command line script. It will automatically detect the directories (hopefully), but if it doesn’t, then you have to specify it manually. Check the help (python trillstat.py --help) to find out how to do that.

Check it out here:
http://github.com/sk89q/scripts/blob/master/trillstat/