## X X.1 Los.Angeles Phoenix San.Diego San.Francisco Seattle
## 1 Alaska on time 497 221 212 503 1841
## 2 delayed 62 12 20 102 305
## 3 NA NA NA NA NA
## 4 AM WEST on time 694 4840 383 320 201
## 5 delayed 117 415 65 129 61
## Warning: package 'tidyr' was built under R version 3.2.3
##
## Attaching package: 'dplyr'
##
## The following objects are masked from 'package:stats':
##
## filter, lag
##
## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, union
## airline status city n
## 1 Alaska on time la 497
## 2 Alaska delayed la 62
## 4 AM WEST on time la 694
## 5 AM WEST delayed la 117
## 6 Alaska on time ph 221
## 7 Alaska delayed ph 12
## 9 AM WEST on time ph 4840
## 10 AM WEST delayed ph 415
## 11 Alaska on time sd 212
## 12 Alaska delayed sd 20
## 14 AM WEST on time sd 383
## 15 AM WEST delayed sd 65
## 16 Alaska on time sf 503
## 17 Alaska delayed sf 102
## 19 AM WEST on time sf 320
## 20 AM WEST delayed sf 129
## 21 Alaska on time sea 1841
## 22 Alaska delayed sea 305
## 24 AM WEST on time sea 201
## 25 AM WEST delayed sea 61
## Source: local data frame [2 x 3]
## Groups: airline [2]
##
## airline delayed on time
## (chr) (dbl) (dbl)
## 1 Alaska 501 3274
## 2 AM WEST 787 6438