Derived Data - DD

Data - ECB

Info

Last observation: Q: 2024-Q2 (N = 23) · M: 2024-08 (N = 26) · A: 2023 (N = 148)

First observation: A: 1960 (N = 1) · Q: 1997-Q3 (N = 6) · M: 2014-12 (N = 26)

Last data update: 13 aoû 2026, 02:09. Last compile: 17 aoû 2026, 23:26

Structure

FREQ

REF_AREA

DD_ECON_CONCEPT

DD_TRANSF

DD_SUFFIX

OBS_STATUS

BOP_BASIS

COLLECTION

DECIMALS

SOURCE_AGENCY

UNIT

UNIT_MULT

Overview

freq_dominant <- DD |>
  filter(!is.na(OBS_VALUE)) |>
  count(FREQ, sort = TRUE) |>
  slice(1) |>
  pull(FREQ)

convert_fn <- switch(freq_dominant,
  "A" = year_to_date, "Q" = quarter_to_date, "M" = month_to_date,
  "H" = semester_to_date, "W" = week_to_date, "D" = day_to_date, "B" = day_to_date,
  year_to_date)

DD |>
  filter(!is.na(OBS_VALUE), FREQ == freq_dominant) |>
  group_by(TIME_PERIOD) |>
  summarise(OBS_VALUE = mean(OBS_VALUE, na.rm = TRUE), .groups = "drop") |>
  convert_fn() |>
  ggplot() + theme_minimal() + xlab("") + ylab("Average value across all series") +
  geom_line(aes(x = date, y = OBS_VALUE)) +
  scale_x_date(date_labels = "%Y")