课程: Data Wrangling in R

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Reading data from databases and the web

Reading data from databases and the web

课程: 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…

内容