Background: In 2021, 14.5% of flights departing from San Diego International Airport offered by Southwest Airlines, American Airlines, United Airlines, and Delta Airlines were delayed. According to Statistica*, these four airlines held the largest portions of domestic market share in 2021.
The purpose of this project is to explore the flight delays out of San Diego International Airport from Southwest Airlines, American Airlines, United Airlines, and Delta Airlines, to discover the main causes of flight delays from 2017-2021. Identifying leading causes of flight delays can point to areas where these airlines can improve.
*Statistic: https://www.statista.com/statistics/250577/domestic-market-share-of-leading-us-airlines/
Context: This project was completed as part of the CareerFoundry's curriculum.
Topics covered were sourcing data, geographical visualizations, supervised machine learning (regression), unsupervised machine learning (clustering), time-series analysis, and dashboards.
This knowledge was used to explore and analyze flight delay data. Project deliverables:
Tableau dashboard
Data Sources:
-
Airport Codes Owner: United States Department of Transportation Website: https://www.transportation.gov/policy/aviation-policy/airport-codes-txt
-
Delta Departures from San Diego International Airport (2017-2021) Owner: United States Department of Transportation (Bureau of Transportation Statistics) Website: https://www.transtats.bts.gov/ONTIME/Departures.aspx
-
United Departures from San Diego International Airport (2017-2021) Owner: United States Department of Transportation (Bureau of Transportation Statistics) Website: https://www.transtats.bts.gov/ONTIME/Departures.aspx
-
Southwest Departures from San Diego International Airport (2017-2021) Owner: United States Department of Transportation (Bureau of Transportation Statistics) Website: https://www.transtats.bts.gov/ONTIME/Departures.aspx
-
American Departures from San Diego International Airport (2017-2021) Owner: United States Department of Transportation (Bureau of Transportation Statistics) Website: https://www.transtats.bts.gov/ONTIME/Departures.aspx
-
JSN file for Choropleth Map Owner: Eric Tech Website: https://eric.clst.org/tech/usgeojson/
-
Airline Ticket Price Index, Quarterly Owner: Quandl Website: https://data.nasdaq.com/data/EIA-us-energy-information-administration-data
Tools used for project: Python Tableau