Yesterday I showed how to do some data wrangling in VBA and Google Apps Script that Tony Hirst on his oUseful blog had done using scraperwiki, Open refine plus various APIs. Today he posted a quick analysis using […]
I just saw a great post by Tony Hirst on his oUseful blog where he nicely laid out how to use Open refine plus various APIs to research which candidates were standing for election in […]
A while ago, I posted something about interesting scraperwiki data, that’s to say public web scrapings that people had created at some point. In getting scraperwiki data into excel, I showed how you could get a […]
I saw a great blog post on Reshaping Horse Import/Export Data to Fit a Sankey Diagram from Tony Hirst a few minutes ago. In it he shows how to mashup various bits and pieces using […]
I don’t know about you, but I have trouble keeping all my various Google Apps Script shortcuts and keys (links to workbooks, links to content service queries, library keys and so on) under control and […]
Lately I’ve been posting about the Google Apps Script Content Service and how to use it as a ‘serverless’ Rest API service. In addition, I covered how to use the ScriptDB as a secure repository for […]
In scraping the scraper I showed how to get scraperwiki data into both Excel and Google Apps Script. More interestingly though, I was talking about data for which others had already done the legwork to create […]
In this post about using the scraperwiki API I covered how to get a list of publicly available scraperWiki data straight into Excel and Google Apps Script. Now you can get the associated data too with just […]
ScraperWiki API I’ve been taking a look at scraperWiki lately. In case you haven’t come across it, it’s a framework to allow you to scrape structured data from web sites using various data manipulation tools and code. […]
Thanks to Tony Hirst blog, where he demonstrates the Ergast API I have another entry to make in the Rest-Excel library. This time, it’s all the F1 races to start with, along with the possibility […]
I got this idea from Tony Hirst’s great blog. The OpenCorporates API gives rich information many companies. Using Google Refine to reconcile, it cleans up many sources of data to a queryable datasource. So here […]
bruce mcpherson is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. Based on a work at http://www.mcpher.com. Permissions beyond the scope of this license may be available at code use guidelines