NY.GDP.PETR.RT.ZS |>
left_join(iso2c, by = "iso2c") |>
group_by(iso2c, Iso2c) |>
mutate(value = round(value, 2)) |>
summarise(Nobs = n(),
`Year 1` = first(year),
`Rent 1 (%)` = first(value),
`Year 2` = last(year),
`Rent 2 (%)` = last(value)) |>
arrange(-`Rent 2 (%)`) |>
mutate(Flag = gsub(" ", "-", str_to_lower(gsub(" ", "-", Iso2c))),
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 .}