Kaggle Airline Delay & Cancellation Analysis (SQL)
Analysis of Domestic Airline Cancellation and Delays (2009-2018)
| Home |
|---|
| Motivation |
| About the Data |
| Obtaining Data |
| Software Requirements |
| Analysis with SQL |
| Summary |
| Glossary |
| References |
Obtaining the Data:
-
Airline Cancellation/Delay (2009-2018) dataset
The main dataset i.e. Domestic Airline Cancellation/Delay (2009-2018) dataset was obtained from Kaggle. A total of 10 CSV files, each representing data for each year with size 700 MB each, were combined together to form the complete dataset.
Each CSV file was downloaded individually and comboned together with a
pythonscript to form a wholesome 7 GB dataset. -
The Global Airport Database dataset
The auxillary dataset was downloaded from The Global Airport Database by Partow.
Preprocessing the data:
- As the sourced data was already cleaned and formatted, no preprocessing was involved.
