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
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
(Locked)
What are CSV files?2m 53s
-
(Locked)
Importing CSV files into R6m 39s
-
(Locked)
What are TSV files?1m 29s
-
(Locked)
Importing TSV files into R6m 3s
-
(Locked)
Importing delimited files into R3m 33s
-
(Locked)
Importing fixed-width files into R3m 38s
-
(Locked)
Importing Excel files into R5m 44s
-
(Locked)
Reading data from databases and the web2m 20s
-
(Locked)
-
-
-
-
-
-