##         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