The projects in this repository consists of two tasks. Both tasks involved gathering, extracting, wrangling, analysing, and visualizing flight data derived from local U.S. domestic reporting airlines to improve flight reliabilty and customer reliability.
In the dashboard there are two repost items
- Yearly airline performance report
- Yearly average flight delay statistics
-
YEARLY AIRLINE PERFORMANCE REPORT
FOR THE YEAR CHOSEN- Number of flights under different cancellation categories using bar chart.
- Average flight time by reporting airline using line chart.
- Percentage of diverted airport landings per reporting airline using pie chart.
- Number of flights flying from each state using choropleth map.
- Number of flights flying to each state from each reporting airline using treemap chart.
-
YEARLY AVERAGE FLIGHT DELAY STATISTICS
FOR THE YEAR CHOSEN- Monthly average carrier delay by reporting airline for the given year.
- Monthly average weather delay by reporting airline for the given year.
- Monthly average national air system delay by reporting airline for the given year.
- Monthly average security delay by reporting airline for the given year.
- Monthly average late aircraft delay by reporting airline for the given year.
Using Pandas to extract and prepare the data for analysis, and Dash to visualize the data and create a dashboard. The rendered dashboard should look like the image below: