589 search results for "sql"

Life Is Short, Use Python

November 24, 2010
By
Life Is Short, Use Python

Life is short, use PythonI started to play with Python two weeks ago due to the limitation of R in terms of handling large data, then a friend of mine suggested me to try Python since I had to do data massage frequently, "Python is the best choice, trust me", he...

Read more »

Finally! A practical R book on Data Mining: "Data Mining With R, Learning with Case Studies," by Luis Torgo

November 19, 2010
By
Finally! A practical R book on Data Mining:  "Data Mining With R, Learning with Case Studies," by Luis Torgo

I've been a bit busy lately with a few big things, however, I wanted to stop by and mention a fantastic book for those who have been following along the R examples.  Anyone who's followed my blog knows that I'm big on practical books with examples...

Read more »

RMongo: Accessing MongoDB in R

November 3, 2010
By

I recently created RMongo, a database access layer to MongoDB in R as an R package. To install RMongo, download it from https://github.com/quid/RMongo/downloads Run: R CMD install RMongo_0.0.17.tar.gz I tried to mimic the RMySQL commands in RMongo. Bel...

Read more »

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 »