« Because it's Friday: What is fire made of? | Main | The most influential data scientists on Twitter »

December 17, 2012

TrackBack

TrackBack URL for this entry:
http://www.typepad.com/services/trackback/6a010534b1db25970b017ee65af6b5970d

Listed below are links to weblogs that reference How to select and merge R data frames with SQL:

Comments

Feed You can follow this conversation by subscribing to the comment feed for this post.

This is great! I have worked with Excel, R, SPSS ... but when it came down to writing custom reports requiring heavyweight data lifting and manipulations, I always ended up relying on SQL. Integrating it with R simply makes it easier for analysis. Is this SQL reliant on ANSI standards?

You're much better off doing the relational manipulation of data in the database engine. Just compare the performance of merge in R with join in any decent relational database. A shoemaker had best stick to his last. We have no need for a half-baked SQL engine.

Forget SQL in R and use the data.table package. This is the most elegant and computationally efficient way to work in R (...and more...) with "tables":

http://files.meetup.com/1406240/Data%20munging%20with%20SQL%20and%2...

It´s a new and good way to get most of the troubles away. Thank you very much for sharing it.
I took part in a SQL Workshop, where they highlighted all the important points due to SQL and I must admit that I made good experiences with it.
So I would recommend it to those people who wants to take a closer look at it.

The comments to this entry are closed.


R for the Enterprise

Got comments or suggestions for the blog editor?
Email David Smith.
Follow revodavid on Twitter Follow David on Twitter: @revodavid

Search Revolutions Blog