Learning How to Import Data

Load Packages

Haven

A source that teaches R how to read SPSS

https://www.rdocumentation.org/packages/haven/versions/2.5.1

install.packages("haven")

Installing package into '/cloud/lib/x86_64-pc-linux-gnu-library/4.2'
(as 'lib' is unspecified)

library(haven)

Tidyverse

Tidyverse is a set of R packages used to easily install core R packages.

https://www.rdocumentation.org/packages/tidyverse/versions/1.3.2

install.packages("tidyverse")

Installing package into '/cloud/lib/x86_64-pc-linux-gnu-library/4.2'
(as 'lib' is unspecified)

library(tidyverse)

── Attaching packages ─────────────────────────────────────── tidyverse 1.3.2 ──
✔ ggplot2 3.4.0      ✔ purrr   1.0.1 
✔ tibble  3.1.8      ✔ dplyr   1.0.10
✔ tidyr   1.2.1      ✔ stringr 1.5.0 
✔ readr   2.1.3      ✔ forcats 0.5.2 
── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
✖ dplyr::filter() masks stats::filter()
✖ dplyr::lag()    masks stats::lag()

Openxlsx

Openxlsx simplifies the creatin of excel.

https://rdocumentation.org/packages/openxlsx/versions/4.2.5.1

install.packages("openxlsx")

Installing package into '/cloud/lib/x86_64-pc-linux-gnu-library/4.2'
(as 'lib' is unspecified)

library(openxlsx)

Import Data

Excel

dataset.xls <- read.xlsx ("Harry Potter Data.xlsx", sheet = 1, colNames = FALSE, startRow = 3)

CSV

dataset.csv <- read_csv("Harry Potter Data.csv")

Rows: 124 Columns: 90
── Column specification ────────────────────────────────────────────────────────
Delimiter: ","
chr (90): StartDate, EndDate, Status, IPAddress, Progress, Duration (in seco...

ℹ Use `spec()` to retrieve the full column specification for this data.
ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

SPSS

dataset.spss <- read_sav ("Harry Potter Data.sav")

SPSS from the Web

dataset.spss.web <- read_sav ("https://osf.io/kd4ej/download")

Bonus Points

CSV from the Web

dataset.csv.web <- read_csv("https://osf.io/download/wtghz/")

Rows: 124 Columns: 90
── Column specification ────────────────────────────────────────────────────────
Delimiter: ","
chr (90): StartDate, EndDate, Status, IPAddress, Progress, Duration (in seco...

ℹ Use `spec()` to retrieve the full column specification for this data.
ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Excel from the Web

dataset.xls.web <- read.xlsx("https://osf.io/download/7fz89/", sheet = 1, colNames = FALSE, startRow = 3)