The goal of the package portawaterperu is to provide access to data about community portable water systems in Peru. The data is collected from SIASAR database consisted of information and surveys about water catchments, storage system, treatment, distribution networks and maintainance.

You can install the development version of portawaterperu from GitHub with:

# install.packages("devtools")
devtools::install_github("openwashdata/portawaterperu")

## Run the following code in console if you don't have the packages
## install.packages(c("dplyr", "knitr", "readr", "stringr", "gt", "kableExtra"))
library(dplyr)
library(knitr)
library(readr)
library(stringr)
library(gt)
library(kableExtra)

Alternatively, you can download the individual datasets as a CSV or XLSX file from the table below.

The package provides access to one dataset portawaterperu.

library(portawaterperu)

The dataset portawaterperu contains data abour portable water system from 32 communities in Peru. It has 32 observations and 51 variables

portawaterperu |> 
  head(3) |> 
  gt::gt() |>
  gt::as_raw_html()

For an overview of the variable names, see the following table.

library(portawaterperu)
library(ggplot2)
# Provide some example code here
portawaterperu |> 
  #dplyr::filter(stringr::str_starts(divisiones, "AMAZONAS")) |>
  #dplyr::group_by(divisiones) |> 
  #dplyr::summarise(mean = mean(pob_servida)) |> 
  ggplot(aes(y = pop_serviced, color = type_gravity))+
  geom_boxplot(outliers = F)+
  labs(title = "Population served given different gravity types",
       y= "Population") +
  theme_classic()

This dataset is shared as part of a capstone project in Data Science for openwashdata. For more information about the project and to explore further insights, please visit the project page at https://ds4owd-001.github.io/project-laurenjudah/ (to be public available)

The data was obtained from @SIASAR, an information system containing data on rural water supply and sanitation services. Using SIASAR’s “download data by country” tool, all available data for Peru (10 excel files) were downloaded. After examining the 10 excel files, only 5 pertained to potable water systems. Those 5 data sets were imported into R and subsequently empty values and unnecessary columns were deleted from them. Finally, the 5 data sets were combined into 1 data frame based on community ID. The combined, cleaned data set contains data from 32 communities.

SIASAR does not provide a matching data dictionary. openwashdata developer went through the attachements of the original questionnaire:

• https://globalsiasar.org/es/content/documentacion-tecnica
• https://globalsiasar.org/en/content/technical-documentation

The variable description is written with our best guess with the information from the attachements.

Data are available as CC-BY.

Please cite this package using:

citation("portawaterperu")
#> To cite package 'portawaterperu' in publications use:
#> 
#>   Judah L, Loos S, Zhong M (2024). _portawaterperu: A Preliminary
#>   Review of Peruvian Potable Water System Data_. R package version
#>   0.0.1, <https://github.com/openwashdata/portawaterperu>.
#> 
#> A BibTeX entry for LaTeX users is
#> 
#>   @Manual{,
#>     title = {portawaterperu: A Preliminary Review of Peruvian Potable Water System Data},
#>     author = {Lauren Judah and Sebastian Camilo Loos and Mian Zhong},
#>     year = {2024},
#>     note = {R package version 0.0.1},
#>     url = {https://github.com/openwashdata/portawaterperu},
#>   }