Statistics with R

5.

Data Import and Export

5.1.

File System Navigation

5.1.1.

Working Directory

5.1.2.

5.1.3.

Relative vs Absolute Paths

5.2.

Importing Delimited Files

5.2.1.

5.2.1.1.

read.csv() Function

5.2.1.2.

read.table() Function

5.2.1.3.

readr::read_csv() Function

5.2.2.

Tab-delimited Files

5.2.3.

Custom Delimiters

5.2.4.

Handling Headers

5.2.5.

Specifying Data Types

5.2.6.

Handling Missing Values

5.2.7.

Character Encoding

5.3.

Importing Excel Files

5.3.1.

5.3.1.1.

read_excel() Function

5.3.1.2.

Sheet Selection

5.3.1.3.

Range Selection

5.3.2.

openxlsx Package

5.3.3.

Handling Multiple Sheets

5.4.

Importing from Statistical Software

5.4.1.

5.4.1.1.

5.4.1.2.

5.4.1.3.

5.4.2.

foreign Package

5.4.3.

Preserving Labels and Attributes

5.5.

Database Connections

5.5.1.

5.5.2.

RSQLite Package

5.5.3.

Connecting to Databases

5.5.4.

SQL Queries in R

5.5.5.

ODBC Connections

5.6.

Web Data Import

5.6.1.

Reading from URLs

5.6.2.

Web Scraping Basics

5.6.3.

API Data Access

5.7.

5.7.1.

Writing CSV Files

5.7.1.1.

write.csv() Function

5.7.1.2.

write.table() Function

5.7.1.3.

readr::write_csv() Function

5.7.2.

Exporting to Excel

5.7.2.1.

writexl Package

5.7.2.2.

openxlsx Package

5.7.3.

Saving R Objects

5.7.3.1.

save() Function

5.7.3.2.

saveRDS() Function

5.7.3.3.

load() Function

5.7.3.4.

readRDS() Function

Previous

4. R Data Structures

Go to top

Next

6. Data Cleaning and Preprocessing