Tagged: sqldf

Last Thursday, we spoke briefly about sqldf, an R package for using SQL (“Structured Query Language”), which is a standardized way to get information out of many database systems. SQL is easy to learn, and is especially useful if you’re interested in interacting with others’ data (since those data will often be stored in a database). I recommended the W3Schools tutorial on SQL, which only takes a few hours to get through (I don’t like some of W3School’s other tutorials, but their SQL tutorial is a fine introduction, I think).

Below is the code that I presented for generating an example dataset and then experimenting with SQL: