Connect R to WAI Database

In order to make the connection between R and the database, you need to have RStudio first. You can download RStudio for free by clicking here.

Once you’ve opened RStudio, go to Tools –> Install Packages…

And it will open a window prompting you for a package. Under the title “Packages,” type in “RMySQL” and hit install.

Screen Shot 2016-09-27 at 7.14.19 PM

Once the package is installed, you can now establish the connection between R and the WAI database, and obtain the data. You can access the simplified code for the connection by clicking AccessWAIThroughR.