To start off learning python towards the beginning of 2007, I decided to take my imstat perl script that simply generated a png into something more useful. imusage is three python scripts:

1. log2sql.py - these 140 lines of python parse through pidgin, adium, gaim, and iChat logs and imports them all into mysql. This is run automatically every night and only adds records to the database that are not in it already.
2. namer.py - these 20 lines provide a UI that allows me to assign proper names to buddys, and combines things across protocols so that the database will represent one person with all of their log lines combined from separate IM protocols
3. htmlmaker.py - these 260 lines of python then read through the database and generate some numbers and pretty html+css graphs for my and your enjoyment.

Current output, generated nightly, is below: Generated at 2009.09.23 04:04:54

People in the last month

Seth
San
Campbell
David
Jim
Jason
Joey
AOL
Victor

Lines in the last month by time of day

People in the last Year

David
San
Jim
Seth
Victor
Campbell
Jason
Greggory
Lilia
Chris

Lines in the last Year by time of day

People in all time

Campbell
Laura
David
San
Sarah
Melissa
Jessica
Gin
Kelly
Bethany
Lindsey
Chris
Michael
Richard
Emmanuel
Gabby
Mark
Christopher
Gwen
Seth
Jim
Rachel
Daniel
Jason
Ashley

Lines by time of day

Average lines per day since first seen

San
Laura
Campbell
David
Jim
Sarah
Melissa
Jessica
Seth
Chris
Emmanuel
Gin
Kelly
Lindsey
Bethany
Richard
Michael
Gabby
Jason
Victor
Mark
Joey
Christopher
Gwen
Travis

Average lines per day since first seen until day last seen (including empty days)

Laura
San
Matt
Jackie
Campbell
Sarah
Emmanuel
Kelly
Jim
David
Lindsey
Melissa
Gin
Jennifer
Jessica
Christopher
Sara
Chris
Beverly
Travis
Seth
Caroline
Scott
Bethany
Richard

Number of days seen

Campbell
David
San
Melissa
Michael
Gin
Laura
Sarah
Richard
Chris
Daniel
Gabby
Bethany
Mark
Jessica
Christopher
Seth
Jason
Gwen
Kelly
Lindsey
Jason
AOL
Becca
Stephen

Lines per month