Learn R - Import Data

Load Packages

haven

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

tidyverse

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

openxlsx

Import data

Excel

dataset.xls <- read.xlsx("Harry Potter Data.xlsx", 
                         sheet = 1,
                         colNames = FALSE,
                         rowNames = FALSE,
                         detectDates = TRUE)

Error in read.xlsx("Harry Potter Data.xlsx", sheet = 1, colNames = FALSE,  : 
  could not find function "read.xlsx"

CSV

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

Error: 'Harry Potter Data.csv' does not exist in current working directory ('/cloud/project').

SPSS

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

Error: 'Harry Potter Data.spss' does not exist in current working directory ('/cloud/project').

SPSS from the web

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