Using Data From Linked Data Datastores the Easy Way (i.e. in a spreadsheet, via a formula) « OUseful.Info, the blog…
Anyway – this is my starter for ten on how to make live datastore data available to the masses. It’ll be interesting to see whether this approach (or one like it) is used in favour of getting temps to write SPARQL queries and RDF parsers… The obvious problem is that my approach can lead to an explosion in the number of formulae and parameters you need to learn; the upside is that I think these could be quite easily documented in a matrix/linked formulae chart. The approach also scales to pulling in data from CSV stores and other online spreadsheets, using spreadsheets as a database via the =QUERY() formula (e.g. Using Google Spreadsheets Like a Database – The QUERY Formula), and so on. There might also be a market for selling prepackaged or custom formulae as script bundles via a script store within a larger Google Apps App store… | source : ouseful.wordpress.com
Recommandé parPaul Bradshaw le 24/02/10 21:21 | permalien
Grabbing “Facts” from the Guardian Datastore with a Google Spreadsheets Formula « OUseful.Info, the blog…
That is, how about defining a simple spreadsheet function that lets us look up a particular data value for a particular subject and a particular institution? How about being able to write a formula like: =gds_education_unitable(“elecEng”,”Leeds”,”NSSTeachingPerCent”) and get the national student satisfaction survey teaching satisfaction result back from students studying Electrical/Electronic Engineering at Leeds University? | source : ouseful.wordpress.com
Recommandé parPaul Bradshaw le 23/02/10 15:33 | permalien
Online Apps for Live Code Tutorials/Demos « OUseful.Info, the blog…
some tools/techniques for hacking around with code via a browser, or running interactive coding presentations in a browser… | source : ouseful.wordpress.com
Recommandé parPaul Bradshaw le 23/02/10 15:29 | permalien
OUseful.Info, the blog...
Paragraph level feeds, as implemented in the Digress.it WordPress theme we were developing, are keyed by URLs of the form: http://writetoreply.org/legaldeposit/feed/paragraphlevel/annex-c-online-content-to-be-published/#56 That is: http://writetoreply.org/DOCNAME/feed/paragraphlevel/PAGENAME/#PARA_NUMBER So can you guess what I’m gonna do yet…? First of all, grab the search feed for a particular query on a particular document into a Yahoo Pipe: | source : ouseful.wordpress.com
Recommandé parPaul Bradshaw le 18/02/10 13:19 | permalien
Data Scraping Wikipedia with Google Spreadsheets « OUseful.Info, the blog…
The Google spreadsheet function =importHTM(“”,”table”,N) will scrape a table from an HMTL web page into a Google spreadsheet. The URL of the target web page, and the target table element both need to be in double quotes. The number N identifies the N’th table in the page (counting starts at 0) as the target table for data scraping. | source : ouseful.wordpress.com
Recommandé parPaul Bradshaw le 16/02/10 21:34 | permalien
Asymmetric Disclosure in Social Networks « OUseful.Info, the blog…
So for example, if I am a member of a social network that supports private groups and I put You in one of My private groups, and You put Me in one of Your public groups, should Our relationship be publicly disclosd on Your profile? A ‘real world’ version of this (?maybe): suppose You have a problem. You ask Me for a chat about it over coffee in a public coffee shop. Under what circumstances should I be able to disclose in public that You and I had that coffee together? | source : ouseful.wordpress.com
Recommandé parPaul Bradshaw le 14/02/10 21:34 | permalien
Experimenting with the Form… « OUseful.Info, the blog…
One of the challenges I’ve set myself this year is to write some sort of book about Yahoo Pipes. Reading Presentation Zen three or four weeks ago, I started to imagine the form such a book might take. | source : ouseful.wordpress.com
Recommandé parPaul Bradshaw le 13/02/10 22:13 | permalien
Just Because You Don’t Give Your Personal Data to Google Doesn’t Mean They Can’t Acquire It « OUseful.Info, the blog…
1) Just because you haven’t given Google your Twitter details, Google may know you’re my friend becuase I have given Google my twitter details and my friends and followers lists are public (an ‘asymmetric disclosure’? So for example, for a symmetric disclosure, Google might only use the belief that we’re friends if I follow you AND you have given Google your Twitter credentials AND you follow me. But if it you uses you to inform my results simply because I follow you, that would be asymmetric?) 2) Just because you haven’t given Google any personal info, Google might buy a company you have disclosed personal information to and then assimilate it into their growing total information awareness… (You do know Google owns Youtube, don’t you, and so has a pretty good idea of everything you’ve watched on it?;-) 3) Your mum may be influencing your search results… And you might be influencing your kids’ results… ;-) | source : ouseful.wordpress.com
Recommandé parPaul Bradshaw le 13/02/10 21:30 | permalien
Using Google Spreadsheets Like a Database – The QUERY Formula « OUseful.Info, the blog…
So today’s trick is prompted by a request from @paulbradshaw about “how to turn a spreadsheet into a form-searchable database for users” within a Google spreadsheet (compared to querying a google spreadsheet via a URI, as described in Using Google Spreadsheets as a Database with the Google Visualisation API Query Language). | source : ouseful.wordpress.com
Recommandé parPaul Bradshaw le 20/01/10 11:27 | permalien