Visualising the #ili2011 Twitter archive

Over on UK Web Focus Brian Kelly has posted What Twitter Told Us About ILI 2011which gives a breakdown of twitter statistics the recent Internet Librarian International conference #ili2011. These statistics give some of the headline figures of number of tweets, top tweeters etc from Andy Powell’s Summarizr interface for the TwapperKeeper service (recent bought […]

What I’ve starred this month: October 28, 2011

Here’s some posts which have caught my attention this month: Introducing @GuardianTagBot, your new Twitter-based search assistant – October 27, 2011 Google+ Resurrects Playback Feature From Wave, Renames It “Ripples” – October 28, 2011 – and adds visualisation to the conversation Google+ now available for Google Apps domains – October 27, 2011 Collecting Tweets With […]

TAGSExplorer: Interactively visualising Twitter conversations archived from a Google Spreadsheet

Graphs can be a powerful way to represent relationships between data, but they are also a very abstract concept, which means that they run the danger of meaning something only to the creator of the graph. Often, simply showing the structure of the data says very little about what it actually means, even though it’s […]

A template for rendering small NodeXL visualisations on the web using the d3.js

Having put in the toil getting my head around the d3.js library I wanted to revisit a problem I had rendering NodeXL generated data in a scalable vector graphic based webpage. In my post The art of discovery: Looking at how UK Web Focus, and MASHe interconnect using Google Spreadsheets and NodeXL I said: […]

Guardian Tag Explorer: When the Guardian Open Platform met d3.js

My pseudo PhD supervisor for my mocorate degree, Dr Tony Hirst (Open University – and now Visiting Senior Fellow in Networked Teaching and Learning/Senior Fellow of the University of Lincoln – congrats) recently, amongst many other things, started Tinkering with the Guardian Platform API – Tag Signals and Visualising New York Times Article API Tag […]

Updates to Twitter Archiving Google Spreadsheet v2.3 [TAGS]

Recently I’ve started exploring extended Twitter conversations using data captured from my Twitter Archiver Google Spreadsheet (think I going to rename this TAGS) and one of the problems was “The user ids in the Search API are different from those in the REST API … This defect is being tracked by Issue 214. This means […]

SpreadEmbed: Turning a Google Spreadsheet of links into a page of embedded objects

#embedly_twitter_83506155{background:url( #FFF04D; padding:20px;} #embedly_twitter_83506155 p{background:#fff;padding:10px 12px 0px 12px;margin:0;min-height:48px;color:#000;font-size:18px;line-height:22px;-moz-border-radius:5px;-webkit-border-radius:5px} #embedly_twitter_83506155 .embedly_tweet_content{background:#fff;padding:10px 12px 10px 12px;margin:0;min-height:48px;color:#000;font-size:18px !important;line-height:22px;-moz-border-radius:5px;-webkit-border-radius:5px} #embedly_twitter_83506155 p span.metadata{display:block;width:100%;clear:both;margin-top:0px;height:40px; padding-bottom: 12px;} #embedly_twitter_83506155 p span.metadata{line-height:15px;color:#999;font-size:14px} #embedly_twitter_83506155 p span.metadata a{line-height:15px;font-size:20px;vertical-align:middle} #embedly_twitter_83506155 p span.metadata img{float:left;margin:0 10px 0 0px;width:48px;height:48px} #embedly_twitter_83506155 p a {color: #0099CC; text-decoration:none;} #embedly_twitter_83506155 p a:hover{text-decoration:underline} #embedly_twitter_83506155 .embedly_timestamp{font-size:13px;display:inline-block;margin-top: 5px;} #embedly_twitter_83506155 .components-above span.embedly_timestamp{font-size:10px;margin-top: 1px;line-height:12px} #embedly_twitter_83506155 a {color: […]

Suggest an article for The GAS: Google Apps Script Scoop

For a while I’ve been curating ‘The GAS’ which is a collection of Google Apps Script examples and news pulled together using I started it mainly because I’m a ‘patterns programmer’, that is I have limited formal coding skills so learn and produce things from other people’s examples. Because others getting started with Apps […]

Google Spreadsheets as a Database – INSERT with Apps Script form POST/GET submit method

Update 04/07/2014: I’ve revisited this code and made a number of improvements. Read more in Google Sheets as a Database – INSERT with Apps Script using POST/GET methods (with ajax example) Update: See comment by James to streamline this even more. I was recently rediscovering an old Hirst post on Google Spreadsheets as a Database […]

Infographic: #fote11 conversations coded with sentiment data from ViralHeat [NodeXL]

[This text originally appeared in Live Twitter data from FOTE #fote11 post but I’m extracting here to provide a separate space for comment (and hit RSS aggregators with something I think is quite interesting] Using a combination of my Using Google Spreadsheets as a data source to analyse extended Twitter conversations in NodeXL (and Gephi) […]

Next Page »