Top 20 ports - volume (in TEUs) of containers handled in each port, by loading status (main ports)

Data - Eurostat

Author

François Geerolf

Info

LAST_DOWNLOAD

Code 
tibble(LAST_DOWNLOAD = as.Date(file.info("~/Library/Mobile\ Documents/com~apple~CloudDocs/website/data/eurostat/mar_mg_am_pvh.RData")$mtime)) %>%
  print_table_conditional()
LAST_DOWNLOAD
2024-10-08

LAST_COMPILE

LAST_COMPILE
2024-11-05

Last

Code 
mar_mg_am_pvh %>%
  group_by(time) %>%
  summarise(Nobs = n()) %>%
  arrange(desc(time)) %>%
  head(1) %>%
  print_table_conditional()
time Nobs
2022 116

loadstat

Code 
mar_mg_am_pvh %>%
  left_join(loadstat, by = "loadstat") %>%
  group_by(loadstat, Loadstat) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
loadstat Loadstat Nobs
TOTAL Total loaded and empty 1089
EMPTY Empty 1085

unit

Code 
mar_mg_am_pvh %>%
  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_TEU Thousand twenty-foot equivalent unit (TEU) 1124
RT_PRE Growth rate on previous period (t/t-1) 1050

rep_mar

Code 
mar_mg_am_pvh %>%
  left_join(rep_mar, by = "rep_mar") %>%
  group_by(rep_mar, Rep_mar) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  print_table_conditional()

time

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

Top 20 Ports

Code 
i_g("bib/industrie/top-20-ports.png")

Conteneurs

2019

Code 
mar_mg_am_pvh %>%
  filter(unit == "THS_TEU",
         time == "2019",
         loadstat == "TOTAL") %>%
  left_join(rep_mar, by = "rep_mar") %>%
  select(rep_mar, Rep_mar, values) %>%
  arrange(-values) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F, escape = F) else .}

2020

Code 
mar_mg_am_pvh %>%
  filter(unit == "THS_TEU",
         time == "2020",
         loadstat == "TOTAL") %>%
  left_join(rep_mar, by = "rep_mar") %>%
  select(rep_mar, Rep_mar, values) %>%
  arrange(-values) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F, escape = F) else .}

Marseille, Antwerpen, Hamburg, Rotterdam

Code 
mar_mg_am_pvh %>%
  left_join(rep_mar, by = "rep_mar") %>%
  filter(loadstat == "TOTAL",
         unit == "THS_TEU",
         Rep_mar %in% c("Rotterdam", "Antwerpen", "Hamburg", "Marseille")) %>%
  year_to_date %>%
  mutate(values = values / 10^3) %>%
  ggplot + geom_line(aes(x = date, y = values, color = Rep_mar)) +
     theme_minimal() + xlab("") + ylab("Volumes des conteneurs (Millions EVP)") +
  
  theme(legend.position = c(0.3, 0.85),
        legend.title = element_blank()) +
  scale_x_date(breaks = seq(1940, 2100, 2) %>% paste0("-01-01") %>% as.Date,
               labels = date_format("%Y")) +
  scale_y_continuous(breaks = seq(0, 20, 1))

FR_2FRMRS

Antwerpen, Hamburg, Rotterdam

Code 
mar_mg_am_pvh %>%
  left_join(rep_mar, by = "rep_mar") %>%
  filter(loadstat == "TOTAL",
         unit == "THS_TEU",
         Rep_mar %in% c("Rotterdam", "Antwerpen", "Hamburg")) %>%
  year_to_date %>%
  mutate(values = values / 10^3) %>%
  ggplot + geom_line(aes(x = date, y = values, color = Rep_mar)) +
     theme_minimal() + xlab("") + ylab("Volumes des conteneurs (Millions EVP)") +
  
  theme(legend.position = c(0.3, 0.85),
        legend.title = element_blank()) +
  scale_x_date(breaks = seq(1940, 2100, 2) %>% paste0("-01-01") %>% as.Date,
               labels = date_format("%Y")) +
  scale_y_continuous(breaks = seq(0, 20, 1))

Peiraias, Valencia, Algeciras

Code 
mar_mg_am_pvh %>%
  left_join(rep_mar, by = "rep_mar") %>%
  filter(loadstat == "TOTAL",
         unit == "THS_TEU",
         Rep_mar %in% c("Peiraias", "Valencia", "Algeciras")) %>%
  year_to_date %>%
  mutate(values = values / 10^3) %>%
  ggplot + geom_line(aes(x = date, y = values, color = Rep_mar)) +
     theme_minimal() + xlab("") + ylab("Volumes des conteneurs (Millions EVP)") +
  
  theme(legend.position = c(0.3, 0.85),
        legend.title = element_blank()) +
  scale_x_date(breaks = seq(1940, 2100, 2) %>% paste0("-01-01") %>% as.Date,
               labels = date_format("%Y")) +
  scale_y_continuous(breaks = seq(0, 20, 1))

Bremerhaven, Felixstowe, Barcelona

Code 
mar_mg_am_pvh %>%
  left_join(rep_mar, by = "rep_mar") %>%
  filter(loadstat == "TOTAL",
         unit == "THS_TEU",
         Rep_mar %in% c("Bremerhaven", "Felixstowe", "Barcelona")) %>%
  year_to_date %>%
  mutate(values = values / 10^3) %>%
  ggplot + geom_line(aes(x = date, y = values, color = Rep_mar)) +
     theme_minimal() + xlab("") + ylab("Volumes des conteneurs (Millions EVP)") +
  
  theme(legend.position = c(0.1, 0.85),
        legend.title = element_blank()) +
  scale_x_date(breaks = seq(1940, 2100, 2) %>% paste0("-01-01") %>% as.Date,
               labels = date_format("%Y")) +
  scale_y_continuous(breaks = seq(0, 20, 1))

Ambarli, Gioia Tauro, Le Havre

Code 
mar_mg_am_pvh %>%
  left_join(rep_mar, by = "rep_mar") %>%
  filter(loadstat == "TOTAL",
         unit == "THS_TEU",
         Rep_mar %in% c("Ambarli", "Gioia Tauro", "Le Havre")) %>%
  year_to_date %>%
  mutate(values = values / 10^3) %>%
  ggplot + geom_line(aes(x = date, y = values, color = Rep_mar)) +
     theme_minimal() + xlab("") + ylab("Volumes des conteneurs (Millions EVP)") +
  
  theme(legend.position = c(0.1, 0.85),
        legend.title = element_blank()) +
  scale_x_date(breaks = seq(1940, 2100, 2) %>% paste0("-01-01") %>% as.Date,
               labels = date_format("%Y")) +
  scale_y_continuous(breaks = seq(0, 20, .5))

12 ports

Linear

Code 
mar_mg_am_pvh %>%
  left_join(rep_mar, by = "rep_mar") %>%
  filter(loadstat == "TOTAL",
         unit == "THS_TEU",
         Rep_mar %in% c("Rotterdam", "Antwerpen", "Hamburg",
                        "Peiraias", "Valencia", "Algeciras",
                        "Bremerhaven", "Felixstowe", "Barcelona",
                        "Ambarli", "Gioia Tauro", "Le Havre")) %>%
  year_to_date %>%
  mutate(values = values / 10^3) %>%
  mutate(Rep_mar = factor(Rep_mar, c("Rotterdam", "Antwerpen", "Hamburg",
                        "Peiraias", "Valencia", "Algeciras",
                        "Bremerhaven", "Felixstowe", "Barcelona",
                        "Ambarli", "Gioia Tauro", "Le Havre"))) %>%
  ggplot + geom_line(aes(x = date, y = values, color = Rep_mar)) +
  theme_minimal() + xlab("") + ylab("Volumes des conteneurs (Millions EVP)") +
  #scale_color_manual(values = viridis(13)[1:12]) +
  theme(legend.title = element_blank()) +
  scale_x_date(breaks = seq(1940, 2100, 2) %>% paste0("-01-01") %>% as.Date,
               labels = date_format("%Y")) +
  scale_y_continuous(breaks = seq(0, 20, 1))

Log

Code 
mar_mg_am_pvh %>%
  left_join(rep_mar, by = "rep_mar") %>%
  filter(loadstat == "TOTAL",
         unit == "THS_TEU",
         Rep_mar %in% c("Rotterdam", "Antwerpen", "Hamburg",
                        "Peiraias", "Valencia", "Algeciras",
                        "Bremerhaven", "Felixstowe", "Barcelona",
                        "Ambarli", "Gioia Tauro", "Le Havre")) %>%
  year_to_date %>%
  mutate(values = values / 10^3) %>%
  mutate(Rep_mar = factor(Rep_mar, c("Rotterdam", "Antwerpen", "Hamburg",
                        "Peiraias", "Valencia", "Algeciras",
                        "Bremerhaven", "Felixstowe", "Barcelona",
                        "Ambarli", "Gioia Tauro", "Le Havre"))) %>%
  ggplot + geom_line(aes(x = date, y = values, color = Rep_mar)) +
  theme_minimal() + xlab("") + ylab("Volumes des conteneurs (Millions EVP)") +
  #scale_color_manual(values = viridis(13)[1:12]) +
  theme(legend.title = element_blank()) +
  scale_x_date(breaks = seq(1940, 2100, 2) %>% paste0("-01-01") %>% as.Date,
               labels = date_format("%Y")) +
  scale_y_log10(breaks = seq(0, 20, 1))