NE.GDI.TOTL.ZS %>%
left_join(iso2c, by = "iso2c") %>%
group_by(iso2c, Iso2c) %>%
mutate(value = round(value, 2)) %>%
summarise(Nobs = n(),
`Year 1` = first(year),
`Investment 1 (%)` = first(value),
`Year 2` = last(year),
`Investment 2 (%)` = last(value)) %>%
arrange(-Nobs) %>%
mutate(Flag = gsub(" ", "-", str_to_lower(Iso2c)),
Flag = paste0('<img src="../../bib/flags/vsmall/', Flag, '.png" alt="Flag">')) %>%
select(Flag, everything()) %>%
{if (is_html_output()) datatable(., filter = 'top', rownames = F, escape = F) else .}