A small tool to help you find the best airline with shortest delay based on your departure airport and month.
- Airport Data Structure
Created a mapping system for major U.S. airports that serves as a centralized reference for the analysis. This structure enables easy airport lookup and maintains consistent naming throughout the application, crucial for data integrity and user interface display.
- COVID Period Data Exclusion
Implemented strategic data filtering to exclude 2020 flight data, ensuring the analysis isn't skewed by COVID-19 travel disruptions. This preprocessing step maintains data reliability by focusing on normal operational periods.
- Multi-Metric Airline Analysis
Developed a comprehensive analysis system that simultaneously calculates multiple performance metrics (delays, cancellations, total flights) for each airline. This aggregation provides a holistic view of airline performance using pandas' advanced groupby operations.
- Monthly Performance Tracking
Created a time-series analysis system that breaks down airline performance by month, enabling seasonal trend identification and month-over-month comparisons. This temporal analysis helps identify patterns in airline delays across different seasons.
