Re:Data Scraping Wikipedia with Google Spreadsheets
by EastSmith on Wednesday October 15, 2008 @10:02AM
(#333286)
"So to recap, we have scraped some data from a wikipedia page into a Google spreadsheet using the =importHTML formula, published a handful of rows from the table as CSV, consumed the CSV in a Yahoo pipe and created a geocoded KML feed from it, and then displayed it in a Yahoo map."
Re:Data Scraping Wikipedia with Google Spreadsheets
by blakeweb on Wednesday October 15, 2008 @12:36PM
(#333437)
Fantastic. Such a cleaner method than copy-pasting table data from web pages into excel to visualize and manipulate it, which I've done countless times doing market research.
Re:Data Scraping Wikipedia with Google Spreadsheets
by zandorg on Wednesday October 15, 2008 @08:53PM
(#333989)
My BSc dissertation was on a simplified English dialect (language) which can be translated into triplets (or data items) while still being readable as English. However, I never really finished the editor it required which hooked up to a parser to show you the triplets as you type.
Re:Data Scraping Wikipedia with Google Spreadsheets
by PJGoldwing on Thursday October 16, 2008 @12:06PM
(#334572)
Bravo! One of the most useful submissions to HN in a while. This is the kind of thing that gives my faith in tech a little boost - "throwing sheep at your friends on facebook" or cute productivity apps that reduce your productivity are not.
Hilarious!
Also, I'm bad at getting traction on my ideas.