The aim of our study is to answer the following research questions:
- Does the price vary with Airlines?
- How is the price affected when tickets are bought just 1 or 2 days before departure?
- How does the price change with different Source and Destination cities?
- How does the ticket price vary between Economy and Business class?
The dataset contains information about flight booking options from the Ease My Trip website for flights between India's top 6 metro cities. There are 300,261 data points and 11 features in the cleaned dataset.
The various features of the cleaned dataset are explained below:
- Airline: The name of the airline company. This is a categorical feature with 6 different airlines.
- Flight: Information regarding the plane's flight code. This is a categorical feature.
- Source City: The city from which the flight takes off. This is a categorical feature with 6 unique cities.
- Departure Time: A derived categorical feature created by grouping time periods into bins. It contains 6 unique time labels for the departure time.
- Stops: A categorical feature with 3 distinct values that indicates the number of stops between the source and destination cities.
- Arrival Time: A derived categorical feature created by grouping time intervals into bins. It has 6 distinct time labels for the arrival time.
- Destination City: The city where the flight will land. This is a categorical feature with 6 unique cities.
- Class: A categorical feature that contains information on seat class, with two distinct values: Business and Economy.
- Duration: A continuous feature that shows the total travel time between cities in hours.
- Days Left: A derived feature calculated by subtracting the booking date from the trip date.
- Price: The target variable that stores information on the ticket price.
git clone https://github.com/melllinia/FlightPriceDashboard.git
cd FlightPriceDashboardpip install -r requirements.txtpython3 src/app.pyThe dashboard is available online with subsampled data for demonstration purposes.
You can access it here: Flight Price Dashboard