Monthly air passenger ridership and freight volumes

[Vivek Matthew]

Hi all,

The DGCA puts out monthly (domestic) and quarterly (international) reports on their website with data on air passenger ridership and freight volumes. I've consolidated some of the reports on there into a set of CSV files, with the data grouped by city, carrier and country. For example, this has the domestic city-wise data: https://flatgithub.com/Vonter/india-aviation-traffic?filename=aggregated/domestic/city.csv&stickyColumnName=City1

The rest of the data and code can be found on this GitHub repository: https://github.com/Vonter/india-aviation-traffic

Regards,

Vivek

[Raghvendra Mishra]

Hi Vivek,

Thanks for sharing the publically available data in readable format. 

 

Regards,

Raghvendra Mishra

--
Datameet is a community of Data Science enthusiasts in India. Know more about us by visiting http://datameet.org
---
You received this message because you are subscribed to the Google Groups "datameet" group.
To unsubscribe from this group and stop receiving emails from it, send an email to datameet+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/3e83f9b9-b282-4d20-889e-205de028d269n%40googlegroups.com.

[Akshi Chawla]

Thank you for sharing. In addition to DGCA, the Civil Aviation Ministry has also started putting out a lot of daily numbers very recently. We are trying to collate some of this (daily) data on one of our tools, the EcoMeter (screenshot below). If you are interested in using this data, and have notes to share/feedback for us/advice on how we can do better/or want to use this data, please feel free to get in touch (and also if you have this daily data collated from older months!): 

Akshi

[Vivek Matthew]

Hi Akshi,

I was not aware of the daily reports on the Ministry of Civil Aviation website, thanks for pointing it out. The Wayback Machine seems to have fairly regular snapshots of the website over the past couple of years: https://web.archive.org/web/20240000000000*/https://www.civilaviation.gov.in/

I've made an attempt at using the snapshots available on the Wayback Machine to generate a CSV containing data from earlier months: https://flatgithub.com/Vonter/india-aviation-traffic?filename=aggregated/daily.csv&stickyColumnName=Date

The code itself is on the same GitHub repository: https://github.com/Vonter/india-aviation-traffic

I noticed that there are some days where the data on the site is not updated (even when the Wayback Machine fetches an updated version of the page), so there are many days with data gaps. Also, the structure of the page has changed over the years, which I attempted to handle in the scripts but that may have broken parsing on some of the days. If you notice any issues with the data or the code, do let me know.

If you've got data covering an entire month, it may be a good idea to see if it matches the numbers put out by DGCA. I'm not too familiar with how these statistics are collected by MCA/DGCA, but I wonder if one of them may include certain categories of flights (chartered/non-scheduled/private) in their counts which the other does not.

Regards,

Vivek