dataset columns and their meanings:
| Column Name | Type | Description |
|---|---|---|
| Booking_ID | ID | Unique identifier for each booking (e.g., FB1001). |
| Ticket_Price | Numerical | Flight ticket price in USD. |
| Distance_km | Numerical | Distance of the journey in kilometers. |
| Flight_Duration_hr | Numerical | Duration of the flight in hours. |
| Passenger_Age | Numerical | Age of the passenger. |
| Airline | Categorical | Name of the airline (e.g., Emirates, Air India). |
| Travel_Class | Categorical | Class of travel (Economy, Premium Economy, Business, First). |
| Departure_City | Categorical | City of departure (e.g., London, Mumbai, Dubai). |
| Payment_Method | Categorical | Mode of payment (Credit Card, UPI, Cash, etc.). |
General Information
- Number of Rows: 250
- Number of Columns: 9
- Purpose: Simulated dataset representing airline ticket bookings, useful for data analysis, visualization, machine learning, and business insights in the aviation/travel industry.
Value Distributions
- Airlines: Randomly chosen among 6 international airlines.
- Travel_Class: Balanced mix of Economy, Premium Economy, Business, and First.
- Departure_City: Covers major global hubs (London, Mumbai, Dubai, New York, Singapore, Frankfurt, Delhi, Paris).
- Payment_Method: Multiple payment modes included for diversity.
Possible Use Cases
- Exploratory Data Analysis (EDA): Ticket price trends, passenger age distribution, duration vs distance analysis.
- Visualization: Compare average ticket prices by airline, travel class, or city.
- Machine Learning: Predict ticket prices, estimate flight duration, or analyze customer behavior.
- Business Insights: Identify most common payment methods, popular routes, and preferred travel classes.
Some possible questions to solve with this dataset:
- Which airline has the highest average ticket price?
- Is there a correlation between distance and ticket price?
- What is the average passenger age for each travel class?
- Which departure city shows the longest average flight duration?
- Which payment method is most popular for business-class travelers?
- Do older passengers prefer certain airlines or payment methods?
- Can we build a model to predict ticket price based on distance, duration, and travel class?