do_aggregate: Aggregate Data

In helseprofil/orgdata: Aggregating Original Data

Aggregate Data

Description

Aggregate data according to the specification in tbl_Filgruppe in AGGREGERE column. The input in argument source must be a lower granularity level than the level input.

Usage

do_aggregate(
  dt = NULL,
  source = c("grunnkrets", "fylke", "kommune", "bydel"),
  level = getOption("orgdata.geo.levels"),
  year = NULL,
  aggregate.col = NULL,
  geoDT = NULL,
  check = NULL,
  base = NULL,
  control = FALSE,
  wide = NULL
)

Arguments

dt	Input data preferrably in a data.table format but is not mandatory
source	What geographical granularity codes that is available in the source data. This will be used for merging with the geo codebook generated from geo_map() ie. from tblGeo in geo database
level	Geographical granularity for aggregating data. See getOption("orgdata.geo.levels")
year	Which year the geograhical codes to be recoded to. If it is empty then global option for orgdata.year will be used.
aggregate.col	Other columns to aggregate other than the standard ie. UTDANN, LANDSSB, LANDBAK and INNVKAT
geoDT	Geo codes to aggregate dataset with
check	If TRUE then output will keep variables for geographical levels without aggregating it. This is useful to check for geographical codes that are missing. Else use options(orgdata.aggregate = FALSE)
base	Logical value. If TRUE then use year in the original data as the base year to recode the geographical codes. Default is FALSE and use all available codes in geo codebook
control	Logical value. TRUE if the file has been controlled for possible errors
wide	Column(s) from reshape wide

See Also

Other aggregate functions: get_aggregate()

Examples

## Not run: 
# To aggregate source data with enumeration area codes ie. grunnkrets, to
# manucipaltiy ie. kommune
dt <- make_file("BEFOLKNING")
DT <- do_aggregate(dt, source = "grunnkrets", level = "kommune")

## End(Not run)

helseprofil/orgdata documentation built on Feb. 3, 2025, 4:55 p.m.