Effect of Advance Booking on Airline Ticket Pricing in India
Sameer Mathur
Data Summary and Visualization
---
PART 1: READING AND DESCRIBING DATA
Number of Rows and Columns
[1] 8187 23
Name of the Data Variables
[1] "FlightNumber" "Airline" "DepartureCity"
[4] "ArrivalCity" "DepartureTime" "ArrivalTime"
[7] "Departure" "Fly" "FlyingTime"
[10] "Aircraft" "PlaneModel" "Capacity"
[13] "SeatPitch" "SeatWidth" "DataCollectionDate"
[16] "DateDeparture" "DayDeparture" "Weekend"
[19] "Price" "AdvBookDays" "Diwali"
[22] "DayBeforeDiwali" "DayAfterDiwali"
Descriptive Statistics
vars n mean sd median min max
FlightNumber* 1 8187 874.45 513.40 866 1.0 1765
Airline* 2 8187 2.27 0.90 2 1.0 4
DepartureCity* 3 8187 36.11 20.09 42 1.0 79
ArrivalCity* 4 8187 37.25 18.73 41 1.0 76
DepartureTime 5 8187 1129.12 589.76 1020 5.0 2345
ArrivalTime 6 8187 1194.21 610.53 1115 0.0 2359
Departure* 7 8187 1.41 0.49 1 1.0 2
Fly* 8 8187 2.66 0.98 3 1.0 4
FlyingTime 9 8187 112.46 35.80 110 40.0 195
Aircraft* 10 8187 2.30 0.62 2 1.0 4
PlaneModel* 11 8187 55.47 26.22 61 1.0 122
Capacity 12 8187 165.44 36.79 180 50.0 423
SeatPitch 13 8187 30.22 1.23 30 29.0 40
SeatWidth 14 8187 17.61 0.59 18 16.2 21
DataCollectionDate* 15 8187 3.76 0.98 4 1.0 7
DateDeparture* 16 8187 13.16 9.06 12 1.0 29
DayDeparture* 17 8187 4.75 1.65 5 1.0 7
Weekend* 18 8187 1.17 0.38 1 1.0 2
Price 19 8187 5555.89 3219.96 4778 637.0 43454
AdvBookDays 20 8187 14.65 9.78 16 1.0 39
Diwali* 21 8187 1.40 0.49 1 1.0 2
DayBeforeDiwali* 22 8187 1.20 0.40 1 1.0 2
DayAfterDiwali* 23 8187 1.20 0.40 1 1.0 2
Avrerage Ticket Price by Airline
Airline N Mean_Price SD_Price
1: Air India 1543 6712.03 4455.83
2: IndiGo 3811 4979.13 2595.44
3: Jet Airways 1905 6134.13 3126.99
4: Spice Jet 928 4815.12 2435.60
Average Ticket Price by Diwali
Diwali N Mean_Price SD_Price
1: No 4913 5736.87 3200.87
2: Yes 3274 5284.31 3229.92
Average Ticket Price by Weekend
Weekend N Mean_Price SD_Price
1: No 6774 5500.03 3267.06
2: Yes 1413 5823.71 2970.39
Average Ticket Price by Departure
Departure N Mean_Price SD_Price
1: PM 3385 5370.12 2772.48
2: AM 4802 5686.85 3495.56
Average Ticket Price by Airline and Diwali
Diwali Airline N Mean_Price SD_Price
1: No Air India 911 6893.44 4710.00
2: Yes Air India 632 6450.53 4050.96
3: No IndiGo 2302 5188.15 2411.85
4: Yes IndiGo 1509 4660.28 2824.02
5: No Jet Airways 1138 6226.49 3096.98
6: Yes Jet Airways 767 5997.08 3168.04
7: No Spice Jet 562 5118.24 2479.46
8: Yes Spice Jet 366 4349.68 2293.13
Scatter Plot of Ticket Price and Advance Booking
Average Ticket Price of Airline
Average Ticket Price of Airlines by Diwali
