Easy
- What are the longest and shortest distance flights?
- Which dates had the maximum number of flights?
- Which carriers experienced the most delays?
- Which carrier operated most number of flights in 2016?
Medium
- Which route has the most cancelled flights?
- Which carrier has the highest cancelled flights/total flights ratio?
Tough Questions
- Which routes have overall maximum delays, across the entire year?
- Can we predict if a flight will be cancelled? (Using pyspark.ml and building a predictive model)