Twitter – Page 5 – By @mhawksey

Google Spreadsheet to NodeXL to Google Spreadsheet to Web

November 18, 2011

Earlier today I said: @mhawksey Martin Hawksey Uploaded data from NodeXL to Google Spreadsheet then rendered edges in browser. 203 nodes 1913 edges processed okay bit.ly/ua0PEx For a bit more detail on how I did it. I used my TAGS template to capture tweets from the #IIE2011 event yesterday. This template includes a summary sheet […]

TAGSExplorer: Queryable Twitter archive exploration with Google Visualization API Query Language integration

November 13, 2011

Since pushing out my Twitter archive visualisation tool, TAGSExplorer, it nice to see people are already pushing out tweets for their own archives. After a full on development period of a couple of weeks, TAGSExplorer is reasonably stable but like most other web services there is some continual tweaking going on behind the scenes. One […]

2 Comments

Sentiment Analysis of tweets: Comparison of ViralHeat and Text-Processing Sentiment APIs

November 10, 2011

So I make yet another foray into a world that I know little about, potentially making statements that are factually incorrect or just stupid, but I do so hoping that I can share some of my discoveries. All the data is available for your own analysis and comments are open if you want to put […]

One Comment

Twitter: How to archive event hashtags and create an interactive visualization of the conversation

November 7, 2011

The use of Twitter to collecting tweets around an event hashtag allowing participants to share and contribute continues to grow and has even become part of mass media events, various TV shows now having and publicising their own tag. This resource is often lost in time, only tiny snippets being captured in blog posts or […]

194 Comments

Visualising the #ili2011 Twitter archive

October 31, 2011

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 […]

8 Comments

TAGSExplorer: Interactively visualising Twitter conversations archived from a Google Spreadsheet

October 28, 2011

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 […]

12 Comments

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

October 16, 2011

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 […]

One Comment

Live Twitter data from FOTE #fote11 [Top Tweeters, Sentiment, Hashtag Network Diagram, Conversation Diagram]

October 7, 2011

Not at FOTE11 today (you can follow the live stream) but was interested in what data I could extract from the #fote11 twitter stream and process as the event unfolds. Most of the data here comes from a mashup of my Google Spreadsheet mashup. (This is perhaps putting Google Spreadsheets to the limit in terms […]

Using Google Spreadsheet/Apps Script and Google Social Graph to get Twitter edges for visualizing in NodeXL and Gephi

September 5, 2011

One of the things I really liked about the network analysis and visualisation tool NodeXL which I wrote about last week was the built-in tools for grabbing data from Twitter. I said: The advantage of NodeXL, particularly for graphing Twitter communities, is it has built-in features for grabbing the data for you. Not only that […]

3 Comments