Delhi-Gawahati is a less populated route when compared to Mumbai-Delhi. Our main reason of selecting this route was to understand the dynamics of a low populated domestic Indian route.
Departure Time vs Fare: Based on the trends, the timeslots can be decided and further expanded.
Departure Time slot histogram: Based on division of timeslot, also gives a good insight of airline fare in each timeslot.
Fare vs Airline: Some are economical while others are well distributed or lie more on the higher end. Since we are focusing on only the minimum fare, we can ignore few airlines.
Count of airline: Number of flights operating per airline in different ranges of fare.
Days to departure vs Fare: Trend of each airline as days to departure varies.
Variation of Fare: Boxplot for fare according to airways and departure day.
Data collected: Departure date vs days to departure.
Probability of airline having minimum fare
Trend for minimum custom fare as days to departure varies.
Number of times it is better to wait for the price to decrease (1 = Wait)