SQL-like functionality in R

Question

I am used to writing data manipulation logic in SQL and now that I am learning R I find myself sometimes just wanting to do something that would be simple in SQL but I have to learn a bunch of stuff with R to do the same manipulation on an R data frame. Is there a simple work around?

Answer 1

look at the package sqldf. http://code.google.com/p/sqldf/ It seems perfect for your needs.