SDMX-MDGs - DF_UNDATA_MDG

Data - UN

Author

François Geerolf

FREQ

Code 
DF_UNDATA_MDG %>%
  left_join(FREQ, by = "FREQ") %>%
  group_by(FREQ, Freq) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
FREQ Freq Nobs
A Annual 387044

SERIES

Code 
DF_UNDATA_MDG %>%
  group_by(SERIES) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}

LOCATION

Code 
DF_UNDATA_MDG %>%
  group_by(LOCATION) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
LOCATION Nobs
T 361648
U 13374
R 12022

REF_AREA

Code 
DF_UNDATA_MDG %>%
  left_join(REF_AREA, by = "REF_AREA") %>%
  group_by(REF_AREA, Ref_area) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}