by
Andrew Redd, PhD
Seminar date: 9/10/2020
Description: Andrew Redd, VINCI Helpdesk Staff, will present methods for efficiently working with data within VINCI. This presentation will cover establishing connections to MSSQL servers; merging, filtering, cleaning, and aggregating data on the servers; pulling data into R for analysis and pushing data back to database servers. The presentation will focus around the dplyr and dbplyr packages for R. Intended Audience: Any R Programmer, Familiarity with R will be assumed.
DOWNLOAD: Request PDF Handout | Audio only (mp3) | transcript