Fwd: [okfn-labs] automating connection of CKAN to R stats package

[Jim Craner]

Given two large tables of data sharing an overlapping key column,
integrate and analyze them in a few seconds by using CKAN and R
together. Sweet!


---------- Forwarded message ----------
From: Rufus Pollock <rufus....@okfn.org>
Date: Thu, Jul 26, 2012 at 4:29 PM
Subject: Re: [okfn-labs] automating connection of CKAN to R stats package
To: Martin Keegan <martin...@okfn.org>
Cc: okfn...@lists.okfn.org


On 26 July 2012 22:00, Martin Keegan <martin...@okfn.org> wrote:
> Hello,
>
> part of my project exploring automating processing of tabular data has
> been recorded as a video, which is here:
> http://mk.ucant.org/media/ckan-to-r.flv; the last three post on my
> blog give some more details; if you were at the recent OKF staff
> summit you'll have seen a failed demo of basically what's in the
> video, which goes out of its way to show it's not being faked - the
> real work could be typed in in about 20 seconds.

this is fantastic Martin. Data from CKAN -> R -> integrated and
analyzed in 20s :-)

BTW for those note able to dig out the posts they are:

Project Ronald, an introduction: http://blog.ucant.org/?p=393

Project Ronald, an example: http://blog.ucant.org/?p=414

Quoting from the second of these posts:

<quote>
The first objective of Project Ronald is to make it easy to connect
tabular datasets quickly: given two openly-licensed tabular datasets
containing a common field, but published by different organisations,
it ought to be possible to get them downloaded and joined together in
a few seconds. The approach is to identify the components of a system
which would do this, implement a minimal version of each, check that
the system works as a whole, and then go about replacing each
component with better tools, preferably ones already written and
matured by someone else.
</quote>

And finally code on github:

https://github.com/mk270/ronald

Rufus

_______________________________________________
okfn-labs mailing list
okfn...@lists.okfn.org
http://lists.okfn.org/mailman/listinfo/okfn-labs


--
-----
Jim Craner, 2012 Fellow
Code for America
j...@codeforamerica.org
(+1) 773-809-4546
http://codeforamerica.org