R Import Data

Load Packages

haven

if (!require(haven)){
  install.packages("haven", dependencies = TRUE)
  library(haven)
}

tidyverse

if(!require(tidyverse)){
  install.packages("tidyverse", dependencies = TRUE)
  library(tidyverse)}

openxlsx

if(!require(openxlsx)){
  install.packages("openxlsx", dependencies = TRUE)
  library(openxlsx)}

Import data

Excel

dataset.xls <- read.xlsx ("Harry Potter Data.xlsx")

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 se...
ℹ 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")

Openxlsx from the web

dataset.xls.web <- read.xlsx ("https://osf.io/7fz89/download")

CSV from the web

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

Rows: 124 Columns: 90── Column specification ──────────────────────────────────────────────────────
Delimiter: ","
chr (90): StartDate, EndDate, Status, IPAddress, Progress, Duration (in se...
ℹ 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.