background preloader

DataMining et Analytics

Facebook Twitter

Using Google Spreadsheets to extract Twitter data » Posted November 20, 2009 in How-to, twitter | 24 Comments so far Last weekend I was looking for ways to extract Twitter search data in a structured, easily manageable format.

Using Google Spreadsheets to extract Twitter data »

The two APIs I was using (Twitter Search and Backtweets) were giving good results – but as a non-developer I couldn’t do much with the raw data they returned. Instead, I needed to get the data into a format like CSV or XLS. Vincent Archer - Recherche & Développement. Generating graphs of retweets and @-messages on Twitter using R and Gephi. After recently discovering the excellent methods section on, I decided it was time to document my own approach to Twitter data.

Generating graphs of retweets and @-messages on Twitter using R and Gephi

I’ve been messing around with R and igraph for a while, but it wasn’t until I discovered Gephi that things really moved forward. R/igraph are great for preprocessing the data (not sure how they compare with Awk), but rather cumbersome to work with when it comes to visualization. Last week, I posted a first Gephi visualization of retweeting at the Free Culture Research Conference and since then I’ve experimented some more (see here and here). #FCRC was a test case for a larger study that examines how academics use Twitter at conferences, which is part of what we’re doing at the junior researchers group Science and the Internet at the University of Düsseldorf (sorry, website is currently in German only).

Here’s a step-by-step description of how those graphs were created. Relationship Explorer. Visualisation graphique de l'information par Pierre Nobis (2008) - Partie 2 - Cartographier ses idées. GUESS: The Graph Exploration System. Using Netvizz & Gephi to Analyze a Facebook Network « sociomantic labs. Gephi, an open source graph visualization and manipulation software.