566 search results for "sql"

R wanted for an intern at Barron’s

October 13, 2010
By

R/SQL/scripting, oodles of data, a willing outlet for write-ups. Any takers? Do some good. Intern at Barron’s, the New York financial publication with a decades-long tradition of investigative journalism and a more recent commitment to data analytic exposure of fraud in finance, business and healthcare. Bring us your zeal and your data munging skills and

Read more »

ProjectTemplate Version 0.1-3 Released

October 2, 2010
By

I’ve just released the newest version of ProjectTemplate. The primary change is a completely redesigned mechanism for automatically loading data. ProjectTemplate can now read compressed CSV files, access CSV data files over HTTP, read Stata, SPSS and RData binary files and even load MySQL database tables automatically. For my own projects, this is a big

Read more »

CouchDB and R

October 2, 2010
By
CouchDB and R

Here are some quick crib notes on getting R talking to CouchDB using Couch's ReSTful HTTP API. We'll do it in two different ways. First, we'll construct HTTP calls with RCurl, then move on to the R4CouchDB package for a higher level interface. I'll a...

Read more »

CouchDB and R

October 2, 2010
By
CouchDB and R

Here are some quick crib notes on getting R talking to CouchDB using Couch's ReSTful HTTP API. We'll do it in two different ways. First, we'll construct HTTP calls with RCurl, then move on to the R4CouchDB package for a higher level interface. I'll assume you've already gotten started with CouchDB...

Read more »

How to send an HTTP PUT request from R

September 27, 2010
By
How to send an HTTP PUT request from R

I wanted to get R talking to CouchDB. CouchDB is a NoSQL database that stores JSON documents and exposes a ReSTful API over HTTP. So, I needed to issue the basic HTTP requests: GET, POST, PUT, and DELETE from within R. Specifically, to get started, I...

Read more »

How to send an HTTP PUT request from R

September 27, 2010
By
How to send an HTTP PUT request from R

I wanted to get R talking to CouchDB. CouchDB is a NoSQL database that stores JSON documents and exposes a ReSTful API over HTTP. So, I needed to issue the basic HTTP requests: GET, POST, PUT, and DELETE from within R. Specifically, to get started, I wanted to add documents to the...

Read more »

Find Duplicate Records in a File

September 24, 2010
By
Find Duplicate Records in a File

In the world of data preparation a common task is to identify duplicate records in a file or data set.  A few years ago, I did most development work in Java, and shudder to think of the amount of code required to accomplish this sort of task. &nbs...

Read more »

Find Duplicate Records in a File

September 24, 2010
By
Find Duplicate Records in a File

In the world of data preparation a common task is to identify duplicate records in a file or data set.  A few years ago, I did most development work in Java, and shudder to think of the amount of code required to accomplish this sort of task. &nbs...

Read more »

Connecting to a MongoDB database from R using Java

September 24, 2010
By
Connecting to a MongoDB database from R using Java

It would be nice if there were an R package, along the lines of RMySQL, for MongoDB. For now there is not – so, how best to get data from a MongoDB database into R? One option is to retrieve JSON via the MongoDB REST interface and parse it using the rjson package. Assuming, for

Read more »

R Project and Google Summer of Code: Wrapping up

September 23, 2010
By
R Project and Google Summer of Code: Wrapping up

As this year's admin, I wrote up the following summary which has now been posted at the R site in the appropriate slot. My thanks to this year's students, fellow mentors and everybody else who helped to make it happen. ...

Read more »