Code
load_data("oecd/QASA_7II_var.RData")
QASA_7II <- read_parquet("QASA_7II.parquet")load_data("oecd/QASA_7II_var.RData")
QASA_7II <- read_parquet("QASA_7II.parquet")
QASA_7II |>
left_join(QASA_7II_var |> pluck("TRANSACTION"), by = c("TRANSACTION" = "id")) |>
rename(`TRANSACTION Description` = label) |>
left_join(QASA_7II_var |> pluck("SECTOR"), by = c("SECTOR" = "id")) |>
rename(`SECTOR Description` = label) |>
group_by(TRANSACTION, `TRANSACTION Description`, SECTOR, `SECTOR Description`, MEASURE) |>
summarise(Nobs = n()) |>
arrange(-Nobs) %>%
{if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}QASA_7II_var$VAR_DESC %>%
{if (is_html_output()) print_table(.) else .}| id | description |
|---|---|
| LOCATION | Country |
| TRANSACTION | Transaction |
| SECTOR | Sector |
| MEASURE | Measure |
| ADJUSTMENT | Adjustment |
| TIME | Period & Frequency |
| OBS_VALUE | Observation Value |
| TIME_FORMAT | Time Format |
| OBS_STATUS | Observation Status |
| UNIT | Unit |
| POWERCODE | Unit multiplier |
| REFERENCEPERIOD | Reference period |