Learning How to Create a Data Codebook

Load Packages

haven

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

Loading required package: haven

tidyverse

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

Loading required package: tidyverse
Warning: there is no package called ‘tidyverse’Installing package into ‘/cloud/lib/x86_64-pc-linux-gnu-library/4.4’
(as ‘lib’ is unspecified)
also installing the dependencies ‘colorspace’, ‘farver’, ‘labeling’, ‘munsell’, ‘RColorBrewer’, ‘viridisLite’, ‘rematch’, ‘backports’, ‘generics’, ‘blob’, ‘DBI’, ‘data.table’, ‘gtable’, ‘isoband’, ‘scales’, ‘gargle’, ‘uuid’, ‘cellranger’, ‘ids’, ‘timechange’, ‘systemfonts’, ‘textshaping’, ‘selectr’, ‘stringi’, ‘Rcpp’, ‘broom’, ‘conflicted’, ‘dbplyr’, ‘dplyr’, ‘dtplyr’, ‘ggplot2’, ‘googledrive’, ‘googlesheets4’, ‘lubridate’, ‘modelr’, ‘purrr’, ‘ragg’, ‘readxl’, ‘reprex’, ‘rstudioapi’, ‘rvest’, ‘stringr’, ‘tidyr’, ‘xml2’, ‘feather’, ‘mockr’

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/colorspace_2.1-0.tar.gz'
Content type 'application/x-gzip' length 2595307 bytes (2.5 MB)
==================================================
downloaded 2.5 MB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/farver_2.1.2.tar.gz'
Content type 'application/x-gzip' length 1485495 bytes (1.4 MB)
==================================================
downloaded 1.4 MB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/labeling_0.4.3.tar.gz'
Content type 'application/x-gzip' length 59707 bytes (58 KB)
==================================================
downloaded 58 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/munsell_0.5.1.tar.gz'
Content type 'application/x-gzip' length 242364 bytes (236 KB)
==================================================
downloaded 236 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/RColorBrewer_1.1-3.tar.gz'
Content type 'application/x-gzip' length 53281 bytes (52 KB)
==================================================
downloaded 52 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/viridisLite_0.4.2.tar.gz'
Content type 'application/x-gzip' length 1296925 bytes (1.2 MB)
==================================================
downloaded 1.2 MB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/rematch_2.0.0.tar.gz'
Content type 'application/x-gzip' length 15754 bytes (15 KB)
==================================================
downloaded 15 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/backports_1.5.0.tar.gz'
Content type 'application/x-gzip' length 116627 bytes (113 KB)
==================================================
downloaded 113 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/generics_0.1.3.tar.gz'
Content type 'application/x-gzip' length 77807 bytes (75 KB)
==================================================
downloaded 75 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/blob_1.2.4.tar.gz'
Content type 'application/x-gzip' length 47224 bytes (46 KB)
==================================================
downloaded 46 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/DBI_1.2.3.tar.gz'
Content type 'application/x-gzip' length 892938 bytes (872 KB)
==================================================
downloaded 872 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/data.table_1.15.4.tar.gz'
Content type 'application/x-gzip' length 2200359 bytes (2.1 MB)
==================================================
downloaded 2.1 MB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/gtable_0.3.5.tar.gz'
Content type 'application/x-gzip' length 216211 bytes (211 KB)
==================================================
downloaded 211 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/isoband_0.2.7.tar.gz'
Content type 'application/x-gzip' length 1642543 bytes (1.6 MB)
==================================================
downloaded 1.6 MB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/scales_1.3.0.tar.gz'
Content type 'application/x-gzip' length 703254 bytes (686 KB)
==================================================
downloaded 686 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/gargle_1.5.2.tar.gz'
Content type 'application/x-gzip' length 761841 bytes (743 KB)
==================================================
downloaded 743 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/uuid_1.2-0.tar.gz'
Content type 'application/x-gzip' length 47850 bytes (46 KB)
==================================================
downloaded 46 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/cellranger_1.1.0.tar.gz'
Content type 'application/x-gzip' length 102223 bytes (99 KB)
==================================================
downloaded 99 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/ids_1.0.1.tar.gz'
Content type 'application/x-gzip' length 120163 bytes (117 KB)
==================================================
downloaded 117 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/timechange_0.3.0.tar.gz'
Content type 'application/x-gzip' length 200783 bytes (196 KB)
==================================================
downloaded 196 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/systemfonts_1.1.0.tar.gz'
Content type 'application/x-gzip' length 295196 bytes (288 KB)
==================================================
downloaded 288 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/textshaping_0.4.0.tar.gz'
Content type 'application/x-gzip' length 134596 bytes (131 KB)
==================================================
downloaded 131 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/selectr_0.4-2.tar.gz'
Content type 'application/x-gzip' length 488417 bytes (476 KB)
==================================================
downloaded 476 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/stringi_1.8.4.tar.gz'
Content type 'application/x-gzip' length 4319366 bytes (4.1 MB)
==================================================
downloaded 4.1 MB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/Rcpp_1.0.12.tar.gz'
Content type 'application/x-gzip' length 2175519 bytes (2.1 MB)
==================================================
downloaded 2.1 MB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/broom_1.0.6.tar.gz'
Content type 'application/x-gzip' length 1852174 bytes (1.8 MB)
==================================================
downloaded 1.8 MB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/conflicted_1.2.0.tar.gz'
Content type 'application/x-gzip' length 55157 bytes (53 KB)
==================================================
downloaded 53 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/dbplyr_2.5.0.tar.gz'
Content type 'application/x-gzip' length 1227942 bytes (1.2 MB)
==================================================
downloaded 1.2 MB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/dplyr_1.1.4.tar.gz'
Content type 'application/x-gzip' length 1475398 bytes (1.4 MB)
==================================================
downloaded 1.4 MB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/dtplyr_1.3.1.tar.gz'
Content type 'application/x-gzip' length 354458 bytes (346 KB)
==================================================
downloaded 346 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/ggplot2_3.5.1.tar.gz'
Content type 'application/x-gzip' length 4957008 bytes (4.7 MB)
==================================================
downloaded 4.7 MB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/googledrive_2.1.1.tar.gz'
Content type 'application/x-gzip' length 1892308 bytes (1.8 MB)
==================================================
downloaded 1.8 MB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/googlesheets4_1.1.1.tar.gz'
Content type 'application/x-gzip' length 508396 bytes (496 KB)
==================================================
downloaded 496 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/lubridate_1.9.3.tar.gz'
Content type 'application/x-gzip' length 987800 bytes (964 KB)
==================================================
downloaded 964 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/modelr_0.1.11.tar.gz'
Content type 'application/x-gzip' length 199556 bytes (194 KB)
==================================================
downloaded 194 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/purrr_1.0.2.tar.gz'
Content type 'application/x-gzip' length 489702 bytes (478 KB)
==================================================
downloaded 478 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/ragg_1.3.2.tar.gz'
Content type 'application/x-gzip' length 670628 bytes (654 KB)
==================================================
downloaded 654 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/readxl_1.4.3.tar.gz'
Content type 'application/x-gzip' length 871664 bytes (851 KB)
==================================================
downloaded 851 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/reprex_2.1.0.tar.gz'
Content type 'application/x-gzip' length 492401 bytes (480 KB)
==================================================
downloaded 480 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/rstudioapi_0.16.0.tar.gz'
Content type 'application/x-gzip' length 307772 bytes (300 KB)
==================================================
downloaded 300 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/rvest_1.0.4.tar.gz'
Content type 'application/x-gzip' length 293840 bytes (286 KB)
==================================================
downloaded 286 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/stringr_1.5.1.tar.gz'
Content type 'application/x-gzip' length 307634 bytes (300 KB)
==================================================
downloaded 300 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/tidyr_1.3.1.tar.gz'
Content type 'application/x-gzip' length 1182783 bytes (1.1 MB)
==================================================
downloaded 1.1 MB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/xml2_1.3.6.tar.gz'
Content type 'application/x-gzip' length 273887 bytes (267 KB)
==================================================
downloaded 267 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/feather_0.3.5.tar.gz'
Content type 'application/x-gzip' length 135763 bytes (132 KB)
==================================================
downloaded 132 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/mockr_0.2.1.tar.gz'
Content type 'application/x-gzip' length 43254 bytes (42 KB)
==================================================
downloaded 42 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/tidyverse_2.0.0.tar.gz'
Content type 'application/x-gzip' length 425777 bytes (415 KB)
==================================================
downloaded 415 KB

* installing *binary* package ‘colorspace’ ...
* DONE (colorspace)
* installing *binary* package ‘farver’ ...
* DONE (farver)
* installing *binary* package ‘labeling’ ...
* DONE (labeling)
* installing *binary* package ‘RColorBrewer’ ...
* DONE (RColorBrewer)
* installing *binary* package ‘viridisLite’ ...
* DONE (viridisLite)
* installing *binary* package ‘rematch’ ...
* DONE (rematch)
* installing *binary* package ‘backports’ ...
* DONE (backports)
* installing *binary* package ‘generics’ ...
* DONE (generics)
* installing *binary* package ‘blob’ ...
* DONE (blob)
* installing *binary* package ‘DBI’ ...
* DONE (DBI)
* installing *binary* package ‘data.table’ ...
* DONE (data.table)
* installing *binary* package ‘gtable’ ...
* DONE (gtable)
* installing *binary* package ‘isoband’ ...
* DONE (isoband)
* installing *binary* package ‘gargle’ ...
* DONE (gargle)
* installing *binary* package ‘uuid’ ...
* DONE (uuid)
* installing *binary* package ‘timechange’ ...
* DONE (timechange)
* installing *binary* package ‘systemfonts’ ...
* DONE (systemfonts)
* installing *binary* package ‘stringi’ ...
* DONE (stringi)
* installing *binary* package ‘Rcpp’ ...
* DONE (Rcpp)
* installing *binary* package ‘conflicted’ ...
* DONE (conflicted)
* installing *binary* package ‘purrr’ ...
* DONE (purrr)
* installing *binary* package ‘rstudioapi’ ...
* DONE (rstudioapi)
* installing *binary* package ‘xml2’ ...
* DONE (xml2)
* installing *binary* package ‘mockr’ ...
* DONE (mockr)
* installing *binary* package ‘munsell’ ...
* DONE (munsell)
* installing *binary* package ‘cellranger’ ...
* DONE (cellranger)
* installing *binary* package ‘ids’ ...
* DONE (ids)
* installing *binary* package ‘textshaping’ ...
* DONE (textshaping)
* installing *binary* package ‘dplyr’ ...
* DONE (dplyr)
* installing *binary* package ‘googledrive’ ...
* DONE (googledrive)
* installing *binary* package ‘lubridate’ ...
* DONE (lubridate)
* installing *binary* package ‘reprex’ ...
* DONE (reprex)
* installing *binary* package ‘stringr’ ...
* DONE (stringr)
* installing *binary* package ‘feather’ ...
* DONE (feather)
* installing *binary* package ‘scales’ ...
* DONE (scales)
* installing *binary* package ‘selectr’ ...
* DONE (selectr)
* installing *binary* package ‘dtplyr’ ...
* DONE (dtplyr)
* installing *binary* package ‘googlesheets4’ ...
* DONE (googlesheets4)
* installing *binary* package ‘ragg’ ...
* DONE (ragg)
* installing *binary* package ‘readxl’ ...
* DONE (readxl)
* installing *binary* package ‘tidyr’ ...
* DONE (tidyr)
* installing *binary* package ‘broom’ ...
* DONE (broom)
* installing *binary* package ‘dbplyr’ ...
* DONE (dbplyr)
* installing *binary* package ‘ggplot2’ ...
* DONE (ggplot2)
* installing *binary* package ‘rvest’ ...
* DONE (rvest)
* installing *binary* package ‘modelr’ ...
* DONE (modelr)
* installing *binary* package ‘tidyverse’ ...
* DONE (tidyverse)

The downloaded source packages are in
    ‘/tmp/Rtmp23tvJ7/downloaded_packages’
── Attaching core tidyverse packages ─────────────
✔ 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 ]8;;http://conflicted.r-lib.org/conflicted package]8;; to force all conflicts to become errors

summarytools

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

Loading required package: summarytools
Warning: there is no package called ‘summarytools’Installing package into ‘/cloud/lib/x86_64-pc-linux-gnu-library/4.4’
(as ‘lib’ is unspecified)
also installing the dependencies ‘lobstr’, ‘plyr’, ‘reshape2’, ‘svglite’, ‘checkmate’, ‘magick’, ‘matrixStats’, ‘pander’, ‘pryr’, ‘rapportools’, ‘formatR’, ‘kableExtra’

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/lobstr_1.1.2.tar.gz'
Content type 'application/x-gzip' length 143660 bytes (140 KB)
==================================================
downloaded 140 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/plyr_1.8.9.tar.gz'
Content type 'application/x-gzip' length 821625 bytes (802 KB)
==================================================
downloaded 802 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/reshape2_1.4.4.tar.gz'
Content type 'application/x-gzip' length 117333 bytes (114 KB)
==================================================
downloaded 114 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/svglite_2.1.3.tar.gz'
Content type 'application/x-gzip' length 203599 bytes (198 KB)
==================================================
downloaded 198 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/checkmate_2.3.1.tar.gz'
Content type 'application/x-gzip' length 738653 bytes (721 KB)
==================================================
downloaded 721 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/magick_2.8.3.tar.gz'
Content type 'application/x-gzip' length 5014586 bytes (4.8 MB)
==================================================
downloaded 4.8 MB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/matrixStats_1.3.0.tar.gz'
Content type 'application/x-gzip' length 477900 bytes (466 KB)
==================================================
downloaded 466 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/pander_0.6.5.tar.gz'
Content type 'application/x-gzip' length 917584 bytes (896 KB)
==================================================
downloaded 896 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/pryr_0.1.6.tar.gz'
Content type 'application/x-gzip' length 207258 bytes (202 KB)
==================================================
downloaded 202 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/rapportools_1.1.tar.gz'
Content type 'application/x-gzip' length 128710 bytes (125 KB)
==================================================
downloaded 125 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/formatR_1.14.tar.gz'
Content type 'application/x-gzip' length 150069 bytes (146 KB)
==================================================
downloaded 146 KB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/kableExtra_1.4.0.tar.gz'
Content type 'application/x-gzip' length 2046515 bytes (2.0 MB)
==================================================
downloaded 2.0 MB

trying URL 'http://rspm/default/__linux__/focal/latest/src/contrib/summarytools_1.0.1.tar.gz'
Content type 'application/x-gzip' length 1421024 bytes (1.4 MB)
==================================================
downloaded 1.4 MB

* installing *binary* package ‘lobstr’ ...
* DONE (lobstr)
* installing *binary* package ‘plyr’ ...
* DONE (plyr)
* installing *binary* package ‘svglite’ ...
* DONE (svglite)
* installing *binary* package ‘checkmate’ ...
* DONE (checkmate)
* installing *binary* package ‘magick’ ...
* DONE (magick)
* installing *binary* package ‘matrixStats’ ...
* DONE (matrixStats)
* installing *binary* package ‘pander’ ...
* DONE (pander)
* installing *binary* package ‘formatR’ ...
* DONE (formatR)
* installing *binary* package ‘reshape2’ ...
* DONE (reshape2)
* installing *binary* package ‘pryr’ ...
* DONE (pryr)
* installing *binary* package ‘kableExtra’ ...
* DONE (kableExtra)
* installing *binary* package ‘rapportools’ ...
* DONE (rapportools)
* installing *binary* package ‘summarytools’ ...
* DONE (summarytools)

The downloaded source packages are in
    ‘/tmp/Rtmp23tvJ7/downloaded_packages’
Registered S3 methods overwritten by 'htmltools':
  method               from         
  print.html           tools:rstudio
  print.shiny.tag      tools:rstudio
  print.shiny.tag.list tools:rstudio
Warning: couldn't connect to display ":0"system might not have X11 capabilities; in case of errors when using dfSummary(), set st_options(use.x11 = FALSE)

Attaching package: ‘summarytools’

The following object is masked from ‘package:tibble’:

    view

Import Data

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

Codebook

dataset %>%
  select (CoinFlip, FFM_7, Potter4) -> exampleDF

print(dfSummary(exampleDF, graph.magnif = .75), method = 'render')

Warning: unable to open connection to X11 display ''

Data Frame Summary

exampleDF

Dimensions: 122 x 3
Duplicates: 101

No	Variable	Label	Stats / Values	Freqs (% of Valid)	Graph	Valid	Missing
1	CoinFlip [haven_labelled, vctrs_vctr, double]	Flip a coin. Is it heads or tails?	Min : 1 Mean : 1.3 Max : 2	1 : 83 ( 70.3% ) 2 : 35 ( 29.7% )		118 (96.7%)	4 (3.3%)
2	FFM_7 [haven_labelled, vctrs_vctr, double]	I see Myself as Someone Who..... - Is helpful and unselfish with others	Mean (sd) : 4.2 (0.8) min ≤ med ≤ max: 1 ≤ 4 ≤ 5 IQR (CV) : 1 (0.2)	1 : 1 ( 1.0% ) 2 : 2 ( 2.0% ) 3 : 8 ( 8.2% ) 4 : 52 ( 53.1% ) 5 : 35 ( 35.7% )		98 (80.3%)	24 (19.7%)
3	Potter4 [haven_labelled, vctrs_vctr, double]	Black or White?	Min : 1 Mean : 1.3 Max : 2	1 : 71 ( 71.0% ) 2 : 29 ( 29.0% )		100 (82.0%)	22 (18.0%)

Generated by summarytools 1.0.1 (R version 4.4.1)
2024-07-01