Learning How to Import Data

Load Packages

if (!require(haven)){
  # If it's not installed, then tell R to install it.
  install.packages("haven", dependencies = TRUE)
  # Once it's installed, tell R to load it.
  library(haven)
}

Loading required package: haven

if (!require(tidyverse)){
  # If it's not installed, then tell R to install it.
  install.packages("tidyverse", dependencies = TRUE)
  # Once it's installed, tell R to load it.
  library(tidyverse)
}

Loading required package: tidyverse

── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
✔ dplyr     1.1.4     ✔ readr     2.1.5
✔ forcats   1.0.0     ✔ stringr   1.5.1
✔ ggplot2   3.4.4     ✔ tibble    3.2.1
✔ lubridate 1.9.3     ✔ tidyr     1.3.1
✔ purrr     1.0.2     
── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
✖ dplyr::filter() masks stats::filter()
✖ dplyr::lag()    masks stats::lag()
ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors

if (!require(openssl)){
  # If it's not installed, then tell R to install it.
  install.packages("openssl", dependencies = TRUE)
  # Once it's installed, tell R to load it.
  library(openssl)
}

Loading required package: openssl

Linking to: OpenSSL 1.1.1f  31 Mar 2020

Import Data

dataset.xlsx <- readxl::read_xlsx ("Harry Potter Data.xlsx")

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

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

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

Bonus Points

dataset.csv <- read.csv ("https://osf.io/gcrz9/files/osfstorage/5ec12f42221cb1006b136458/download")

dataset.csv <- read.csv ("https://osf.io/gcrz9/files/osfstorage/5ec12f42221cb1006b136458/download")