Google Spreadsheet to NodeXL to Google Spreadsheet to Web

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

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, OUseful.info and MASHe interconnect using Google Spreadsheets and NodeXL I said: […]

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

Using Google Spreadsheets as a data source to analyse extended Twitter conversations in NodeXL (and Gephi)

Having experimented with the Twitter API for a couple of years I’m familiar with a number of the limitations, particularly when it comes to the Twitter Search API. The biggest being the maximum number of tweets (1,500) and timeframe (last 7 days) you can extract in one go. This means that whilst tools like NodeXL’s* […]

The art of discovery: Looking at how UK Web Focus, OUseful.info and MASHe interconnect using Google Spreadsheets and NodeXL

Moving away from social networks I wanted to discover how Brian Kelly’s UK Web Focus, Tony Hirst’s OUseful.info and my MASHe are linked together. I chose Brian’s and Tony’s blogs for this because they have highlighted my work in the past so I know I’ll get some data. The main reason for this exercise was […]

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

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

Twitter network analysis and visualisation II: NodeXL – Getting started with the @WiredUK friends network

The other tool that I got wind of just after SocialBro was Network Overview, Discovery and Exploration for Excel – NodeXL. As indicated in the title NodeXL is an add-on for Microsoft Excel (Windows version) but the code is free and open source. Here’s the description from the website: For a while I’ve been admiring […]

« Previous Page
css.php