Major airlines usually would post their monthly operation results on IR websites. While United Airlines and Southwest Airlines among other stopped reporting in 2019, Alaska and Delta are still doing so.
Load factor is a measure of the use of aircraft capacity that compares Revenue Passenger-Miles as a proportion of Available Seat-Miles.
Below is a three-part project that automatically downloads, summarizes and creates chart for 4 airlines’ load factor.
Download
Given certain years, the program will go through pre-defined links to search for monthly report urls and scrap relevant data based on the page structure. BeautifulSoup is used here.
Summary
The program uses file reading and writing to put four airlines’ data together while adjusting for missing data (aligning based on month)
Charting
The program converts csv to excel and draws the chart based on data. pandas and xlsxwriter are used here.
With some adjustments, the program should be able to scrape and virtualize other web-based standard reports.