README.md

statswalesr

CRAN
status AppVeyor build
status Travis build
status

statswalesr is a package for downloading datasets and their associated metadata from StatsWales. This functionality is limited to datasets that are available through the OData feed. You can check this by navigating to your desired dataset, scrolling to the bottom, and checking that the “Dataset” link is available under the Open Data tab.

Installation

statswalesr is now on CRAN. To install:

install.packages("statswalesr")

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

# install.packages("devtools")
devtools::install_github("jamie-ralph/statswalesr")

Example

The code below extracts data about aircraft movement at Cardiff airport and the associated metadata.

library(statswalesr)

metadata <- statswalesr::statswales_get_metadata("tran0003")

df <- statswalesr::statswales_get_dataset("tran0003")
str(df)
## 'data.frame':    182 obs. of  10 variables:
##  $ Data                      : chr  "0" "0" "0" "0" ...
##  $ MovementType_Code         : chr  "29" "29" "29" "29" ...
##  $ MovementType_ItemName_ENG : chr  "Business Aviation" "Business Aviation" "Business Aviation" "Business Aviation" ...
##  $ MovementType_SortOrder    : chr  "29" "29" "29" "29" ...
##  $ MovementType_Hierarchy    : chr  "11" "11" "11" "11" ...
##  $ MovementType_ItemNotes_ENG: chr  "" "" "" "" ...
##  $ Year_Code                 : chr  "2015" "2010" "2011" "2016" ...
##  $ Year_ItemName_ENG         : chr  "2015" "2010" "2011" "2016" ...
##  $ Year_SortOrder            : chr  "26" "21" "22" "27" ...
##  $ PartitionKey              : chr  "0" "0" "0" "0" ...

You can also search for datasets based on key terms. For example, if I wanted data on farming or agriculture I could do the following:

library(dplyr)

farming_datasets <- statswales_search(c("farm*", "agri*"))
glimpse(farming_datasets)
## Rows: 29
## Columns: 2
## $ Description_ENG <chr> "Children's services: Welfare/health summary", "Chi...
## $ Dataset         <chr> "care0021", "care0022", "agri0200", "agri0201", "ag...


Try the statswalesr package in your browser

Any scripts or data that you put into this service are public.

statswalesr documentation built on July 14, 2021, 5:09 p.m.