miss_scan_count should contain percentage information and default to descending order #341
Description
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 0Created on 2024-02-19 with reprex v2.1.0
Session info
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
#>
#> ──────────────────────────────────────────────────────────────────────────────