From the course: Data Wrangling in R

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Reading data from databases and the web

Reading data from databases and the web

From the course: Data Wrangling in R

Reading data from databases and the web

- [Instructor] Sometimes, the data we need isn't stored in a clean file ready for our analysis. We need to pull it from databases or web services. R provides facilities for both of these cases. Now, there are several ways that data scientists can pull data from enterprise databases into R for analysis. The most popular of these is the RODBC package. This package includes functions that allow R to retrieve data from databases supporting the ODBC standard. Now ODBC stands for open database connectivity, and it's a standard that's more than 25 years old. It allows developers to access database information without worrying about the type of database underneath. Now, ODBC is compatible with major enterprise databases, including MySQL, Oracle, and Microsoft SQL Server. It also works with end user databases and spreadsheets like Microsoft Access and Excel. The RODBC package provides functionality that allows developers to open…

Contents