As an aviation enthusiast, I decided to do an exploratory data analysis of aviation dataset giving insights into average prices and duration between major flying cities in India.
The source of this data is Kaggle and thus considered as secondary data. The dataset includes details on the ticket booking alternatives available through the website "Easemytrip" for flights between India's top 6 metro cities.
Following are the key features of the dataset corresponding to 50 days of data from February 11 to March 31 of 2022.
Columns: 11
Rows: 300,261
Total airlines: 6
Cities: 6
Dataset Link: Kaggle
Description of the columns:
- Airline: Represents the name of the airline
- Flight: The flight code of the aircraft
- Source City: Source of the departing flight
- Departure Time: Time of the day the flight departs from the source city
- Stops: Number of stops between tbefore it reaches the final destination
- Arrival Time: Represents the time of the day flight arrives at its destination
- Destination City: Final destination of the flight
- Class: Represents Economy or Business class
- Duration: Total number of hours needed to travel between source & destination city
- Days Left: The trip date is subtracted from the booking date to arrive at this derived feature.
- Price: Price of the ticket.
Power BI Visualization Dashboard
Key questions answered:
- What is the average flight duration between cities?
- Which is the fastest airline between any two choosen cities?
- Which is the cheapest airline between any two choosen cities?
- What time of the day is the cheapest time to fly between any two choosen cities?
- What is the average price in Economy class?
- What is the avergae price in Business class?