R dashboard of metrics from the Illinois Data Bank data repository
This R Markdown file produces an html dashboard of various metrics related to the data publications in the Illinois Data Bank. It takes several csv files as input. These are generated by the repository platform.
File Manifest: input [folder] datafiles.csv - data file metrics (info about individual files) dataset_downloads_FY[##].csv - download count per dataset per year datasets.csv - dataset metrics (info about each dataset as a whole) file-statistics.csv - file format summary statistics RepoDash.Rmd - R code in markdown format that produces the dashboard RepoDash.html - dashboard exported from R
Datafiles.csv column headings: Column Headings doi: DOI that identifies the dataset this file is part of; pub_date: Date this file was first made available for download; filename: Name of the file, with extension; file_format: Mime type; num_bytes: Size of this files, in bytes; total_downloads: Number of downloads for this file.
dataset_downloads_FY[##].csv column headings: dataset_key: Illinois Data Bank ID; doi: DOI that identifies this dataset; download_date: Date of download(s); tally: Total number of downloads for that dataset for that date deduplicated by IP.
Datasets.csv column headings: doi: DOI that identifies this dataset; ingest_date: Date dataset was deposited; release_date: Date the files in this dataset were first available for download; num_files: Total number of datafiles in this dataset; num_bytes: Combined total size for all files in this dataset, in bytes; total_downloads: Number of downloads for this dataset; num_relationships: Number of related materials, excluding other versions of this dataset; num_creators: Number of dataset authors/creators; subject: Subject Area of this dataset.
file-statistics.csv column headings: mime: File mime type; num: Number of files with this mime type; num_bytes: Combined total size for all files of this type, in bytes.
Notes on reuse: The dashboard could be adapted for use by other repositories provided the metrics files are used as templates. Note that the number of subjects should be small. If there are more than 5, the color palettes will need to be expanded. More than 10 probably won't display well.
R version info: R version 4.4.2 (2024-10-31 ucrt) Platform: x86_64-w64-mingw32/x64 Running under: Windows 11 x64 (build 22631)
Matrix products: default
locale:
[1] LC_COLLATE=English_United States.utf8
[2] LC_CTYPE=English_United States.utf8
[3] LC_MONETARY=English_United States.utf8
[4] LC_NUMERIC=C
[5] LC_TIME=English_United States.utf8
time zone: America/Chicago tzcode source: internal
attached base packages: [1] stats graphics grDevices utils datasets methods base
other attached packages:
[1] kableExtra_1.4.1 scales_1.3.0 flexdashboard_0.6.2
[4] lubridate_1.9.4 forcats_1.0.0 stringr_1.5.1
[7] dplyr_1.1.4 purrr_1.0.4 readr_2.1.5
[10] tidyr_1.3.1 tibble_3.2.1 ggplot2_3.5.1
[13] tidyverse_2.0.0
loaded via a namespace (and not attached):
[1] sass_0.4.9 generics_0.1.3 xml2_1.3.6 stringi_1.8.4
[5] hms_1.1.3 digest_0.6.37 magrittr_2.0.3 evaluate_1.0.3
[9] grid_4.4.2 timechange_0.3.0 fastmap_1.2.0 jsonlite_1.9.0
[13] viridisLite_0.4.2 textshaping_1.0.0 jquerylib_0.1.4 cli_3.6.4
[17] crayon_1.5.3 rlang_1.1.5 bit64_4.6.0-1 munsell_0.5.1
[21] withr_3.0.2 cachem_1.1.0 yaml_2.3.10 parallel_4.4.2
[25] tools_4.4.2 tzdb_0.4.0 colorspace_2.1-1 vctrs_0.6.5
[29] R6_2.6.1 lifecycle_1.0.4 bit_4.5.0.1 vroom_1.6.5
[33] fontawesome_0.5.3 pkgconfig_2.0.3 pillar_1.10.1 bslib_0.9.0
[37] gtable_0.3.6 glue_1.8.0 systemfonts_1.3.2 xfun_0.51
[41] tidyselect_1.2.1 rstudioapi_0.17.1 knitr_1.49 farver_2.1.2
[45] htmltools_0.5.8.1 labeling_0.4.3 rmarkdown_2.29 svglite_2.2.2
[49] compiler_4.4.2