Twitter Wordle for 2011

This morning I published (two) Wordles based on the content of my Twitter timeline for 2011 which I’ve been archiving to a SQLite database since July 2010.

Basic method:

  1. Export tweets
  2. Process into words
  3. Count word frequency
  4. Upload to Wordle

Wordle accepts data input in the form:

word1:55
word2:23
...

First output was:

Raw Wordle for 2011

This was a little skewed towards the various travel and weather related feeds I follow (@SEtrafficnews, @nationalrailenq, @NRE_SEastern, @SEplaying, @KentWeatherObs) so I then excluded them…

Much better...

And finally… a Wordle of my TwitteringsRamblings:

fooflington

Continue reading