Using SQL from R: A short introduction
mediaposted on 28.03.2018 by Deveshnie Mudaly
Media is any form of research output that is recorded and played. This is most commonly video, but can be audio or 3D representations.
Video recording of Deveshnie Mudaly's presentation, entitled "Using SQL from R: A short introduction" presented at SatRday Cape Town, UCT, 17 March 2018
The sqldf package can be used to execute SQL statements in R. For those competent in SQL, this function is extremely useful. SQL is a powerful language and, when used in conjunction with R, can enhance and improve the analysis of data. I have made use of SQL to simplify my data frames quickly.