cleanR is data cleaning tool designed to simplify and enhance WFP data cleaning process. it enables users to load raw data and perform essential data quality checks including survey time completion, identification of missing data points, handling of non-standard responses, detection of outliers, pinpointing inconsistencies and validation of GPS coordinates. the package adopts variable naming standards from the WFP Survey Designer for consistency and compatibility. at the end, users can efficiently prepare their data for analysis. ensuring accuracy and reliability.

You can install the development version of cleanR from GitHub:

# install.packages("devtools")
remotes::install_github("axmedmaxamuud/cleanR")

This is a basic example of creating a blank logbook that you can use it later to save the observation with issues.

library(cleanR)

# create the logbook
my_logbook <- logbook()

# inspect the head of the logbook
head(my_logbook)
#> [1] uuid          question.name issue         feedback      action       
#> [6] old.value     new.value    
#> <0 rows> (or 0-length row.names)

Now you can inspect the data and use the log_issue() to write the observations of the data that you find with the issues in the logbook.

check_age <- survey_data %>% 
  filter(RESPAge < 15) %>% 
  log_sheet(question.name = "ki_age",
            issue = "respondent is under 15 years old",
            action = "delete")
# inspect the check_age data
head(check_age)
#> [1] uuid          question.name issue         feedback      action       
#> [6] old.value     new.value    
#> <0 rows> (or 0-length row.names)

now you can merge the check_age data with the logbook so you can maintain one logbook that can be exported at the end.

my_logbook <- rbind(my_logbook, check_age)

head(my_logbook)
#> [1] uuid          question.name issue         feedback      action       
#> [6] old.value     new.value    
#> <0 rows> (or 0-length row.names)

we welcome your feedback and contributions to make cleanR even more interactive and robust. feel free to report issues or contribute to the project by making pull request.

This work draws inspiration from the HighFrequencyChecks, IMPACT cleaninginspectoR and WFP DataBreiges. by building on the foundation laid by these packages, cleanR seeks to streamline the process and make it relevant to WFP programming.