getData: Extract summarised data

In tabshiftr: Reshape Disorganised Messy Data

Extract summarised data

Description

This function extracts data from a table that are summarised by applying a schema description to it.

Usage

getData(schema = NULL, input = NULL)

Arguments

schema	[character(1)] the (validated) schema description of input.
input	[character(1)] table to reorganise.

Value

a table where columns and rows are summarised

Examples

input <- tabs2shift$clusters_nested
schema <- setCluster(id = "sublevel",
                     group = "territories", member = c(1, 1, 2),
                     left = 1, top = c(3, 8, 15)) %>%
  setIDVar(name = "territories", columns = 1, rows = c(2, 14)) %>%
  setIDVar(name = "sublevel", columns = 1, rows = c(3, 8, 15)) %>%
  setIDVar(name = "year", columns = 7) %>%
  setIDVar(name = "commodities", columns = 2) %>%
  setObsVar(name = "harvested", columns = 5) %>%
  setObsVar(name = "production", columns = 6)

validateSchema(schema = schema, input = input) %>%
   getData(input = input)

tabshiftr documentation built on Feb. 16, 2023, 10:24 p.m.