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

plot of chunk unnamed-chunk-9

Average Ticket Price of Airline

plot of chunk unnamed-chunk-10

Average Ticket Price of Airlines by Diwali

plot of chunk unnamed-chunk-11