Rating Analysis

This plot shows the relationship between Rating Value and Rating Categories. We can conclude from this plot that ratings of Delta are much higher than those of UA and AA from all rating categories which shows that people really love Delta more than the other two airlines.

Delay Analysis

The first two plots in Delay Analysis are focused on Delay Causes, we can see that diverted Actual Elapsed Time, Diverted Arrival Delay, and Diverted Distance can cause longer delay time than others. But from the second plot, we can see that those kinds of delay rarely happen. National Airspace System Delay, Late Aircraft Delay, and Carrier Delay are still main causes for most situation.

These are the relationships between Arrival(Departure) Delay Time and Arrival(Departure) Time during one day. It seems that red-eye flights tends to delay more and Delta performs worse during night than the other two airlines.

This plot shows Delay Time during one week. Line type indicates Delay Type. It seems that flights during weekend or on Monday tend to delay more and the problem of departure delay is more severe than that of arrival delay. Besides, UA performs worse than the other two airlines.

This plot tells us the relationship between Arrival Delay Time and Different Destination Airport. Here we choose the largest twenty-three airports for analysis. Color indicates different airlines and size indicates the amounts of arrival flights. We can get lots of information from this plot. For example, Los Angeles Airport and San Francisco Airport perform worse than other big airports. And in the same destination airport, UA has a big chance to delay more than the other two airlines.

Overbooking Analysis

The last two plots are for Overbooking Analysis, of which the first one shows that the ratio of people denied boarding voluntarily from Delta is higher than UA and AA, which shows that overbooking is really an issue in Delta. But from the last plot, it seems that the ratio of people denied boarding involuntarily from Delta is much lower than UA and AA, which means that Delta can handle this issue pretty well.