Open njtierney opened 5 months ago
library(naniar) dat_ms <- tibble::tribble(~x, ~y, ~z, ~specials, 1, "A", -100, "?", 3, "N/A", -99, "!", NA, NA, -98, ".", -99, "E", -101, "*", -98, "F", -1, "-") miss_scan_count( dat_ms, -99 ) #> # A tibble: 4 × 2 #> Variable n #> <chr> <int> #> 1 x 1 #> 2 y 0 #> 3 z 1 #> 4 specials 0 # should also by default sort descending order # and add percentage library(dplyr) #> #> Attaching package: 'dplyr' #> The following objects are masked from 'package:stats': #> #> filter, lag #> The following objects are masked from 'package:base': #> #> intersect, setdiff, setequal, union miss_scan_count( dat_ms, -99 ) %>% arrange(-n) %>% mutate(pct = (n / nrow(dat_ms) * 100)) #> # A tibble: 4 × 3 #> Variable n pct #> <chr> <int> <dbl> #> 1 x 1 20 #> 2 z 1 20 #> 3 y 0 0 #> 4 specials 0 0
Created on 2024-02-19 with reprex v2.1.0
Created on 2024-02-19 with reprex v2.1.0
Session info
``` r sessioninfo::session_info() #> ─ Session info ─────────────────────────────────────────────────────────────── #> setting value #> version R version 4.3.2 (2023-10-31) #> os macOS Sonoma 14.3.1 #> system aarch64, darwin20 #> ui X11 #> language (EN) #> collate en_US.UTF-8 #> ctype en_US.UTF-8 #> tz Australia/Hobart #> date 2024-02-19 #> pandoc 3.1.1 @ /Applications/RStudio.app/Contents/Resources/app/quarto/bin/tools/ (via rmarkdown) #> #> ─ Packages ─────────────────────────────────────────────────────────────────── #> package * version date (UTC) lib source #> cli 3.6.2 2023-12-11 [1] CRAN (R 4.3.1) #> colorspace 2.1-0 2023-01-23 [2] CRAN (R 4.3.0) #> digest 0.6.34 2024-01-11 [2] CRAN (R 4.3.1) #> dplyr * 1.1.4 2023-11-17 [2] CRAN (R 4.3.1) #> evaluate 0.23 2023-11-01 [2] CRAN (R 4.3.1) #> fansi 1.0.6 2023-12-08 [2] CRAN (R 4.3.1) #> fastmap 1.1.1 2023-02-24 [1] CRAN (R 4.3.0) #> fs 1.6.3 2023-07-20 [2] CRAN (R 4.3.0) #> generics 0.1.3 2022-07-05 [2] CRAN (R 4.3.0) #> ggplot2 3.4.4 2023-10-12 [2] CRAN (R 4.3.1) #> glue 1.7.0 2024-01-09 [1] CRAN (R 4.3.1) #> gtable 0.3.4 2023-08-21 [2] CRAN (R 4.3.0) #> htmltools 0.5.7 2023-11-03 [2] CRAN (R 4.3.1) #> knitr 1.45 2023-10-30 [2] CRAN (R 4.3.1) #> lifecycle 1.0.4 2023-11-07 [1] CRAN (R 4.3.1) #> magrittr 2.0.3 2022-03-30 [1] CRAN (R 4.3.0) #> munsell 0.5.0 2018-06-12 [2] CRAN (R 4.3.0) #> naniar * 1.0.0.9000 2024-01-12 [2] local #> pillar 1.9.0 2023-03-22 [2] CRAN (R 4.3.0) #> pkgconfig 2.0.3 2019-09-22 [2] CRAN (R 4.3.0) #> purrr 1.0.2 2023-08-10 [2] CRAN (R 4.3.0) #> R.cache 0.16.0 2022-07-21 [2] CRAN (R 4.3.0) #> R.methodsS3 1.8.2 2022-06-13 [2] CRAN (R 4.3.0) #> R.oo 1.26.0 2024-01-24 [2] CRAN (R 4.3.1) #> R.utils 2.12.3 2023-11-18 [2] CRAN (R 4.3.1) #> R6 2.5.1 2021-08-19 [1] CRAN (R 4.3.0) #> reprex 2.1.0 2024-01-11 [2] CRAN (R 4.3.1) #> rlang 1.1.3 2024-01-10 [1] CRAN (R 4.3.1) #> rmarkdown 2.25 2023-09-18 [2] CRAN (R 4.3.1) #> rstudioapi 0.15.0 2023-07-07 [1] CRAN (R 4.3.0) #> scales 1.3.0 2023-11-28 [2] CRAN (R 4.3.1) #> sessioninfo 1.2.2 2021-12-06 [2] CRAN (R 4.3.0) #> styler 1.10.2 2023-08-29 [2] CRAN (R 4.3.0) #> tibble 3.2.1 2023-03-20 [2] CRAN (R 4.3.0) #> tidyr 1.3.1 2024-01-24 [2] CRAN (R 4.3.1) #> tidyselect 1.2.0 2022-10-10 [2] CRAN (R 4.3.0) #> utf8 1.2.4 2023-10-22 [2] CRAN (R 4.3.1) #> vctrs 0.6.5 2023-12-01 [1] CRAN (R 4.3.1) #> visdat 0.6.0 2023-02-02 [2] CRAN (R 4.3.0) #> withr 3.0.0 2024-01-16 [1] CRAN (R 4.3.1) #> xfun 0.42 2024-02-08 [2] CRAN (R 4.3.1) #> yaml 2.3.8 2023-12-11 [2] CRAN (R 4.3.1) #> #> [1] /Users/nick/Library/R/arm64/4.3/library #> [2] /Library/Frameworks/R.framework/Versions/4.3-arm64/Resources/library #> #> ────────────────────────────────────────────────────────────────────────────── ```