5.1 Basic sql with sqldf in R
This video show how to use the sqldf R package to use basic sql in R. We see how to use sql to select variables and create new variables in data frames.
Note that the video shows basic R running on Mac OS but the general idea as well as look and feel is similar to R running on other operating systems with different GUIs.
This video is part of the resources for the MAT013 course on SAS and R taught at Cardiff University.
http://drvinceknight.github.com/MAT013/