learning how to import data

Load packages

haven

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

Loading required package: haven

tidyverse

if (!require(tidyverse)){
  install.packages("tidyverse", dependencies = TRUE)
  require(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.5.1     ✔ 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

openxlsx

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

Loading required package: openxlsx

import data

Excel

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

Loading required package: Excel

Warning in library(package, lib.loc = lib.loc, character.only = TRUE,
logical.return = TRUE, : there is no package called 'Excel'

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

Warning: package 'Excel' is not available for this version of R

A version of this package for your version of R might be available elsewhere,
see the ideas at
https://cran.r-project.org/doc/manuals/r-patched/R-admin.html#Installing-packages

Loading required package: Excel

Warning in library(package, lib.loc = lib.loc, character.only = TRUE,
logical.return = TRUE, : there is no package called 'Excel'

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

CSV

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

Loading required package: CSV

Warning in library(package, lib.loc = lib.loc, character.only = TRUE,
logical.return = TRUE, : there is no package called 'CSV'

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

Warning: package 'CSV' is not available for this version of R

A version of this package for your version of R might be available elsewhere,
see the ideas at
https://cran.r-project.org/doc/manuals/r-patched/R-admin.html#Installing-packages

Warning: Perhaps you meant 'csv' ?

Loading required package: CSV

Warning in library(package, lib.loc = lib.loc, character.only = TRUE,
logical.return = TRUE, : there is no package called '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

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

Loading required package: SPSS

Warning in library(package, lib.loc = lib.loc, character.only = TRUE,
logical.return = TRUE, : there is no package called 'SPSS'

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

Warning: package 'SPSS' is not available for this version of R

A version of this package for your version of R might be available elsewhere,
see the ideas at
https://cran.r-project.org/doc/manuals/r-patched/R-admin.html#Installing-packages

Loading required package: SPSS

Warning in library(package, lib.loc = lib.loc, character.only = TRUE,
logical.return = TRUE, : there is no package called 'SPSS'

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

SPSS from the web

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

Loading required package: SPSSW

Warning in library(package, lib.loc = lib.loc, character.only = TRUE,
logical.return = TRUE, : there is no package called 'SPSSW'

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

Warning: package 'SPSSW' is not available for this version of R

A version of this package for your version of R might be available elsewhere,
see the ideas at
https://cran.r-project.org/doc/manuals/r-patched/R-admin.html#Installing-packages

Loading required package: SPSSW

Warning in library(package, lib.loc = lib.loc, character.only = TRUE,
logical.return = TRUE, : there is no package called 'SPSSW'

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