Last observation: Q: 2024-Q3 (N = 3) · M: 2024-12 (N = 1)
First observation: M: 1980-01 (N = 1) · Q: 1996-Q1 (N = 1)
Last data update: 01 aoû 2026, 21:42. Last compile: 17 aoû 2026, 23:51
Housing, Water, Electricity, Gas and Other Fuels, Weight, Percent - PCPIH_WT_PT
Data - IMF
Info
FREQ
Code
PCPIH_WT_PT |>
left_join(FREQ, by = "FREQ") |>
group_by(FREQ, Freq) |>
summarise(Nobs = n()) |>
arrange(-Nobs) |>
print_table_conditional()| FREQ | Freq | Nobs |
|---|---|---|
| M | Monthly | 36297 |
| Q | Quarterly | 578 |
REF_AREA
All
Code
PCPIH_WT_PT |>
left_join(REF_AREA, by = "REF_AREA") |>
group_by(REF_AREA, Ref_area, FREQ) |>
summarise(Nobs = n()) |>
arrange(-Nobs) |>
mutate(Flag = gsub(" ", "-", str_to_lower(gsub(" ", "-", Ref_area))),
Flag = paste0('<img src="../../icon/flag/vsmall/', Flag, '.png" alt="Flag">')) |>
select(Flag, everything()) %>%
{if (is_html_output()) datatable(., filter = 'top', rownames = F, escape = F) else .}Monthly
Code
PCPIH_WT_PT |>
filter(FREQ == "M") |>
left_join(REF_AREA, by = "REF_AREA") |>
group_by(REF_AREA, Ref_area, FREQ) |>
summarise(Nobs = n()) |>
arrange(-Nobs) |>
mutate(Flag = gsub(" ", "-", str_to_lower(gsub(" ", "-", Ref_area))),
Flag = paste0('<img src="../../icon/flag/vsmall/', Flag, '.png" alt="Flag">')) |>
select(Flag, everything()) %>%
{if (is_html_output()) datatable(., filter = 'top', rownames = F, escape = F) else .}Quarterly
Code
PCPIH_WT_PT |>
filter(FREQ == "Q") |>
left_join(REF_AREA, by = "REF_AREA") |>
group_by(REF_AREA, Ref_area, FREQ) |>
summarise(Nobs = n()) |>
arrange(-Nobs) |>
mutate(Flag = gsub(" ", "-", str_to_lower(gsub(" ", "-", Ref_area))),
Flag = paste0('<img src="../../icon/flag/vsmall/', Flag, '.png" alt="Flag">')) |>
select(Flag, everything()) %>%
{if (is_html_output()) datatable(., filter = 'top', rownames = F, escape = F) else .}TIME_PERIOD
Code
PCPIH_WT_PT |>
group_by(TIME_PERIOD) |>
summarise(Nobs = n()) |>
print_table_conditional()2020
Javascript
Code
PCPIH_WT_PT |>
filter(FREQ == "M",
TIME_PERIOD %in% c("2020-01")) |>
mutate(TIME_PERIOD = substr(TIME_PERIOD, 1, 4) |> as.numeric()) |>
left_join(REF_AREA, by = "REF_AREA") |>
select(REF_AREA, Ref_area, TIME_PERIOD, OBS_VALUE) |>
mutate(OBS_VALUE = round(OBS_VALUE, 1)) |>
spread(TIME_PERIOD, OBS_VALUE) |>
arrange(-`2020`) |>
mutate(Flag = gsub(" ", "-", str_to_lower(gsub(" ", "-", Ref_area))),
Flag = paste0('<img src="../../icon/flag/vsmall/', Flag, '.png" alt="Flag">')) |>
select(Flag, everything()) %>%
{if (is_html_output()) datatable(., filter = 'top', rownames = F, escape = F) else .}png
Code
i_g("bib/imf/PCPIH_WT_PT_ex1.png")
January 2020, 2015, 2010
Monthly
Code
PCPIH_WT_PT |>
filter(FREQ == "M",
TIME_PERIOD %in% c("2020-01", "2015-01", "2010-01", "2005-01", "2000-01")) |>
mutate(TIME_PERIOD = substr(TIME_PERIOD, 1, 4) |> as.numeric()) |>
left_join(REF_AREA, by = "REF_AREA") |>
select(REF_AREA, Ref_area, TIME_PERIOD, OBS_VALUE) |>
mutate(OBS_VALUE = round(OBS_VALUE, 1)) |>
spread(TIME_PERIOD, OBS_VALUE) |>
arrange(-`2020`) |>
mutate(Flag = gsub(" ", "-", str_to_lower(gsub(" ", "-", Ref_area))),
Flag = paste0('<img src="../../icon/flag/vsmall/', Flag, '.png" alt="Flag">')) |>
select(Flag, everything()) %>%
{if (is_html_output()) datatable(., filter = 'top', rownames = F, escape = F) else .}Quarterly
Code
PCPIH_WT_PT |>
filter(FREQ == "Q",
TIME_PERIOD %in% c("2020-Q1", "2015-Q1", "2010-Q1")) |>
left_join(REF_AREA, by = "REF_AREA") |>
select(REF_AREA, Ref_area, TIME_PERIOD, OBS_VALUE) |>
mutate(OBS_VALUE = round(OBS_VALUE, 1)) |>
spread(TIME_PERIOD, OBS_VALUE) |>
arrange(-`2020-Q1`) |>
mutate(Flag = gsub(" ", "-", str_to_lower(gsub(" ", "-", Ref_area))),
Flag = paste0('<img src="../../icon/flag/vsmall/', Flag, '.png" alt="Flag">')) |>
select(Flag, everything()) %>%
{if (is_html_output()) datatable(., filter = 'top', rownames = F, escape = F) else .}3 Countries
France, Germany, UK
Code
PCPIH_WT_PT |>
filter(REF_AREA %in% c("GB", "FR", "DE"),
FREQ == "M") |>
month_to_date2() |>
left_join(REF_AREA, by = "REF_AREA") |>
filter(!is.na(OBS_VALUE)) |>
mutate(OBS_VALUE = OBS_VALUE/100) |>
left_join(colors, by = c("Ref_area" = "country")) |>
ggplot() + scale_color_identity() + add_flags + theme_minimal() + xlab("") + ylab("Housing (weights)") +
geom_line(aes(x = date, y = OBS_VALUE, color = color)) +
scale_x_date(breaks = seq(1950, 2100, 5) |> paste0("-01-01") |> as.Date(),
labels = date_format("%Y")) +
scale_y_continuous(breaks = 0.01*seq(0, 2000, 5),
labels = percent_format(accuracy = 1)) +
theme(legend.position = c(0.2, 0.80),
legend.title = element_blank())
Italy, Spain, Greece
Code
PCPIH_WT_PT |>
filter(REF_AREA %in% c("IT", "ES", "GR"),
FREQ == "M") |>
month_to_date2() |>
left_join(REF_AREA, by = "REF_AREA") |>
filter(!is.na(OBS_VALUE)) |>
mutate(OBS_VALUE = OBS_VALUE/100) |>
left_join(colors, by = c("Ref_area" = "country")) |>
ggplot() + scale_color_identity() + add_flags + theme_minimal() + xlab("") + ylab("Housing (weights)") +
geom_line(aes(x = date, y = OBS_VALUE, color = color)) +
scale_x_date(breaks = seq(1950, 2100, 5) |> paste0("-01-01") |> as.Date(),
labels = date_format("%Y")) +
scale_y_continuous(breaks = 0.01*seq(0, 100, 1),
labels = percent_format(accuracy = 1)) +
theme(legend.position = c(0.2, 0.80),
legend.title = element_blank())
Japan, Norway, Portugal
Code
PCPIH_WT_PT |>
filter(REF_AREA %in% c("PT", "JP", "NO"),
FREQ == "M") |>
month_to_date2() |>
left_join(REF_AREA, by = "REF_AREA") |>
filter(!is.na(OBS_VALUE)) |>
mutate(OBS_VALUE = OBS_VALUE/100) |>
left_join(colors, by = c("Ref_area" = "country")) |>
ggplot() + scale_color_identity() + add_flags + theme_minimal() + xlab("") + ylab("Housing (weights)") +
geom_line(aes(x = date, y = OBS_VALUE, color = color)) +
scale_x_date(breaks = seq(1950, 2100, 5) |> paste0("-01-01") |> as.Date(),
labels = date_format("%Y")) +
scale_y_continuous(breaks = 0.01*seq(0, 2000, 5),
labels = percent_format(accuracy = 1)) +
theme(legend.position = c(0.2, 0.80),
legend.title = element_blank())