Help to solve this error

R code
1 
pacman::p_load(
  rio,          # for importing data
  here,         # for relative file paths
  skimr,        # for reviewing the data
  janitor,      # for cleaning data  
  epikit,       # for creating age categories
  tidyverse,
  datapasta,
  reprex,styler
) 
#data
events_raw<-data.frame(
 
  EMS = c("2017-E000240","2017-E000203",
               "2021-E000145","2018-E000350","2020-E000102",
               "2023-E000309","2017-E000318","2018-E000116"),
  Grade = c("Ungraded","Ungraded",
            "Ungraded","Ungraded","Protracted 3","Grade 2","Ungraded",
            "Ungraded"),
  Status = c("Closed","Closed","Closed",
             "Closed","Closed","Closed","Closed","Closed"),
  Country = c("Algeria","Algeria","Algeria",
              "Algeria","Algeria","Algeria","Algeria","Algeria"))
  
event_clean<- events_raw %>% 
    clean_names() %>% 
    mutate(grade=na_if(Grade, " "))
#> Error in `mutate()`:
#> ℹ In argument: `grade = na_if(Grade, " ")`.
#> Caused by error:
#> ! objet 'Grade' introuvable

Created on 2024-03-06 with reprex v2.1.0

Session info

sessionInfo()
#> R version 4.3.2 (2023-10-31 ucrt)
#> Platform: x86_64-w64-mingw32/x64 (64-bit)
#> Running under: Windows 10 x64 (build 21996)
#> 
#> Matrix products: default
#> 
#> 
#> locale:
#> [1] LC_COLLATE=French_France.utf8  LC_CTYPE=French_France.utf8   
#> [3] LC_MONETARY=French_France.utf8 LC_NUMERIC=C                  
#> [5] LC_TIME=French_France.utf8    
#> 
#> time zone: Atlantic/Reykjavik
#> tzcode source: internal
#> 
#> attached base packages:
#> [1] stats     graphics  grDevices utils     datasets  methods   base     
#> 
#> other attached packages:
#>  [1] styler_1.10.2   reprex_2.1.0    datapasta_3.1.0 lubridate_1.9.3
#>  [5] forcats_1.0.0   stringr_1.5.1   dplyr_1.1.4     purrr_1.0.2    
#>  [9] readr_2.1.5     tidyr_1.3.1     tibble_3.2.1    ggplot2_3.4.4  
#> [13] tidyverse_2.0.0 epikit_0.1.6    janitor_2.2.0   skimr_2.1.5    
#> [17] here_1.0.1      rio_1.0.1      
#> 
#> loaded via a namespace (and not attached):
#>  [1] utf8_1.2.4         generics_0.1.3     class_7.3-22       KernSmooth_2.23-22
#>  [5] stringi_1.8.3      hms_1.1.3          digest_0.6.34      magrittr_2.0.3    
#>  [9] evaluate_0.23      grid_4.3.2         timechange_0.3.0   fastmap_1.1.1     
#> [13] R.oo_1.26.0        R.cache_0.16.0     rprojroot_2.0.4    jsonlite_1.8.8    
#> [17] R.utils_2.12.3     e1071_1.7-14       DBI_1.2.1          fansi_1.0.6       
#> [21] scales_1.3.0       cli_3.6.2          rlang_1.1.3        units_0.8-5       
#> [25] R.methodsS3_1.8.2  munsell_0.5.0      base64enc_0.1-3    withr_3.0.0       
#> [29] repr_1.1.6         yaml_2.3.8         tools_4.3.2        tzdb_0.4.0        
#> [33] colorspace_2.1-0   pacman_0.5.1       vctrs_0.6.5        R6_2.5.1          
#> [37] proxy_0.4-27       classInt_0.4-10    lifecycle_1.0.4    snakecase_0.11.1  
#> [41] fs_1.6.3           pkgconfig_2.0.3    pillar_1.9.0       gtable_0.3.4      
#> [45] Rcpp_1.0.12        glue_1.7.0         sf_1.0-15          xfun_0.41         
#> [49] tidyselect_1.2.0   rstudioapi_0.15.0  knitr_1.45         htmltools_0.5.7   
#> [53] rmarkdown_2.25     compiler_4.3.2

Can you help me with that error?

1 Like
2

Hello,

Can you describe what you are attempting to do with this code? I don’t see any records in your data with values of " " for the variable Grade. Are you hoping to convert empty values of Grade to NA? If so, I would do something like this:

# loading packages
library(tidyverse)
library(janitor)
#> 
#> Attaching package: 'janitor'
#> The following objects are masked from 'package:stats':
#> 
#>     chisq.test, fisher.test

# creating fake data
events_raw <- data.frame(
  EMS = c(
    "2017-E000240", "2017-E000203",
    "2021-E000145", "2018-E000350", "2020-E000102",
    "2023-E000309", "2017-E000318", "2018-E000116"
  ),
  Grade = c(
    "Ungraded", " ",
    "Ungraded", "Ungraded", "Protracted 3", "Grade 2", "Ungraded",
    " "
  ),
  Status = c(
    "Closed", "Closed", "Closed",
    "Closed", "Closed", "Closed", "Closed", "Closed"
  ),
  Country = c(
    "Algeria", "Algeria", "Algeria",
    "Algeria", "Algeria", "Algeria", "Algeria", "Algeria"
  )
)

# converting empty string to NA
events_raw |>
    clean_names() |>
    mutate(grade = if_else(grade == " ", NA_character_, grade))
#>            ems        grade status country
#> 1 2017-E000240     Ungraded Closed Algeria
#> 2 2017-E000203         <NA> Closed Algeria
#> 3 2021-E000145     Ungraded Closed Algeria
#> 4 2018-E000350     Ungraded Closed Algeria
#> 5 2020-E000102 Protracted 3 Closed Algeria
#> 6 2023-E000309      Grade 2 Closed Algeria
#> 7 2017-E000318     Ungraded Closed Algeria
#> 8 2018-E000116         <NA> Closed Algeria

Created on 2024-03-06 with reprex v2.1.0

Session info 
sessioninfo::session_info()
#> ─ Session info ───────────────────────────────────────────────────────────────
#>  setting  value
#>  version  R version 4.3.1 (2023-06-16)
#>  os       macOS Ventura 13.6.3
#>  system   x86_64, darwin20
#>  ui       X11
#>  language (EN)
#>  collate  en_US.UTF-8
#>  ctype    en_US.UTF-8
#>  tz       America/Toronto
#>  date     2024-03-06
#>  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.0)
#>  colorspace    2.1-0   2023-01-23 [1] CRAN (R 4.3.0)
#>  digest        0.6.34  2024-01-11 [1] RSPM (R 4.3.0)
#>  dplyr       * 1.1.4   2023-11-17 [1] CRAN (R 4.3.0)
#>  evaluate      0.23    2023-11-01 [1] CRAN (R 4.3.0)
#>  fansi         1.0.6   2023-12-08 [1] CRAN (R 4.3.0)
#>  fastmap       1.1.1   2023-02-24 [1] CRAN (R 4.3.0)
#>  forcats     * 1.0.0   2023-01-29 [1] CRAN (R 4.3.0)
#>  fs            1.6.3   2023-07-20 [1] CRAN (R 4.3.0)
#>  generics      0.1.3   2022-07-05 [1] CRAN (R 4.3.0)
#>  ggplot2     * 3.5.0   2024-02-23 [1] RSPM (R 4.3.0)
#>  glue          1.7.0   2024-01-09 [1] RSPM (R 4.3.0)
#>  gtable        0.3.4   2023-08-21 [1] CRAN (R 4.3.0)
#>  hms           1.1.3   2023-03-21 [1] CRAN (R 4.3.0)
#>  htmltools     0.5.7   2023-11-03 [1] CRAN (R 4.3.0)
#>  janitor     * 2.2.0   2023-02-02 [1] CRAN (R 4.3.0)
#>  knitr         1.45    2023-10-30 [1] CRAN (R 4.3.0)
#>  lifecycle     1.0.4   2023-11-07 [1] CRAN (R 4.3.0)
#>  lubridate   * 1.9.3   2023-09-27 [1] CRAN (R 4.3.0)
#>  magrittr      2.0.3   2022-03-30 [1] CRAN (R 4.3.0)
#>  munsell       0.5.0   2018-06-12 [1] CRAN (R 4.3.0)
#>  pillar        1.9.0   2023-03-22 [1] CRAN (R 4.3.0)
#>  pkgconfig     2.0.3   2019-09-22 [1] CRAN (R 4.3.0)
#>  purrr       * 1.0.2   2023-08-10 [1] CRAN (R 4.3.0)
#>  R.cache       0.16.0  2022-07-21 [1] CRAN (R 4.3.0)
#>  R.methodsS3   1.8.2   2022-06-13 [1] CRAN (R 4.3.0)
#>  R.oo          1.26.0  2024-01-24 [1] RSPM (R 4.3.0)
#>  R.utils       2.12.3  2023-11-18 [1] CRAN (R 4.3.0)
#>  R6            2.5.1   2021-08-19 [1] CRAN (R 4.3.0)
#>  readr       * 2.1.5   2024-01-10 [1] RSPM (R 4.3.0)
#>  reprex        2.1.0   2024-01-11 [1] RSPM (R 4.3.0)
#>  rlang         1.1.3   2024-01-10 [1] RSPM (R 4.3.0)
#>  rmarkdown     2.25    2023-09-18 [1] CRAN (R 4.3.0)
#>  rstudioapi    0.15.0  2023-07-07 [1] CRAN (R 4.3.0)
#>  scales        1.3.0   2023-11-28 [1] CRAN (R 4.3.0)
#>  sessioninfo   1.2.2   2021-12-06 [1] CRAN (R 4.3.0)
#>  snakecase     0.11.1  2023-08-27 [1] CRAN (R 4.3.0)
#>  stringi       1.8.3   2023-12-11 [1] CRAN (R 4.3.0)
#>  stringr     * 1.5.1   2023-11-14 [1] CRAN (R 4.3.0)
#>  styler        1.10.2  2023-08-29 [1] CRAN (R 4.3.0)
#>  tibble      * 3.2.1   2023-03-20 [1] CRAN (R 4.3.0)
#>  tidyr       * 1.3.1   2024-01-24 [1] RSPM (R 4.3.0)
#>  tidyselect    1.2.0   2022-10-10 [1] CRAN (R 4.3.0)
#>  tidyverse   * 2.0.0   2023-02-22 [1] CRAN (R 4.3.0)
#>  timechange    0.3.0   2024-01-18 [1] RSPM (R 4.3.0)
#>  tzdb          0.4.0   2023-05-12 [1] CRAN (R 4.3.0)
#>  utf8          1.2.4   2023-10-22 [1] CRAN (R 4.3.0)
#>  vctrs         0.6.5   2023-12-01 [1] CRAN (R 4.3.0)
#>  withr         3.0.0   2024-01-16 [1] RSPM (R 4.3.0)
#>  xfun          0.42    2024-02-08 [1] RSPM (R 4.3.0)
#>  yaml          2.3.8   2023-12-11 [1] CRAN (R 4.3.0)
#> 
#>  [1] /Users/timothychisamore/Library/R/x86_64/4.3/library
#>  [2] /Library/Frameworks/R.framework/Versions/4.3-x86_64/Resources/library
#> 
#> ──────────────────────────────────────────────────────────────────────────────

All the best,

Tim