Archive | July, 2012

26 July 2012 2 Comments

Python Snippet: Sending HTML email with an attachment via Google Apps SMTP (or Gmail)

This is just one of those things that I had to do in a project (as part of a much bigger system), and wish I had it all laid out for me like this when I was writing it.

Here it is for your cut-n-paste hacking pleasure…

17 July 2012 3 Comments

Cars, Computers and Software: Quick Tableau of data from my VW’s “On Board Diagnostic” (OBDII) port

Just a quick little one-off I did over the weekend while testing some stuff. I’ve been toying with a couple of USB>OBD2 adapters and some linux scripts for a few days in order to spec out and build a much-bigger car-based “data” project.

But in the meantime…

5 July 2012 18 Comments

How to Harvest Facebook updates with Python, MySQL or SQL Server

Data Party! Most people focus on search.twitter.com (or automated pulls from their API) for data collection regarding the “pulse” on a particular topic or brand – they often overlook the fact that the public Facebook timeline can be a useful source of data as well. I’ll show you how to harvest it and store it in a database of your choosing for later analysis.

3 July 2012 3 Comments

Get Some! Query MLB Gameday Data with OData and Tableau Public

Baseball. If is ANY sport in America that is “all about the data”, it’s baseball. Although we touched on this topic last year, I never really gave it its full round of posts that it deserves.

Well, finally that day has come – except now its even better…