Category: Data preparation

In this article I want to compare the accuraccy of the data and the calculations used in some of the visualisations, en-route ATFM delay, to be more precise. The reference for comparison will be the document EUROCONTROL Standard Inputs for Economic Analyses. In here, in chapter, the average en-route delay is defined like this: In […]

For this visulasation, I needed two sets of data: Definitions First the definitions. ATM/CNS provision costs is a metric used in the ACE reports and it excludes MET costs, EUROCONTROL costs and States/NSAs costs from the overal costs equation. The “composite gate-to-gate flight-hours”considers a “gate-to-gate” perspective, “because the boundaries used to allocate costs between en-route […]

I sourced the data from the tables published as annexes to the ICAO Annual Reports of the Council (and/or “World of air transport in year YYYY”). These were downloaded from the ICAO public website. The oldest edition with data available was from 2006, which would contain data down to year 1998. I downloaded 4 different […]

This dataset was created by combining the information from 34 (EU + UK, MK, ME, TR, IS, NO, CH) detailed datasets called Air passenger transport between the main airports of (COUNTRY) and their main partner airports (routes data), available at the EUROSTAT database page. Honestly, this was so far my biggest data preparation project, I […]

Deployment data sourcing, transformation and cleaning  The souce of the data is https://www.atmmasterplan.eu/depl/essip_objectives/map . I couldnt find a way to download a complete raw data for all the objectives for all the years of the ESSIP/LSSIP process, so I downloaded manually data for the last 2 years for 20 objectives.  40 excel files were saved into a folder.  Using the […]