On Mon, Feb 11, 2013 at 6:49 PM, Dario Taraborelli
<dtaraborelli(a)wikimedia.org> wrote:
that's great to hear, thanks Oliver for taking the
lead on this and Jeff/Andrew for your support
On Feb 11, 2013, at 9:41 AM, Andrew Otto <otto(a)wikimedia.org> wrote:
> Awessoooome!
>
>
> On Feb 11, 2013, at 12:21 PM, Oliver Keyes <okeyes(a)wikimedia.org> wrote:
>
>> Any R nerds with Stat1 access: Stat1 now has the RMySQL package installed. What
this means is the following; if you have something from the db you want to analyse,
there's no need to faff around on the command line or inside MySQL to manually export
it as a file, import it into R, analyse it, and then leave a big juicy TSV around for
people to poke at when they're bored. You can run SQL queries against the slaves from
inside R, and have these queries and associated data fall off and die as soon as you close
the session or run rm(). It's also good for replicability, since people will now
(largely) be able to retrieve the same data and run the same analysis using a single
script. Thanks to Jeff Green and Andrew Otto for getting it up and running :).
I didn't read this blog yet but it looks relevant to you guys. See below.
-Jeremy
---------- Forwarded message ----------
From: Dan Nguyen <dn(a)skift.com>
Date: Tue, Feb 12, 2013 at 1:50 PM
Subject: [NICAR-L] 10 R packages I wish I knew about earlier
http://blog.yhathq.com/posts/10-R-packages-I-wish-I-knew-about-earlier.html
The subject is actually just the title of the post, I've barely ever
used R though this really well-illustrated list has convinced me to
put more effort into checking it out. I especially like the libraries
that can directly access your SQL databases and let you write SQL
inside an R script.
--
Dan Nguyen
Head of Data at
Skift.com
Twitter: @dancow
dn(a)skift.com