Importing (and Exporting) Data in R-About This Course
About This Course
Importing (and Exporting) Data in R-Tibbles
Tibbles
Creating a tibble
Subsetting
Importing (and Exporting) Data in R-Spreadsheets
Spreadsheets
Excel files
Google Sheets
Importing (and Exporting) Data in R-CSVs
CSVs
Downloading CSV files
Reading CSVs into R
Importing (and Exporting) Data in R-TSVs
TSVs
Reading TSVs Files into R
Importing (and Exporting) Data in R-Delimited Files
Delimited Files
Reading Delimited Files into R
Importing (and Exporting) Data in R-Exporting Data from R
Exporting Data from R
JSON, XML, and Databases-JSON
JSON
JSON, XML, and Databases-XML
XML
JSON, XML, and Databases-Databases
Databases
Relational Data
Relational Databases: SQL
Connecting to Databases: RSQLite
Working with Relational Data: dplyr & dbplyr
Mutating Joins
Filtering Joins
How to Connect to a Database Online
Web Scraping and APIs-Web Scraping
Web Scraping
rvest Basics
SelectorGadget
Web Scraping Example
A final note: SelectorGadget
Web Scraping and APIs-Application Programming Interfaces (APIs)
API
Getting Data: httr
Example 1: GitHub’s API
Example 2: Obtaining a CSV
read_csv() from a URL
API keys
Foreign Formats, Images, and googledrive-Foreign Formats
haven
Foreign Formats, Images, and googledrive-Images
Images
Foreign Formats, Images, and googledrive-googledrive
googledrive
Case Studies-Case Study #1: Health Expenditures
Case Study #1: Health Expenditures
Healthcare Coverage Data
Healthcare Spending Data
Case Studies-Case Study #2: Firearms
New Case Study #2: Firearms
Census Data
Counted Data
Suicide Data
Brady Data
Crime Data
Land Area Data
Unemployment Data
Project: Importing Data into R-Introduction, Instructions and Datasets
Introduction and Background
Datasets