Top 20 ports - passengers embarked and disembarked in each port, by direction - mar_mp_aa_pphd

Data - Eurostat

direct

Code
mar_mp_aa_pphd %>%
  left_join(direct, by = "direct") %>%
  group_by(direct, Direct) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  print_table_conditional()
direct Direct Nobs
IN Inwards 1116
OUT Outwards 1116
TOTAL Total 1116

unit

Code
mar_mp_aa_pphd %>%
  left_join(unit, by = "unit") %>%
  group_by(unit, Unit) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
unit Unit Nobs
THS_PAS Thousand passengers 1746
RT_PRE Growth rate on previous period (t/t-1) 1602

rep_mar

Code
mar_mp_aa_pphd %>%
  left_join(rep_mar, by = "rep_mar") %>%
  group_by(rep_mar, Rep_mar) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  mutate(Flag = gsub(" ", "-", str_to_lower(gsub(" ", "-", Rep_mar))),
         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

Code
mar_mp_aa_pphd %>%
  group_by(time) %>%
  summarise(Nobs = n()) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}

Conteneurs

Table

Code
mar_mp_aa_pphd %>%
  filter(unit == "THS_PAS",
         time == "2019") %>%
  select( -unit, -time) %>%
  left_join(rep_mar, by = "rep_mar") %>%
  left_join(direct, by = "direct") %>%
  select(-direct) %>%
  spread(Direct, values) %>%
  arrange(-Total) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F, escape = F) else .}