Archive for the google spreadsheets Tag

Matt Wells on The Guardian’s interactive protests Twitter map

The Guardian have published an impressive map displaying Twitter coverage of protests around the Arab world and the Middle East. I asked Matt Wells, who oversaw the project, to explain how it came about. The initial idea, which I should credit to deputy editor Ian Katz, was to build something that showcased the tweets of our correspondents, along a broader
Read more…

Posted by Paul Bradshaw on Feb 24, 2011
data journalism, newspapers • Tags: , , , , , , , , • Comment feed RSS 2.0 - Read this post
• 2 Comments

Solving buggy behaviour when scraping data into Google spreadsheets

Tony Hirst has identified some bugs in the way Google spreadsheets ‘scrapes’ tables from other sources. In particular, when the original data is of mixed types (e.g. numbers and text). The solution is summed up as follows: “When using the =QUERY() formula, make sure that you’re importing data of the same datatype in each cell; and when using the =ImportData()formula, cast the
Read more…

Posted by Paul Bradshaw on Nov 16, 2010
data journalism • Tags: , , • Comment feed RSS 2.0 - Read this post
• 1 Comment