Problem Set # 2

Rebekah Jones

date()
## [1] "Tue Sep 27 23:14:06 2016"

Due Date: September 27, 2016 Total Points: 32

1 The following ten observations, taken during the years 1970-1979, are on October snow cover for Eurasia in units of millions of square kilometers. Follow the instructions and answer the questions by typing the appropriate commands.

Year Snow 1970 6.5 1971 12.0 1972 14.9 1973 10.0 1974 10.7 1975 7.9 1976 21.9 1977 12.5 1978 14.5 1979 9.2

  1. Create a data frame from these data. (2)
snow <- c(6.5, 12.0, 14.9, 10.0, 10.7, 7.9, 21.9, 12.5, 14.5, 9.2)
Year <- 1970:1979
snowfr <- data.frame(Year, snow)
head(snowfr)
##   Year snow
## 1 1970  6.5
## 2 1971 12.0
## 3 1972 14.9
## 4 1973 10.0
## 5 1974 10.7
## 6 1975  7.9
  1. What are the mean and median snow cover over this decade? (2)
mean(snow)
## [1] 12.01
median(snow)
## [1] 11.35
  1. What is the standard deviation of the snow cover over this decade? (2)
sd(snow)
## [1] 4.390761
  1. How many Octobers had snow cover greater than 10 million km\(^2\)? (2) That information is not included in the data frame.

2 The data vector rivers contains the lengths (miles) of 141 major rivers in North America.

  1. What proportion of the rivers are shorter than 500 miles long? (2)
(length(which(rivers < 500))/length(rivers))*100
## [1] 58.15603
  1. What proportion of the rivers are shorter than the mean length? (2)
(length(which(rivers < mean(rivers)))/length(rivers))*100
## [1] 66.66667
  1. What is the 75th percentile river length? (2)
quantile(rivers, probs = c(.75))
## 75% 
## 680
  1. What is the interquartile range in river length? (2)
quantile(rivers, probs = c(.25, .75))
## 25% 75% 
## 310 680

3 The dataset hflights from the in package contains all 227,496 flights that departed Houston in 2011. Using the functions in the dplyr package

  1. Create a data frame from hflights containing only those flights that departed on September 11th of that year. (4)
library(dplyr)
## 
## 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
library(hflights)
hflights %>%
  filter(Month == 9, DayofMonth == 11)
##     Year Month DayofMonth DayOfWeek DepTime ArrTime UniqueCarrier
## 1   2011     9         11         7    1546    1651            AA
## 2   2011     9         11         7     551     904            AA
## 3   2011     9         11         7    1936    2036            AA
## 4   2011     9         11         7    1438    1544            AA
## 5   2011     9         11         7    1720    2030            AA
## 6   2011     9         11         7    1142    1258            AA
## 7   2011     9         11         7    1006    1333            AA
## 8   2011     9         11         7     712     815            AA
## 9   2011     9         11         7     858    1003            AA
## 10  2011     9         11         7    1833    2051            AS
## 11  2011     9         11         7     641    1047            B6
## 12  2011     9         11         7    1451    1857            B6
## 13  2011     9         11         7     945    1251            CO
## 14  2011     9         11         7    1740    1842            CO
## 15  2011     9         11         7    1550    1651            CO
## 16  2011     9         11         7    1534    1639            CO
## 17  2011     9         11         7    1533    1626            CO
## 18  2011     9         11         7    1928    2101            CO
## 19  2011     9         11         7     749     928            CO
## 20  2011     9         11         7    1759    1926            CO
## 21  2011     9         11         7    1202    1623            CO
## 22  2011     9         11         7    1648    2100            CO
## 23  2011     9         11         7     559    1012            CO
## 24  2011     9         11         7    1047    1520            CO
## 25  2011     9         11         7     724     824            CO
## 26  2011     9         11         7     725     951            CO
## 27  2011     9         11         7    1424    1555            CO
## 28  2011     9         11         7    1029    1407            CO
## 29  2011     9         11         7    1148    1329            CO
## 30  2011     9         11         7    1905    2148            CO
## 31  2011     9         11         7    1849    2009            CO
## 32  2011     9         11         7    1144    1324            CO
## 33  2011     9         11         7    1120    1243            CO
## 34  2011     9         11         7    1600    1726            CO
## 35  2011     9         11         7    1902    2105            CO
## 36  2011     9         11         7    1458    1733            CO
## 37  2011     9         11         7    1450    1609            CO
## 38  2011     9         11         7    1140    1238            CO
## 39  2011     9         11         7    1309    1522            CO
## 40  2011     9         11         7    1533    2005            CO
## 41  2011     9         11         7    1111    1448            CO
## 42  2011     9         11         7    1754    2203            CO
## 43  2011     9         11         7    1305    1727            CO
## 44  2011     9         11         7    1546    1901            CO
## 45  2011     9         11         7    1329    1456            CO
## 46  2011     9         11         7    1149    1252            CO
## 47  2011     9         11         7    1433    1654            CO
## 48  2011     9         11         7     929    1137            CO
## 49  2011     9         11         7    1259    1557            CO
## 50  2011     9         11         7    1040    1507            CO
## 51  2011     9         11         7    1437    1816            CO
## 52  2011     9         11         7    1847    2146            CO
## 53  2011     9         11         7    1309    1710            CO
## 54  2011     9         11         7     856    1301            CO
## 55  2011     9         11         7    1432    1546            CO
## 56  2011     9         11         7    1013    1527            CO
## 57  2011     9         11         7    1035    1343            CO
## 58  2011     9         11         7    1900    2333            CO
## 59  2011     9         11         7    1049    1513            CO
## 60  2011     9         11         7    1937    2247            CO
## 61  2011     9         11         7    2011    2325            CO
## 62  2011     9         11         7    1257    1639            CO
## 63  2011     9         11         7     904    1013            CO
## 64  2011     9         11         7    1816    1913            CO
## 65  2011     9         11         7    1248    1343            CO
## 66  2011     9         11         7    1155    1316            CO
## 67  2011     9         11         7    1417    1510            CO
## 68  2011     9         11         7    1903    1949            CO
## 69  2011     9         11         7    2108    2204            CO
## 70  2011     9         11         7    1954    2335            CO
## 71  2011     9         11         7    1021    1338            CO
## 72  2011     9         11         7    1544    1853            CO
## 73  2011     9         11         7    1552    1719            CO
## 74  2011     9         11         7    2116    2219            CO
## 75  2011     9         11         7    1017    1423            CO
## 76  2011     9         11         7    1009    1350            CO
## 77  2011     9         11         7    1919    2218            CO
## 78  2011     9         11         7    2113    2207            CO
## 79  2011     9         11         7     933    1129            CO
## 80  2011     9         11         7    1804    2008            CO
## 81  2011     9         11         7    1735    1910            CO
## 82  2011     9         11         7    2106    2231            CO
## 83  2011     9         11         7     749    1206            CO
## 84  2011     9         11         7    1847    2031            CO
## 85  2011     9         11         7    2106    2208            CO
## 86  2011     9         11         7    1440    1550            CO
## 87  2011     9         11         7    1439    1645            CO
## 88  2011     9         11         7    1325    1639            CO
## 89  2011     9         11         7    1931    2249            CO
## 90  2011     9         11         7     852     935            CO
## 91  2011     9         11         7     855    1000            CO
## 92  2011     9         11         7     739    1120            CO
## 93  2011     9         11         7    2059    2321            CO
## 94  2011     9         11         7    1748    1959            CO
## 95  2011     9         11         7    1136    1544            CO
## 96  2011     9         11         7    1231    1502            CO
## 97  2011     9         11         7    2045    2223            CO
## 98  2011     9         11         7     555     720            CO
## 99  2011     9         11         7     723     832            CO
## 100 2011     9         11         7    1310    1641            CO
## 101 2011     9         11         7     911    1320            CO
## 102 2011     9         11         7    1853    2226            CO
## 103 2011     9         11         7    1314    1614            CO
## 104 2011     9         11         7    1027    1132            CO
## 105 2011     9         11         7     846    1010            CO
## 106 2011     9         11         7    1311    1725            CO
## 107 2011     9         11         7    2054    2257            CO
## 108 2011     9         11         7    1538    2027            CO
## 109 2011     9         11         7    1322    1715            CO
## 110 2011     9         11         7    1506    1700            CO
## 111 2011     9         11         7    1541    1944            CO
## 112 2011     9         11         7    2057    2159            CO
## 113 2011     9         11         7     742    1035            CO
## 114 2011     9         11         7    1439    1529            CO
## 115 2011     9         11         7    1432    1704            CO
## 116 2011     9         11         7    1144    1401            CO
## 117 2011     9         11         7    1906    2120            CO
## 118 2011     9         11         7    1113    1329            CO
## 119 2011     9         11         7    1306    1647            CO
## 120 2011     9         11         7     910    1038            CO
## 121 2011     9         11         7    1908    2222            CO
## 122 2011     9         11         7    1605    1949            CO
## 123 2011     9         11         7    1143    1253            CO
## 124 2011     9         11         7    1804    2022            CO
## 125 2011     9         11         7    2104    2317            CO
## 126 2011     9         11         7    1632    1736            CO
## 127 2011     9         11         7    1852    2336            CO
## 128 2011     9         11         7     927    1057            CO
## 129 2011     9         11         7    1423    1543            CO
## 130 2011     9         11         7    1626    1903            CO
## 131 2011     9         11         7     720     841            CO
## 132 2011     9         11         7    1529    1635            CO
## 133 2011     9         11         7    1800    2017            CO
## 134 2011     9         11         7    1923    2024            CO
## 135 2011     9         11         7    1859     138            CO
## 136 2011     9         11         7     932    1147            CO
## 137 2011     9         11         7    1808    2144            CO
## 138 2011     9         11         7    1553    2012            CO
## 139 2011     9         11         7    1447    1610            CO
## 140 2011     9         11         7    1427    1806            CO
## 141 2011     9         11         7    1547    1945            CO
## 142 2011     9         11         7    1007    1353            CO
## 143 2011     9         11         7    1311    1655            CO
## 144 2011     9         11         7    1129    1610            CO
## 145 2011     9         11         7    1231    1632            CO
## 146 2011     9         11         7     915    1043            CO
## 147 2011     9         11         7    1803    1925            CO
## 148 2011     9         11         7     829    1003            CO
## 149 2011     9         11         7    1008    1302            CO
## 150 2011     9         11         7    1304    1404            CO
## 151 2011     9         11         7     855     946            CO
## 152 2011     9         11         7     847    1113            CO
## 153 2011     9         11         7    1847    2148            CO
## 154 2011     9         11         7    1313    1659            CO
## 155 2011     9         11         7     735    1055            CO
## 156 2011     9         11         7    2056    2139            CO
## 157 2011     9         11         7    2058    2221            CO
## 158 2011     9         11         7    1304    1603            CO
## 159 2011     9         11         7    1350    1714            CO
## 160 2011     9         11         7    1810    1901            CO
## 161 2011     9         11         7    1543    1907            CO
## 162 2011     9         11         7     730    1039            CO
## 163 2011     9         11         7    1654    2042            CO
## 164 2011     9         11         7    2102    2328            CO
## 165 2011     9         11         7    1335    1642            CO
## 166 2011     9         11         7    1135    1221            CO
## 167 2011     9         11         7     931    1202            CO
## 168 2011     9         11         7    1148    1322            CO
## 169 2011     9         11         7    1144    1422            CO
## 170 2011     9         11         7    1455    1550            CO
## 171 2011     9         11         7    2117    2309            CO
## 172 2011     9         11         7    1321    1416            CO
## 173 2011     9         11         7     909    1248            CO
## 174 2011     9         11         7     916    1048            CO
## 175 2011     9         11         7    1239    1556            CO
## 176 2011     9         11         7    1854    2238            CO
## 177 2011     9         11         7    1052    1352            CO
## 178 2011     9         11         7    1033    1207            CO
## 179 2011     9         11         7    1925    2329            CO
## 180 2011     9         11         7    1854    2233            CO
## 181 2011     9         11         7     730    1132            CO
## 182 2011     9         11         7    1542    1949            CO
## 183 2011     9         11         7    1006    1139            CO
## 184 2011     9         11         7    1600    2010            CO
## 185 2011     9         11         7    1552    2000            CO
## 186 2011     9         11         7    1730    1845            CO
## 187 2011     9         11         7    1136    1500            CO
## 188 2011     9         11         7    1434    1726            CO
## 189 2011     9         11         7    1748    1858            CO
## 190 2011     9         11         7    1831    1941            CO
## 191 2011     9         11         7    1906    2011            CO
## 192 2011     9         11         7    1826    1907            CO
## 193 2011     9         11         7    1858      21            CO
## 194 2011     9         11         7    2049    2203            CO
## 195 2011     9         11         7     910    1058            CO
## 196 2011     9         11         7    2111    2232            CO
## 197 2011     9         11         7    1529    1802            CO
## 198 2011     9         11         7    2050    2255            CO
## 199 2011     9         11         7    1129    1618            CO
## 200 2011     9         11         7    1554    1724            CO
## 201 2011     9         11         7    1917    2224            CO
## 202 2011     9         11         7    1733    2147            CO
## 203 2011     9         11         7    1525    1811            DL
## 204 2011     9         11         7    1729    2031            DL
## 205 2011     9         11         7     906    1150            DL
## 206 2011     9         11         7    1058    1345            DL
## 207 2011     9         11         7     919    1202            DL
## 208 2011     9         11         7    1303    1553            DL
## 209 2011     9         11         7     550     843            DL
## 210 2011     9         11         7    1605    1906            DL
## 211 2011     9         11         7     727     828            WN
## 212 2011     9         11         7    1425    1529            WN
## 213 2011     9         11         7    1735    1834            WN
## 214 2011     9         11         7    1231    1318            WN
## 215 2011     9         11         7    1658    1742            WN
## 216 2011     9         11         7    1956    2035            WN
## 217 2011     9         11         7    1516    1559            WN
## 218 2011     9         11         7    2059    2225            WN
## 219 2011     9         11         7    1530    1715            WN
## 220 2011     9         11         7    1312    1502            WN
## 221 2011     9         11         7    1033    1219            WN
## 222 2011     9         11         7    2052     107            WN
## 223 2011     9         11         7    1740    2125            WN
## 224 2011     9         11         7     654    1041            WN
## 225 2011     9         11         7    1108    1428            WN
## 226 2011     9         11         7    1425    1510            WN
## 227 2011     9         11         7    2001    2046            WN
## 228 2011     9         11         7    1644    1724            WN
## 229 2011     9         11         7     956    1049            WN
## 230 2011     9         11         7    1200    1252            WN
## 231 2011     9         11         7    1309    1400            WN
## 232 2011     9         11         7    1339    1434            WN
## 233 2011     9         11         7    1456    1554            WN
## 234 2011     9         11         7    1606    1701            WN
## 235 2011     9         11         7    1646    1735            WN
## 236 2011     9         11         7    1658    1748            WN
## 237 2011     9         11         7    1731    1819            WN
## 238 2011     9         11         7    1846    1937            WN
## 239 2011     9         11         7    1849    1939            WN
## 240 2011     9         11         7    1910    2017            WN
## 241 2011     9         11         7    2123    2213            WN
## 242 2011     9         11         7    2210    2255            WN
## 243 2011     9         11         7    2243    2330            WN
## 244 2011     9         11         7    1057    1150            WN
## 245 2011     9         11         7    1527    1618            WN
## 246 2011     9         11         7    1427    1520            WN
## 247 2011     9         11         7    1405    1454            WN
## 248 2011     9         11         7    1825    1941            WN
## 249 2011     9         11         7    1017    1133            WN
## 250 2011     9         11         7    1320    1445            WN
## 251 2011     9         11         7     706     825            WN
## 252 2011     9         11         7    1221    1351            WN
## 253 2011     9         11         7    1721    1846            WN
## 254 2011     9         11         7    1850    1937            WN
## 255 2011     9         11         7    1354    1447            WN
## 256 2011     9         11         7    1502    1917            WN
## 257 2011     9         11         7     958    1413            WN
## 258 2011     9         11         7    2126      32            WN
## 259 2011     9         11         7    1055    1403            WN
## 260 2011     9         11         7    1226    1523            WN
## 261 2011     9         11         7    1023    1118            WN
## 262 2011     9         11         7    2140    2232            WN
## 263 2011     9         11         7    1657    1752            WN
## 264 2011     9         11         7    1951    2037            WN
## 265 2011     9         11         7    1152    1245            WN
## 266 2011     9         11         7    1443    1538            WN
## 267 2011     9         11         7    1421    1523            WN
## 268 2011     9         11         7    2148    2247            WN
## 269 2011     9         11         7    1043    1335            WN
## 270 2011     9         11         7    1343    1502            WN
## 271 2011     9         11         7     559     659            WN
## 272 2011     9         11         7     832     938            WN
## 273 2011     9         11         7    1845    1946            WN
## 274 2011     9         11         7    1602    1729            WN
## 275 2011     9         11         7    1323    1447            WN
## 276 2011     9         11         7    1926    2055            WN
## 277 2011     9         11         7    1033    1139            WN
## 278 2011     9         11         7    1659    1818            WN
## 279 2011     9         11         7    1727    2032            WN
## 280 2011     9         11         7    2045    2341            WN
## 281 2011     9         11         7     809    1114            WN
## 282 2011     9         11         7    1440    1745            WN
## 283 2011     9         11         7    1039    1301            WN
## 284 2011     9         11         7    1750    2021            WN
## 285 2011     9         11         7    1930    2206            WN
## 286 2011     9         11         7    1513    1731            WN
## 287 2011     9         11         7    1557    1829            WN
## 288 2011     9         11         7    1146    1248            WN
## 289 2011     9         11         7    1659    1755            WN
## 290 2011     9         11         7    1112    1212            WN
## 291 2011     9         11         7    2053    2146            WN
## 292 2011     9         11         7    1033    1133            WN
## 293 2011     9         11         7     759     901            WN
## 294 2011     9         11         7    1525    1617            WN
## 295 2011     9         11         7    1929    2020            WN
## 296 2011     9         11         7    1249    1341            WN
## 297 2011     9         11         7    1919    2116            WN
## 298 2011     9         11         7    1252    1449            WN
## 299 2011     9         11         7     916    1029            WN
## 300 2011     9         11         7    1353    1506            WN
## 301 2011     9         11         7    1119    1233            WN
## 302 2011     9         11         7    1627    1736            WN
## 303 2011     9         11         7    1329    1808            WN
## 304 2011     9         11         7    1606    1647            WN
## 305 2011     9         11         7    1951    2026            WN
## 306 2011     9         11         7    1344    1423            WN
## 307 2011     9         11         7    1542    1659            WN
## 308 2011     9         11         7    1145    1259            WN
## 309 2011     9         11         7    2040    2124            WN
## 310 2011     9         11         7    1503    1554            WN
## 311 2011     9         11         7    1314    1400            WN
## 312 2011     9         11         7    1658    1751            WN
## 313 2011     9         11         7    1103    1300            WN
## 314 2011     9         11         7    1913    2112            WN
## 315 2011     9         11         7    1614    1807            WN
## 316 2011     9         11         7    1838    2119            WN
## 317 2011     9         11         7    1233    1529            WN
## 318 2011     9         11         7    2136      27            WN
## 319 2011     9         11         7    1137    1257            WN
## 320 2011     9         11         7    1018    1139            WN
## 321 2011     9         11         7    1622    1747            WN
## 322 2011     9         11         7     853    1100            XE
## 323 2011     9         11         7    1303    1601            XE
## 324 2011     9         11         7    1730    1922            XE
## 325 2011     9         11         7    1307    1644            XE
## 326 2011     9         11         7    1246    1537            XE
## 327 2011     9         11         7    1813    1914            XE
## 328 2011     9         11         7    1438    1554            XE
## 329 2011     9         11         7    1147    1246            XE
## 330 2011     9         11         7    1012    1309            XE
## 331 2011     9         11         7    1538    1832            XE
## 332 2011     9         11         7    1622    1921            XE
## 333 2011     9         11         7    1127    1417            XE
## 334 2011     9         11         7    2130    2223            XE
## 335 2011     9         11         7     957    1119            XE
## 336 2011     9         11         7    1729    1919            XE
## 337 2011     9         11         7    1326    1640            XE
## 338 2011     9         11         7    2105    2322            XE
## 339 2011     9         11         7    1432    1701            XE
## 340 2011     9         11         7    1342    1458            XE
## 341 2011     9         11         7    1027    1149            XE
## 342 2011     9         11         7    1314    1453            XE
## 343 2011     9         11         7    1618    1745            XE
## 344 2011     9         11         7     853    1022            XE
## 345 2011     9         11         7    1046    1407            XE
## 346 2011     9         11         7    1805    1935            XE
## 347 2011     9         11         7    1122    1224            XE
## 348 2011     9         11         7    1256    1413            XE
## 349 2011     9         11         7    1322    1655            XE
## 350 2011     9         11         7    1530    1626            XE
## 351 2011     9         11         7    1018    1134            XE
## 352 2011     9         11         7    1413    1729            XE
## 353 2011     9         11         7     847    1009            XE
## 354 2011     9         11         7    1748    1842            XE
## 355 2011     9         11         7     921    1031            XE
## 356 2011     9         11         7     927    1015            XE
## 357 2011     9         11         7    2109    2214            XE
## 358 2011     9         11         7    1736    1832            XE
## 359 2011     9         11         7    1355    1706            XE
## 360 2011     9         11         7    1621    1919            XE
## 361 2011     9         11         7    1326    1630            XE
## 362 2011     9         11         7    1303    1352            XE
## 363 2011     9         11         7    1050    1253            XE
## 364 2011     9         11         7    1417    1509            XE
## 365 2011     9         11         7    1039    1346            XE
## 366 2011     9         11         7    1128    1205            XE
## 367 2011     9         11         7    1753    1826            XE
## 368 2011     9         11         7    1622    1721            XE
## 369 2011     9         11         7     758    1124            XE
## 370 2011     9         11         7    1633    2017            XE
## 371 2011     9         11         7    1123    1245            XE
## 372 2011     9         11         7    2125    2300            XE
## 373 2011     9         11         7    2114    2205            XE
## 374 2011     9         11         7    1455    1650            XE
## 375 2011     9         11         7    1653    2015            XE
## 376 2011     9         11         7    1134    1244            XE
## 377 2011     9         11         7    1526    1735            XE
## 378 2011     9         11         7    2000    2120            XE
## 379 2011     9         11         7     911    1103            XE
## 380 2011     9         11         7    1929    2102            XE
## 381 2011     9         11         7    1950    2204            XE
## 382 2011     9         11         7    1445    1545            XE
## 383 2011     9         11         7    1557    1735            XE
## 384 2011     9         11         7    1603    1921            XE
## 385 2011     9         11         7    1259    1538            XE
## 386 2011     9         11         7    1254    1403            XE
## 387 2011     9         11         7    1520    1624            XE
## 388 2011     9         11         7    1848    2216            XE
## 389 2011     9         11         7    1414    1728            XE
## 390 2011     9         11         7    1834    1937            XE
## 391 2011     9         11         7    1757    1928            XE
## 392 2011     9         11         7    1920    2211            XE
## 393 2011     9         11         7     813    1120            XE
## 394 2011     9         11         7    1144    1348            XE
## 395 2011     9         11         7    1422    1713            XE
## 396 2011     9         11         7     910    1105            XE
## 397 2011     9         11         7    1409    1543            XE
## 398 2011     9         11         7    1018    1329            XE
## 399 2011     9         11         7     913    1019            XE
## 400 2011     9         11         7    2010    2339            XE
## 401 2011     9         11         7    1604    1741            XE
## 402 2011     9         11         7    2110    2202            XE
## 403 2011     9         11         7    1234    1425            XE
## 404 2011     9         11         7    1250    1424            XE
## 405 2011     9         11         7    2120    2255            XE
## 406 2011     9         11         7    1026    1408            XE
## 407 2011     9         11         7    1317    1650            XE
## 408 2011     9         11         7    1857    2216            XE
## 409 2011     9         11         7    1914    2044            XE
## 410 2011     9         11         7    1927    2244            XE
## 411 2011     9         11         7    1759    1932            XE
## 412 2011     9         11         7    1954    2146            XE
## 413 2011     9         11         7    1037    1348            XE
## 414 2011     9         11         7    1849    2106            XE
## 415 2011     9         11         7    2001    2203            XE
## 416 2011     9         11         7     855    1054            XE
## 417 2011     9         11         7    1802    1945            XE
## 418 2011     9         11         7    1645    1801            XE
## 419 2011     9         11         7    1413    1721            XE
## 420 2011     9         11         7    1416    1512            XE
## 421 2011     9         11         7    1316    1402            XE
## 422 2011     9         11         7    1910    1958            XE
## 423 2011     9         11         7    1035    1405            XE
## 424 2011     9         11         7    1416    1541            XE
## 425 2011     9         11         7    1331    1651            XE
## 426 2011     9         11         7    1122    1255            XE
## 427 2011     9         11         7     817    1105            XE
## 428 2011     9         11         7    1302    1355            XE
## 429 2011     9         11         7     721     920            XE
## 430 2011     9         11         7    1118    1356            XE
## 431 2011     9         11         7    1545    1633            XE
## 432 2011     9         11         7    1054    1214            XE
## 433 2011     9         11         7    1755    1847            XE
## 434 2011     9         11         7    2259    2346            XE
## 435 2011     9         11         7     854     959            XE
## 436 2011     9         11         7    1255    1424            XE
## 437 2011     9         11         7     929    1019            XE
## 438 2011     9         11         7    1049    1156            XE
## 439 2011     9         11         7    1854    1942            XE
## 440 2011     9         11         7     904    1038            XE
## 441 2011     9         11         7    1539    1657            XE
## 442 2011     9         11         7    1637    1752            XE
## 443 2011     9         11         7    1955    2230            XE
## 444 2011     9         11         7    1418    1711            XE
## 445 2011     9         11         7    1527    1713            XE
## 446 2011     9         11         7    1615    1825            XE
## 447 2011     9         11         7    1915    2007            XE
## 448 2011     9         11         7    1039    1146            XE
## 449 2011     9         11         7    1609    1738            XE
## 450 2011     9         11         7    1630    1939            XE
## 451 2011     9         11         7    1708    2032            XE
## 452 2011     9         11         7    2102    2207            XE
## 453 2011     9         11         7     959    1132            XE
## 454 2011     9         11         7    1631    1952            XE
## 455 2011     9         11         7    1634    1806            XE
## 456 2011     9         11         7    2005    2324            XE
## 457 2011     9         11         7    1540    1635            XE
## 458 2011     9         11         7    1122    1308            XE
## 459 2011     9         11         7    1005    1122            XE
## 460 2011     9         11         7    1908    2221            XE
## 461 2011     9         11         7    1150    1254            XE
## 462 2011     9         11         7    2253    2349            XE
## 463 2011     9         11         7    1953    2142            XE
## 464 2011     9         11         7    1554    1847            XE
## 465 2011     9         11         7    1102    1131            XE
## 466 2011     9         11         7    1140    1349            XE
## 467 2011     9         11         7    1242    1357            XE
## 468 2011     9         11         7    1127    1229            XE
## 469 2011     9         11         7    1045    1136            XE
## 470 2011     9         11         7    2110    2215            XE
## 471 2011     9         11         7    1928    2219            XE
## 472 2011     9         11         7    2012    2126            XE
## 473 2011     9         11         7    1808    1937            XE
## 474 2011     9         11         7    1008    1119            XE
## 475 2011     9         11         7    2005    2115            XE
## 476 2011     9         11         7    1915    2027            XE
## 477 2011     9         11         7    1042    1144            XE
## 478 2011     9         11         7    1800    1905            XE
## 479 2011     9         11         7    1813    2126            XE
## 480 2011     9         11         7    1027    1403            XE
## 481 2011     9         11         7    1634    1809            XE
## 482 2011     9         11         7    1125    1440            XE
## 483 2011     9         11         7    1847    1942            XE
## 484 2011     9         11         7    2102    2157            XE
## 485 2011     9         11         7    1647    1759            XE
## 486 2011     9         11         7    1345    1700            XE
## 487 2011     9         11         7    1259    1417            XE
## 488 2011     9         11         7    1357    1705            XE
## 489 2011     9         11         7    1739    1914            XE
## 490 2011     9         11         7    1302    1431            XE
## 491 2011     9         11         7    1602    1728            XE
## 492 2011     9         11         7    1326    1709            XE
## 493 2011     9         11         7     930    1023            XE
## 494 2011     9         11         7    1448    1547            XE
## 495 2011     9         11         7    2100    2151            XE
## 496 2011     9         11         7    1343    1659            XE
## 497 2011     9         11         7    1916    2008            XE
## 498 2011     9         11         7    1315    1442            XE
## 499 2011     9         11         7    1408    1707            XE
## 500 2011     9         11         7    1532    1635            XE
## 501 2011     9         11         7     925    1012            XE
## 502 2011     9         11         7    2013    2148            XE
## 503 2011     9         11         7    1451    1613            XE
## 504 2011     9         11         7    1733    1824            XE
## 505 2011     9         11         7    1434    1526            XE
## 506 2011     9         11         7    2051    2206            XE
## 507 2011     9         11         7    2008    2301            XE
## 508 2011     9         11         7    1115    1249            XE
## 509 2011     9         11         7    1645    2033            EV
## 510 2011     9         11         7    1228    1353            EV
## 511 2011     9         11         7    1631    1806            EV
## 512 2011     9         11         7     913    1259            EV
## 513 2011     9         11         7    1249    1652            EV
## 514 2011     9         11         7    1856    2013            F9
## 515 2011     9         11         7    1149    1307            F9
## 516 2011     9         11         7     630     910            FL
## 517 2011     9         11         7    1313    1558            FL
## 518 2011     9         11         7    1359    1642            FL
## 519 2011     9         11         7    1556    1836            FL
## 520 2011     9         11         7    1953    2235            FL
## 521 2011     9         11         7    1027    1148            FL
## 522 2011     9         11         7    1825    1931            MQ
## 523 2011     9         11         7    1029    1140            MQ
## 524 2011     9         11         7     912    1021            MQ
## 525 2011     9         11         7    1144    1251            MQ
## 526 2011     9         11         7    1927    2035            MQ
## 527 2011     9         11         7    1449    1558            MQ
## 528 2011     9         11         7    1841    2108            MQ
## 529 2011     9         11         7    1244    1356            MQ
## 530 2011     9         11         7    2112    2229            MQ
## 531 2011     9         11         7     800     934            MQ
## 532 2011     9         11         7    1547    1815            MQ
## 533 2011     9         11         7    1108    1329            MQ
## 534 2011     9         11         7     643     913            MQ
## 535 2011     9         11         7    1728    1759            OO
## 536 2011     9         11         7    1453    1600            OO
## 537 2011     9         11         7     726    1112            OO
## 538 2011     9         11         7    1156    1317            OO
## 539 2011     9         11         7    1859    2132            OO
## 540 2011     9         11         7     943    1113            OO
## 541 2011     9         11         7    1859    2243            OO
## 542 2011     9         11         7    1449    1551            OO
## 543 2011     9         11         7    1343    1535            OO
## 544 2011     9         11         7    1421    1629            OO
## 545 2011     9         11         7    1935    2050            OO
## 546 2011     9         11         7    1251    1536            OO
## 547 2011     9         11         7    2048    2119            OO
## 548 2011     9         11         7    1810    2023            OO
## 549 2011     9         11         7    1727    1833            OO
## 550 2011     9         11         7    2144    2249            OO
## 551 2011     9         11         7     853     922            OO
## 552 2011     9         11         7    1123    1212            OO
## 553 2011     9         11         7     914    1029            OO
## 554 2011     9         11         7    1053    1449            OO
## 555 2011     9         11         7    2113    2308            OO
## 556 2011     9         11         7     857    1011            OO
## 557 2011     9         11         7    1906    2242            OO
## 558 2011     9         11         7    2057    2224            OO
## 559 2011     9         11         7    2139    2235            OO
## 560 2011     9         11         7     904     951            OO
## 561 2011     9         11         7    1021    1345            OO
## 562 2011     9         11         7    1649    1951            OO
## 563 2011     9         11         7     958    1105            OO
## 564 2011     9         11         7    1906    2248            OO
## 565 2011     9         11         7    1537    1736            OO
## 566 2011     9         11         7    1446    1606            OO
## 567 2011     9         11         7    1844    2046            OO
## 568 2011     9         11         7    1017    1328            OO
## 569 2011     9         11         7    1744    1848            OO
## 570 2011     9         11         7    1129    1347            OO
## 571 2011     9         11         7    1445    1750            OO
## 572 2011     9         11         7    1254    1504            OO
## 573 2011     9         11         7     656     902            OO
## 574 2011     9         11         7    1744    2040            OO
## 575 2011     9         11         7    1008    1305            OO
## 576 2011     9         11         7    1129    1431            OO
## 577 2011     9         11         7    1150    1241            OO
## 578 2011     9         11         7    2308    2353            OO
## 579 2011     9         11         7    1739    1853            OO
## 580 2011     9         11         7    1735    1836            OO
## 581 2011     9         11         7    1946    2044            OO
## 582 2011     9         11         7    1427    1530            OO
## 583 2011     9         11         7    1521    1612            OO
## 584 2011     9         11         7     555     821            OO
## 585 2011     9         11         7    1735    2003            UA
## 586 2011     9         11         7     748    1007            UA
## 587 2011     9         11         7    1400    1738            UA
## 588 2011     9         11         7    1253    1432            UA
## 589 2011     9         11         7     908    1111            UA
## 590 2011     9         11         7     556     634            US
## 591 2011     9         11         7    1454    1542            US
## 592 2011     9         11         7    1810    1859            US
## 593 2011     9         11         7     817     914            US
## 594 2011     9         11         7    1020    1341            US
## 595 2011     9         11         7     842    1155            US
## 596 2011     9         11         7    1739    2048            US
## 597 2011     9         11         7     701    1031            US
## 598 2011     9         11         7    1347    1700            US
## 599 2011     9         11         7     757    1152            US
## 600 2011     9         11         7    1309    1730            US
## 601 2011     9         11         7    1753    2206            US
## 602 2011     9         11         7    1519    1838            US
##     FlightNum TailNum ActualElapsedTime AirTime ArrDelay DepDelay Origin
## 1         458  N559AA                65      40      -14       -4    IAH
## 2         466  N3EGAA               133     115      -16       -9    IAH
## 3         657  N498AA                60      40      -19       -4    IAH
## 4         742  N470AA                66      43        9       18    IAH
## 5        1294  N3BVAA               130     118      -20       -5    IAH
## 6        1848  N598AA                76      40       -2       -3    IAH
## 7        1946  N3FXAA               147     118       -7       -9    IAH
## 8        1948  N591AA                63      42      -20       -8    IAH
## 9        1995  N544AA                65      40      -12       -2    IAH
## 10        731  N535AS               258     239      -23       -7    IAH
## 11        620  N552JB               186     168      -25       -9    HOU
## 12        622  N658JB               186     161      -44      -14    HOU
## 13          1  N69063               486     468       -4       10    IAH
## 14          5  N11612                62      42      -14      -10    IAH
## 15          6  N16646                61      37        0       -5    IAH
## 16         33  N37434                65      42        2        4    IAH
## 17         35  N31412                53      26        5        3    IAH
## 18         47  N75853               213     185       15       18    IAH
## 19         52  N19136               219     186        4       -1    IAH
## 20         59  N38257               147     118        3        4    IAH
## 21         60  N14230               201     175       -7        2    IAH
## 22         62  N17122               192     165      124      143    IAH
## 23         89  N87507               193     168       -3       -1    IAH
## 24        106  N66051               213     189       11        2    IAH
## 25        128  N37408                60      45       -8       -1    IAH
## 26       1006  N73270               146     128       -2        0    IAH
## 27       1008  N73299               211     182       -7       -1    IAH
## 28       1010  N29717               158     140      -19       -6    IAH
## 29       1011  N77431               221     189        8       -2    IAH
## 30       1018  N57855               163     134       35       15    IAH
## 31       1019  N37419               140     117       -9       -1    IAH
## 32       1023  N37419               160     121       24        4    IAH
## 33       1029  N16646                83      51        3      -10    IAH
## 34       1031  N16732               146     123       -2        0    IAH
## 35       1033  N27205               243     219        5        7    IAH
## 36       1036  N33264               275     239       37       28    IAH
## 37       1045  N77871               199     175       12       10    IAH
## 38       1047  N23721                58      35        0       -5    IAH
## 39       1048  N13248               253     221        1       -1    IAH
## 40       1071  N57869               452     432       49       18    IAH
## 41       1085  N76503               157     142       60       56    IAH
## 42       1086  N24212               189     163      -20       -1    IAH
## 43       1087  N37408               202     179      -23        0    IAH
## 44       1089  N75854               135     109       -1        1    IAH
## 45       1097  N18220               207     185      -10       -1    IAH
## 46       1101  N13624                63      28       -1       -6    IAH
## 47       1104  N73860               261     238        1       -2    IAH
## 48       1125  N76504               188     170        1       -1    IAH
## 49       1128  N37253               118      97      -10       -1    IAH
## 50       1131  N33292               207     182       -9        0    IAH
## 51       1133  N14731               159     143      -20       -3    IAH
## 52       1134  N16642               119      91      -15       -8    IAH
## 53       1136  N16217               181     166      -37       -6    IAH
## 54       1139  N34282               185     166       -3       11    IAH
## 55       1159  N14604                74      42        1       -3    IAH
## 56       1166  N77430               254     234        4       -2    IAH
## 57       1177  N57870               128     108       -3        0    IAH
## 58       1183  N76508               213     187      -13       -5    IAH
## 59       1185  N76265               204     178       11        9    IAH
## 60       1190  N76269               130     115       15       27    IAH
## 61       1195  N14645               134     112       59       61    IAH
## 62       1196  N37277               162     143      -17       -3    IAH
## 63       1201  N57857               189     164       -4       -1    IAH
## 64       1204  N77520                57      35       25       26    IAH
## 65       1215  N14613                55      30      -10       -7    IAH
## 66       1231  N33289               201     176        1        0    IAH
## 67       1232  N36272                53      28       -3        2    IAH
## 68       1233  N76519                46      28       -8       -2    IAH
## 69       1234  N37434                56      30        1       -4    IAH
## 70       1235  N16703               161     142       42       44    IAH
## 71       1237  N33203               137     121      -10       -4    IAH
## 72       1239  N78511               129      95        6       -1    IAH
## 73       1241  N75426               207     169        1       -3    IAH
## 74       1242  N17244                63      45        6        6    IAH
## 75       1243  N73278               186     160       -3        2    IAH
## 76       1244  N14645               161     141       -6       -6    IAH
## 77       1246  N76505               119     100      -12        0    IAH
## 78       1247  N45440                54      33        0        3    IAH
## 79       1248  N32404               236     218       14       18    IAH
## 80       1249  N14228               244     221       -7       -1    IAH
## 81       1250  N27733               215     191        0        0    IAH
## 82       1251  N76528               205     183        0        1    IAH
## 83       1254  N68061               197     171       -5       -1    IAH
## 84       1258  N14219               224     209        0       22    IAH
## 85       1259  N79402               182     159      -20       -5    IAH
## 86       1261  N33284               190     170      -13        0    IAH
## 87       1264  N39415               246     217        5        9    IAH
## 88       1266  N75410               134     115      -16       -5    IAH
## 89       1268  N73278               138     116        3        6    IAH
## 90       1272  N75432               163     143       -7       -3    IAH
## 91       1276  N37409                65      46       -2       -5    IAH
## 92       1284  N37255               161     146        0       -6    IAH
## 93       1294  N34222               262     239       -5       -1    IAH
## 94       1299  N57857               251     218       -6       -2    IAH
## 95       1400  N33262               188     167      -16       -4    IAH
## 96       1403  N76515               151     131      125      121    IAH
## 97       1406  N72405               218     200       -1       -5    IAH
## 98       1408  N24702               145     123       -8       -5    IAH
## 99       1409  N30401               189     163       -3       -2    IAH
## 100      1411  N15710               151     127      -10       -5    IAH
## 101      1414  N16642               189     164      -25       -8    IAH
## 102      1417  N29717               153     130       -1       -2    IAH
## 103      1423  N76528               180     129       22       -1    IAH
## 104      1427  N75435               185     158      -11       -3    IAH
## 105      1430  N75854               144     118        6        1    IAH
## 106      1431  N77019               194     165      -16        1    IAH
## 107      1432  N75410               243     218       -9       -6    IAH
## 108      1434  N27213               229     202       -9       -2    IAH
## 109      1435  N37409               173     146       23       17    IAH
## 110      1437  N37287               234     218       17       26    IAH
## 111      1439  N24633               183     152        7       -4    IAH
## 112      1442  N16709                62      47      -11        2    IAH
## 113      1454  N23708               113      98      -18       -3    IAH
## 114      1459  N37273               170     148        2        4    IAH
## 115      1460  N36280               152     127        1        2    IAH
## 116      1467  N12221               257     233       -9       -1    IAH
## 117      1468  N31412               254     232      -15        6    IAH
## 118      1472  N14242               256     220       15        3    IAH
## 119      1474  N79402               161     142       -5       -4    IAH
## 120      1476  N38403               208     185       11        0    IAH
## 121      1477  N76514               134     115      -16       -7    IAH
## 122      1478  N15712               164     143      -14        0    IAH
## 123      1483  N75851               190     158       -2       -2    IAH
## 124      1492  N37413               258     234       -3        9    IAH
## 125      1495  N87512               253     227       -9        4    IAH
## 126      1497  N76502                64      42       -6       -3    IAH
## 127      1498  N37263               224     199       27        2    IAH
## 128      1499  N17133               210     187       -3       -3    IAH
## 129      1501  N45440               140     119       -5       -2    IAH
## 130      1503  N14214               157     136        4       -4    IAH
## 131      1516  N13718               141     124      -12       -5    IAH
## 132      1519  N13624                66      41      -14       -6    IAH
## 133      1523  N12218               257     232       19       30    IAH
## 134      1529  N14628                61      35       -2       -7    IAH
## 135      1533  N24224                NA      NA       NA       -1    IAH
## 136      1539  N53442               255     234       -7       -3    IAH
## 137      1541  N17730               156     139      -16       -1    IAH
## 138      1546  N14106               199     173      -13        3    IAH
## 139      1548  N23708               203     181      -13       -3    IAH
## 140      1551  N13750               159     140       -6       -3    IAH
## 141      1552  N23721               178     143        8       -3    IAH
## 142      1558  N39726               166     146        6       -3    IAH
## 143      1559  N16701               164     135        7        6    IAH
## 144      1560  N16617               221     193       25       -1    IAH
## 145      1562  N76254               181     160      -16        1    IAH
## 146      1563  N87513               208     186       -3        0    IAH
## 147      1566  N57870               202     181      -11        3    IAH
## 148      1574  N12218               214     190        3       -1    IAH
## 149      1575  N17620               114      91       -8        3    IAH
## 150      1576  N24212                60      42       -8       -1    IAH
## 151      1583  N16648                51      27      -17      -10    IAH
## 152      1585  N78511               146     125       -1       -3    IAH
## 153      1586  N71411               121     106      -13       -3    IAH
## 154      1589  N77518               166     141        6       16    IAH
## 155      1590  N14604               140     120        1        5    IAH
## 156      1591  N33289               163     140        2        6    IAH
## 157      1597  N33292               203     179       -6       -2    IAH
## 158      1598  N73256               119      84        9       14    IAH
## 159      1599  N14629               144     122       -9        0    IAH
## 160      1603  N18223                51      29       -2        0    IAH
## 161      1606  N26215               144     127        0       -1    IAH
## 162      1614  N77871               129     109       -5        0    IAH
## 163      1615  N27724               168     147      -24       -1    IAH
## 164      1616  N76502               146     127      -10       -3    IAH
## 165      1619  N72405               127     110       -5        5    IAH
## 166      1620  N71411               166     141        5        0    IAH
## 167      1621  N17244               271     247        0        1    IAH
## 168      1629  N21723               214     182       -6       -7    IAH
## 169      1638  N39297               158     130       12       -1    IAH
## 170      1639  N33714                55      37        9       11    IAH
## 171      1644  N76254               232     209       -5        7    IAH
## 172      1646  N77261                55      36       -8       -4    IAH
## 173      1648  N17730               159     143      -12       -6    IAH
## 174      1649  N38257               212     189        4       -4    IAH
## 175      1650  N16648               137     112        7       14    IAH
## 176      1654  N39297               164     142        6       -1    IAH
## 177      1656  N27733               120      99        2        2    IAH
## 178      1657  N73283               214     191        6        3    IAH
## 179      1658  N73256               184     155       10       20    IAH
## 180      1661  N87531               159     136      -27       -6    IAH
## 181      1675  N76516               182     165      -30      -10    IAH
## 182      1676  N30401               187     156      -12        2    IAH
## 183      1677  N76505               213     196       12       21    IAH
## 184      1680  N76288               190     169      -20        3    IAH
## 185      1688  N11641               188     154        3      -13    IAH
## 186      1689  N38443               195     176       -7       -5    IAH
## 187      1690  N18622               144     112       33       31    IAH
## 188      1693  N16709               112      90      -13        4    IAH
## 189      1704  N18243               190     168      -12        3    IAH
## 190      1705  N14604                70      50       -9       -4    IAH
## 191      1706  N37298                65      43        0        1    IAH
## 192      1707  N37422               161     139       20       31    IAH
## 193      1710  N73259               263     199      204      118    IAH
## 194      1712  N75851               134     109      -16       -6    IAH
## 195      1714  N76514               228     208      -12        0    IAH
## 196      1717  N14242               201     177       -3        1    IAH
## 197      1718  N37290               153     132       -4       -1    IAH
## 198      1721  N16701               185     169       -5       -5    IAH
## 199      1731  N77295               229     181       57       -1    IAH
## 200      1733  N78524               210     186      -11       -1    IAH
## 201      1738  N32404               127     101        6        2    IAH
## 202      1744  N76516               194     169      -15       -3    IAH
## 203         8  N357NB               106      90      -21        0    IAH
## 204        54  N945DL               122      89       -9       -4    IAH
## 205      1160  N973DL               104      87      -19        0    HOU
## 206      1556  N979DL               107      85      -12        2    IAH
## 207      1590  N976DL               103      86      -23       -5    IAH
## 208      1675  N986DL               110      88       -9        3    IAH
## 209      1884  N914DL               113      86      -21       -5    IAH
## 210      1958  N939DL               121      87      -10       -5    HOU
## 211       421  N466WN               121     111       -7       -3    HOU
## 212      1574  N650SW               124     109        4        5    HOU
## 213      2192  N462WN               119     110        9       15    HOU
## 214       889  N404WN                47      29        3        1    HOU
## 215      1754  N344SW                44      28       -3       -2    HOU
## 216      1959  N688SW                39      28      -15        6    HOU
## 217      2363  N526SW                43      30       -6       -4    HOU
## 218       879  N619SW                86      75      -10       19    HOU
## 219        31  N708SW               105      92      -10        0    HOU
## 220       779  N780SW               110      93        2        2    HOU
## 221      2023  N493WN               106      88      -11       -2    HOU
## 222        47  N724SW               195     178       77       77    HOU
## 223      1687  N799SW               165     153      205      220    HOU
## 224      3579  N511SW               167     153      -19       -1    HOU
## 225      1699  N266WN               140     107       -2       -2    HOU
## 226        27  N612SW                45      31       -5        0    HOU
## 227        49  N235WN                45      32        1        6    HOU
## 228       243  N385SW                40      31        9       24    HOU
## 229        16  N258WN                53      42       -6       -4    HOU
## 230        24  N334SW                52      40       -8        0    HOU
## 231        28  N641SW                51      41        5        9    HOU
## 232        30  N724SW                55      42        4        9    HOU
## 233        36  N683SW                58      40       -6       -4    HOU
## 234        40  N379SW                55      41        1        6    HOU
## 235        42  N230WN                49      39        5       16    HOU
## 236        44  N612SW                50      40      -12       -2    HOU
## 237        46  N652SW                48      40      -11        1    HOU
## 238        48  N456WN                51      41       37       46    HOU
## 239        50  N482WN                50      41        9       19    HOU
## 240        52  N385SW                67      39       17       10    HOU
## 241        56  N452WN                50      38       63       83    HOU
## 242        58  N743SW                45      36       80      100    HOU
## 243        60  N397SW                47      37       95      103    HOU
## 244       290  N504SW                53      41       -5       -3    HOU
## 245       332  N203WN                51      42      -12       -3    HOU
## 246       833  N949WN                53      40      -10       -3    HOU
## 247      1383  N626SW                49      40       -1        5    HOU
## 248       417  N700GS               136     124        1       15    HOU
## 249      1169  N460WN               136     123       -7       -3    HOU
## 250      1371  N347SW               145     128       -5       -5    HOU
## 251      2046  N900WN               139     125       -5       -4    HOU
## 252        19  N230WN                90      74       -9       -4    HOU
## 253        35  N647SW                85      71       41       51    HOU
## 254      1300  N361SW               107      98      107      110    HOU
## 255      3059  N369SW               113     101        2       -1    HOU
## 256      2347  N732SW               195     177       -8        2    HOU
## 257      2795  N777QC               195     177      -17       -2    HOU
## 258        45  N758SW               126     115      112      141    HOU
## 259      3513  N492WN               128     116      -22       -5    HOU
## 260       261  N479WN               117     105      -17       -4    HOU
## 261         9  N344SW                55      43       -2       -2    HOU
## 262        55  N959WN                52      40       -3       15    HOU
## 263      1599  N551WN                55      43       -3       -3    HOU
## 264      2076  N415WN                46      39      -13       11    HOU
## 265      2100  N683SW                53      43       -5       -3    HOU
## 266      3254  N652SW                55      43       -2       -2    HOU
## 267      3068  N684WN                62      51       -2        6    HOU
## 268      3309  N432WN                59      50       47       68    HOU
## 269       473  N625SW               112      99       -5        8    HOU
## 270       149  N279WN               199     189        7       -2    HOU
## 271       526  N486WN               180     171       -6       -1    HOU
## 272       704  N794SW               186     172       -7       -8    HOU
## 273       794  N775SW               181     171        6       10    HOU
## 274       113  N509SW               207     192        4        2    HOU
## 275       913  N465WN               204     191        2        3    HOU
## 276      2313  N292WN               209     190       35       36    HOU
## 277       105  N268WN                66      54      -11       -2    HOU
## 278      1926  N619SW                79      66       -2       -1    HOU
## 279        39  N639SW               125     111      -33       -3    HOU
## 280        51  N652SW               116     105      -24        5    HOU
## 281      1490  N327SW               125     114      -11        4    HOU
## 282      1741  N644SW               125     112       80       95    HOU
## 283      1106  N753SW               142     129        1        4    HOU
## 284      1186  N473WN               151     140        6        0    HOU
## 285      2170  N523SW               156     137       11       10    HOU
## 286      2191  N411WN               138     126       41       48    HOU
## 287      2525  N712SW               152     133        4       -3    HOU
## 288        18  N732SW                62      45       -7       -4    HOU
## 289        37  N317WN                56      43        0        4    HOU
## 290       465  N650SW                60      45       -3       -3    HOU
## 291       837  N718SW                53      43        1       13    HOU
## 292      1707  N389SW                60      45       -7       -2    HOU
## 293      2177  N646SW                62      48        1       -1    HOU
## 294      2210  N775SW                52      41       -8        0    HOU
## 295      2353  N290WN                51      41        0        9    HOU
## 296      3940  N509SW                52      42      -14       -1    HOU
## 297      2062  N770SA               237     220        1        4    HOU
## 298      2112  N918WN               237     221       -1        2    HOU
## 299         5  N509SW                73      65       -6       -4    HOU
## 300       651  N634SW                73      64       16       18    HOU
## 301      1466  N637SW                74      61       -2       -1    HOU
## 302      2908  N415WN                69      60        1        7    HOU
## 303        23  N367SW               219     177       18       -1    HOU
## 304       262  N243WN               161     144       -8       -4    HOU
## 305      1407  N287WN               155     144       41       51    HOU
## 306      2288  N943WN               159     149        8        9    HOU
## 307       950  N263WN               197     184        4       -3    HOU
## 308      1387  N939WN               194     181       -1        0    HOU
## 309       104  N334SW                44      34       19       25    HOU
## 310       277  N658SW                51      36       -1       -2    HOU
## 311       577  N687SW                46      35       10       14    HOU
## 312      1080  N346SW                53      35        1       -2    HOU
## 313      1317  N619SW               117     106       -5       -2    HOU
## 314      1390  N658SW               119     104      -13        3    HOU
## 315      2082  N326SW               113     101       12       19    HOU
## 316        43  N268WN               101      92      -26        8    HOU
## 317       214  N234WN               116      98      -11       -2    HOU
## 318      1771  N605SW               111      98       42       56    HOU
## 319      1270  N526SW                80      69       -3       -3    HOU
## 320      1326  N423WN                81      68       -1       -2    HOU
## 321      1665  N331SW                85      67       22       22    HOU
## 322      2101  N16112               127     111       -2       -7    IAH
## 323      2102  N13964               118     102      -17       -7    IAH
## 324      2103  N12946               112      94       -6       -5    IAH
## 325      2105  N14171               157     138       17       12    IAH
## 326      2107  N14573               111      95      -15       -4    IAH
## 327      2109  N17560                61      45      -13       -7    IAH
## 328      2110  N33182               136     113       -4       -2    IAH
## 329      2117  N14938                59      39        6       -3    IAH
## 330      2120  N13914               117      99       -6       -3    IAH
## 331      2122  N12175               174     152        8        3    IAH
## 332      2128  N12172               119      96       -1        2    IAH
## 333      2130  N34111               170     144        8       -3    IAH
## 334      2131  N13538                53      37        8       10    IAH
## 335      2132  N13936                82      68       -3       -8    IAH
## 336      2133  N13202               110      93        1       -1    IAH
## 337      2135  N16954               134     116        3        1    IAH
## 338      2146  N33182               137     110        2      -10    IAH
## 339      2147  N11109               149     128       11       -8    IAH
## 340      2151  N13979                76      60      -14       -6    IAH
## 341      2152  N14188                82      63       22       22    IAH
## 342      2159  N12946                99      71       16        9    IAH
## 343      2162  N14993                87      66       11        8    IAH
## 344      2163  N14933                89      68        5       -2    IAH
## 345      2164  N14953               141     121       18        6    IAH
## 346      2165  N14938                90      70      -12      -10    IAH
## 347      2171  N14937                62      45       -6       -8    IAH
## 348      2174  N21537                77      64      -19       -9    IAH
## 349      2182  N11119               153     134      -22       -3    IAH
## 350      2185  N14937                56      38       -6       -5    IAH
## 351      2195  N14930                76      56       14       13    IAH
## 352      2198  N14168               136     122       -6       -2    IAH
## 353      2203  N12934                82      68       -3       -3    IAH
## 354      2205  N14930                54      36        7        8    IAH
## 355      2207  N12540                70      46        1       -9    IAH
## 356      2208  N15941                48      37      -20       -8    IAH
## 357      2209  N16571                65      49       -8       -6    IAH
## 358      2212  N14945                56      40        2        6    IAH
## 359      2214  N14174               131     116      -12       -5    IAH
## 360      2216  N12900               118      95       -4       -4    IAH
## 361      2222  N15910               124     102      -10       -9    IAH
## 362      2223  N13935                49      35        5       13    IAH
## 363      2225  N17560               123     103        6       -5    IAH
## 364      2229  N14930                52      38       -4        2    IAH
## 365      2230  N13929               127     113       -7       -6    IAH
## 366      2231  N12160               157     135       12        3    IAH
## 367      2235  N12145                93      78      -22       -7    IAH
## 368      2236  N13929                59      40       47       52    IAH
## 369      2240  N11181               146     127       -5       -2    IAH
## 370      2243  N14953               164     139        5       -2    IAH
## 371      2253  N16976                82      66       -4       -2    IAH
## 372      2258  N16951                95      73       83       85    IAH
## 373      2261  N48901                51      34       -2       -6    IAH
## 374      2274  N18102               115      95        0        2    IAH
## 375      2276  N13118               142     124       -5       -7    IAH
## 376      2277  N14993                70      49        2       -6    IAH
## 377      2278  N48901               129     112        2        1    IAH
## 378      2280  N11181                80      67       -7        0    IAH
## 379      2281  N12996               112      87        1       -4    IAH
## 380      2283  N13968                93      77       -6       -1    IAH
## 381      2288  N16147               134     120       -1       -5    IAH
## 382      2290  N14945                60      38       23       20    IAH
## 383      2292  N14902                98      78       -5       -8    IAH
## 384      2298  N11199               138     116       42       38    IAH
## 385      2300  N12921               159     140       -1       -6    IAH
## 386      2304  N14939                69      56      -12       -6    IAH
## 387      2308  N31131                64      46       -8       -5    IAH
## 388      2316  N31131               148     132      -18       -2    IAH
## 389      2317  N11113               134     118      -17       -6    IAH
## 390      2326  N14558                63      48       22       29    IAH
## 391      2330  N17928                91      74       -9       -3    IAH
## 392      2331  N16999               111      97       -9        0    IAH
## 393      2332  N16147               127     107       12       28    IAH
## 394      2333  N11106               124     100       16       -1    IAH
## 395      2334  N11181               111     100      -10        2    IAH
## 396      2335  N14562               115      97        1       -5    IAH
## 397      2336  N14940                94      79       -7       -4    IAH
## 398      2340  N14902               131     110       -3       -2    IAH
## 399      2342  N13935                66      41       -4       -7    IAH
## 400      2344  N24103               149     132       27       35    IAH
## 401      2346  N14204                97      80       -8       -1    IAH
## 402      2349  N11113               112      92      -12      -10    IAH
## 403      2355  N13975               111      93       -2       -5    IAH
## 404      2356  N16999                94      76       -5       -5    IAH
## 405      2357  N17138                95      78        0        0    IAH
## 406      2359  N16183               162     131       10        1    IAH
## 407      2360  N16178               153     136       18       17    IAH
## 408      2364  N12135               139     113      -11       -3    IAH
## 409      2369  N13929                90      72       21       19    IAH
## 410      2375  N14158               137     120       -8       -8    IAH
## 411      2376  N14939                93      78      -13       -6    IAH
## 412      2385  N14562               112      95       -4       -1    IAH
## 413      2386  N12135               131     118      -19       -8    IAH
## 414      2388  N13979               137     116        1       -6    IAH
## 415      2394  N13161               122     108       -9       -4    IAH
## 416      2399  N11187               179     150        9      -10    IAH
## 417      2400  N17196               163     137       -5       -8    IAH
## 418      2404  N11127                76      64        6       18    IAH
## 419      2405  N16147               128     112       -1       -2    IAH
## 420      2406  N17928                56      40       -8       -4    IAH
## 421      2407  N14942                46      34       55       61    IAH
## 422      2418  N12540                48      26      -12      -10    IAH
## 423      2420  N13118               150     135        3        0    IAH
## 424      2427  N14943                85      68       -3        1    IAH
## 425      2428  N14974               140     121       -4       -4    IAH
## 426      2433  N15948                93      71        7       -3    IAH
## 427      2435  N13949               108      96      -18       -6    IAH
## 428      2436  N12145               113      95      -12       -8    IAH
## 429      2437  N13978               119     101       -5       -4    IAH
## 430      2439  N11539               158     142        9       -2    IAH
## 431      2442  N13935                48      34       -5        0    IAH
## 432      2445  N11109                80      58       59       49    IAH
## 433      2446  N11194               112      92       -8       -5    IAH
## 434      2450  N15948                47      37       -8       -6    IAH
## 435      2453  N13964                65      47       -9      -11    IAH
## 436      2456  N14933                89      67      -10       -5    IAH
## 437      2458  N14943                50      32       -3       -6    IAH
## 438      2461  N14945                67      51       -1       -1    IAH
## 439      2462  N13992                48      33        0        4    IAH
## 440      2464  N18102               154     136       11        4    IAH
## 441      2465  N14158                78      61       -8       -1    IAH
## 442      2467  N15941                75      52        3        2    IAH
## 443      2468  N16178               155     140       10       20    IAH
## 444      2472  N13970               113      99       -9       -2    IAH
## 445      2474  N15572               106      91      -11       -3    IAH
## 446      2479  N16919               130     115      125      125    IAH
## 447      2481  N14937                52      36      -11       -5    IAH
## 448      2482  N16919                67      51       -7       -6    IAH
## 449      2485  N15926                89      72       -1        4    IAH
## 450      2488  N14960               129     111      -20       -5    IAH
## 451      2492  N13949               144     128       70       83    IAH
## 452      2493  N15926                65      50      -16      -13    IAH
## 453      2495  N48901                93      76       -8       -6    IAH
## 454      2496  N14998               141     114        7       -4    IAH
## 455      2497  N16944                92      78       54       65    IAH
## 456      2500  N18102               139     103       26       15    IAH
## 457      2509  N23139                55      35       -5       -5    IAH
## 458      4565  N15572               106      77       13       -3    IAH
## 459      4570  N13970                77      64       -7       -5    IAH
## 460      4576  N10156               133     115       -6       -7    IAH
## 461      4579  N13992                64      39       32       28    IAH
## 462      4584  N16919                56      45       -6       -2    IAH
## 463      4585  N13970               109      93       -8       -2    IAH
## 464      4586  N16976               173     147       24        4    IAH
## 465      4589  N11199                89      76       -9        2    IAH
## 466      4590  N11194               129     112        7        0    IAH
## 467      4594  N15941                75      56      -11       -8    IAH
## 468      4596  N11127               122     104        2        2    IAH
## 469      4599  N14940                51      38      -19      -10    IAH
## 470      4608  N15572                65      44       -8      -10    IAH
## 471      4610  N22909               111     100      -13       -7    IAH
## 472      4611  N11137                74      63       26       42    IAH
## 473      4616  N14943                89      63       -1       -2    IAH
## 474      4621  N14174                71      59       -4       -2    IAH
## 475      4622  N15941                70      58       41       50    IAH
## 476      4623  N13975                72      41       -8       -5    IAH
## 477      4631  N11155                62      39        9       -3    IAH
## 478      4635  N14933                65      51      -12       -5    IAH
## 479      4637  N24128               133     119       11       23    IAH
## 480      4638  N14148               156     135       -9       -3    IAH
## 481      4642  N17138                95      75      132      134    IAH
## 482      4644  N13202               135     111       28       30    IAH
## 483      4645  N14940                55      42      -35       -3    IAH
## 484      4658  N12195                55      33       -8      -13    IAH
## 485      4659  N12934                72      59        4       12    IAH
## 486      4661  N13161               135     124      -15        0    IAH
## 487      4662  N12934                78      58        7        4    IAH
## 488      4663  N13538               128     114      -13       -3    IAH
## 489      4665  N15932                95      75       -8       -6    IAH
## 490      4666  N14558                89      69       -7       -8    IAH
## 491      4669  N14942                86      65        1        2    IAH
## 492      4671  N12195               163     134       -8       -4    IAH
## 493      4674  N14558                53      37      -12       -5    IAH
## 494      4678  N14938                59      46       -8       -2    IAH
## 495      4682  N14174                51      35       -3       -5    IAH
## 496      4683  N11155               136     119        2       -2    IAH
## 497      4684  N13935                52      35       -9       -4    IAH
## 498      4685  N15932                87      66       -5       -5    IAH
## 499      4687  N14562               119     106      -12       -2    IAH
## 500      4693  N22909                63      49       23       27    IAH
## 501      4703  N14939                47      34      -11       -5    IAH
## 502      4704  N14168                95      80       -5        3    IAH
## 503      4705  N13992                82      69       21       26    IAH
## 504      4706  N13936                51      35      -10       -7    IAH
## 505      4707  N13936                52      33       -2       -1    IAH
## 506      4710  N16944                75      56       54       51    IAH
## 507      4711  N11109               113     101      -16       -2    IAH
## 508      6097  N14952               154     125       65       62    IAH
## 509      5152  N707EV               168     148       -5       -5    IAH
## 510      5222  N975EV                85      67       17       24    IAH
## 511      5245  N923EV                95      75        2       -4    IAH
## 512      5386  N730EV               166     150       -6       -7    IAH
## 513      5478  N712EV               183     162       23        9    IAH
## 514       147  N904FR               137     124      -11       -3    HOU
## 515       141  N926FR               138     123      -13      -13    HOU
## 516       290  N283AT               100      85      -20       -5    HOU
## 517       286  N942AT               105      90        0       10    HOU
## 518       294  N975AT               103      86      -18       -6    HOU
## 519       288  N986AT               100      83      -18       -3    HOU
## 520       296  N969AT               102      87       61       72    HOU
## 521      1597  N986AT                81      71      -24       -9    HOU
## 522      2870  N673MQ                66      45       -9       -5    HOU
## 523      2958  N845MQ                71      43        0       -1    HOU
## 524      3210  N653MQ                69      46       -4       -3    HOU
## 525      3216  N673MQ                67      46       -9       -6    HOU
## 526      3328  N658MQ                68      46       -5       -8    HOU
## 527      3390  N654MQ                69      43       -7       -6    HOU
## 528      3717  N542MQ               147     131        8       16    IAH
## 529      3719  N503MQ               192     180       -4       19    IAH
## 530      3724  N503MQ               197     179       29       42    IAH
## 531      3762  N8EGMQ               214     187       -1       -5    IAH
## 532      3786  N516MQ               148     130      -15       -3    IAH
## 533      3796  N542MQ               141     128      -16       -7    IAH
## 534      3859  N535MQ               150     128       -7       -2    IAH
## 535      2031  N751SK               151     132       -8       -7    IAH
## 536      2033  N786SK               127     108       -7       -2    IAH
## 537      2034  N744SK               166     150      -18       -4    IAH
## 538      2037  N768SK               141     117       -4       -8    IAH
## 539      2038  N767SK               153     136        2        4    IAH
## 540      2040  N746SK               210     194      -22       -2    IAH
## 541      2042  N705SK               164     141      -17       -1    IAH
## 542      2045  N793SK                62      40       -7       -1    IAH
## 543      2016  N778SK               112      94       -9       -7    IAH
## 544      4497  N825SK               188     163        9        1    IAH
## 545      2022  N712SK                75      60      -14       -5    IAH
## 546      2019  N712SK               165     142       -3       -4    IAH
## 547      2046  N786SK               151     131       -8       -7    IAH
## 548      2030  N746SK               133     110       -4       -5    IAH
## 549      2029  N754SK               126     111       -6       -3    IAH
## 550      2008  N744SK               125     108       35       49    IAH
## 551      2028  N755SK               149     133       -2       -2    IAH
## 552      2059  N701SK               109      92       -7       -7    IAH
## 553      2027  N797SK               135     116       -3       -6    IAH
## 554      2054  N751SK               176     128       37       -7    IAH
## 555      2055  N771SK               115      93        1       -2    IAH
## 556      2056  N705SK                74      59       -4       -3    IAH
## 557      2057  N778SK               156     136      -16       -4    IAH
## 558      2020  N797SK               207     187      -16        7    IAH
## 559      2066  N768SK                56      39       15       24    IAH
## 560      2060  N778SK               107      91        6        9    IAH
## 561      2061  N754SK               144     124      -17       -9    IAH
## 562      2062  N743SK               122      91        6        4    IAH
## 563      2047  N786SK               127     109       60       58    IAH
## 564      2049  N793SK               162     143        1        1    IAH
## 565      2051  N744SK               119      95       -6       -8    IAH
## 566      2053  N755SK                80      58       -3       -5    IAH
## 567      4455  N609SK               182     168      -14       -1    IAH
## 568      2013  N743SK               131     109       -9       -3    IAH
## 569      2009  N768SK                64      39        5        4    IAH
## 570      2011  N767SK               198     161        8       -1    IAH
## 571      2017  N797SK               125     106        8       25    IAH
## 572      2018  N705SK               130     109       -6       -6    IAH
## 573      4484  N812SK               186     168       -9       -4    IAH
## 574      5802  N979SW               116      91       -5       -1    IAH
## 575      5808  N709BR               117      91       46       53    IAH
## 576      5810  N465SW               122      92       -4       -6    IAH
## 577      5813  N959SW                51      27       82       75    IAH
## 578      5815  N948SW                45      27       11        8    IAH
## 579      5824  N959SW               134     113       -4       -1    IAH
## 580      5834  N948SW                61      38        1        0    IAH
## 581      5837  N910SW                58      39       -8        1    IAH
## 582      5841  N959SW                63      42       43       52    IAH
## 583      5843  N910SW               111      95        8        9    IAH
## 584      6529  N787SK               146     125      -10       -5    IAH
## 585       230  N582UA               148     132        7        5    IAH
## 586       404  N553UA               259     224       14       -2    IAH
## 587       552  N840UA               158     139      -22       -5    IAH
## 588       737  N530UA               159     121       13       -4    IAH
## 589       855  N677UA               243     216       -4       -4    IAH
## 590        86  N303AW               158     144      -12       -4    IAH
## 591       269  N828AW               168     141       -5       -6    IAH
## 592       272  N305AW               169     143       -9        0    IAH
## 593       362  N332AW               177     144        1        2    IAH
## 594      1170  N452UW               141     113        0        5    IAH
## 595      1220  N455UW               133     111      -25       -8    IAH
## 596      1679  N423US               129     108      -19       -1    IAH
## 597      1696  N427US               150     118        1        1    IAH
## 598      1702  N453UW               133     109       94      107    IAH
## 599      1820  N955UW               175     152      -26       -3    IAH
## 600      1824  N950UW               201     176        0       -5    IAH
## 601      1828  N951UW               193     151        6        8    IAH
## 602      1978  N456UW               139     111      -23      -11    IAH
##     Dest Distance TaxiIn TaxiOut Cancelled CancellationCode Diverted
## 1    DFW      224     12      13         0                         0
## 2    MIA      964      5      13         0                         0
## 3    DFW      224      8      12         0                         0
## 4    DFW      224      6      17         0                         0
## 5    MIA      964      5       7         0                         0
## 6    DFW      224     22      14         0                         0
## 7    MIA      964     20       9         0                         0
## 8    DFW      224      9      12         0                         0
## 9    DFW      224      7      18         0                         0
## 10   SEA     1874     10       9         0                         0
## 11   JFK     1428      4      14         0                         0
## 12   JFK     1428      6      19         0                         0
## 13   HNL     3904      4      14         0                         0
## 14   MSY      305      5      15         0                         0
## 15   SAT      191      3      21         0                         0
## 16   MSY      305      5      18         0                         0
## 17   AUS      140      9      18         0                         0
## 18   LAX     1379     15      13         0                         0
## 19   LAX     1379     14      19         0                         0
## 20   DEN      862      9      20         0                         0
## 21   EWR     1400      8      18         0                         0
## 22   EWR     1400     10      17         0                         0
## 23   EWR     1400      9      16         0                         0
## 24   EWR     1400      8      16         0                         0
## 25   MSY      305      3      12         0                         0
## 26   ORD      925      6      12         0                         0
## 27   LAX     1379     10      19         0                         0
## 28   DCA     1208      5      13         0                         0
## 29   LAX     1379      8      24         0                         0
## 30   ORD      925     10      19         0                         0
## 31   DEN      862     10      13         0                         0
## 32   DEN      862      7      32         0                         0
## 33   MSY      305      5      27         0                         0
## 34   DEN      862      7      16         0                         0
## 35   SFO     1635     11      13         0                         0
## 36   SEA     1874      6      30         0                         0
## 37   LAS     1222     10      14         0                         0
## 38   SAT      191      3      20         0                         0
## 39   SFO     1635     11      21         0                         0
## 40   ANC     3266      6      14         0                         0
## 41   CLE     1091      6       9         0                         0
## 42   EWR     1400     13      13         0                         0
## 43   BOS     1597     10      13         0                         0
## 44   MCO      854      7      19         0                         0
## 45   LAX     1379      9      13         0                         0
## 46   AUS      140      5      30         0                         0
## 47   PDX     1825      4      19         0                         0
## 48   SLC     1195      4      14         0                         0
## 49   TPA      787      5      16         0                         0
## 50   BOS     1597     10      15         0                         0
## 51   DCA     1208      4      12         0                         0
## 52   ATL      689     10      18         0                         0
## 53   LGA     1416      4      11         0                         0
## 54   EWR     1400      7      12         0                         0
## 55   MSY      305      3      29         0                         0
## 56   SJU     2007      5      15         0                         0
## 57   MCO      854      5      15         0                         0
## 58   BOS     1597      6      20         0                         0
## 59   LGA     1416      8      18         0                         0
## 60   FLL      965      3      12         0                         0
## 61   IND      844      7      15         0                         0
## 62   DCA     1208      5      14         0                         0
## 63   LAS     1222     10      15         0                         0
## 64   SAT      191      4      18         0                         0
## 65   AUS      140      4      21         0                         0
## 66   SAN     1303      3      22         0                         0
## 67   AUS      140     10      15         0                         0
## 68   AUS      140      5      13         0                         0
## 69   AUS      140      4      22         0                         0
## 70   DTW     1075      6      13         0                         0
## 71   FLL      965      4      12         0                         0
## 72   TPA      787      8      26         0                         0
## 73   LAS     1222     18      20         0                         0
## 74   MSY      305      4      14         0                         0
## 75   PHL     1325      9      17         0                         0
## 76   PIT     1117      5      15         0                         0
## 77   RSW      861      5      14         0                         0
## 78   SAT      191      2      19         0                         0
## 79   SJC     1608      6      12         0                         0
## 80   SJC     1608      4      19         0                         0
## 81   SNA     1346      8      16         0                         0
## 82   SNA     1346      6      16         0                         0
## 83   EWR     1400     13      13         0                         0
## 84   SMF     1609      4      11         0                         0
## 85   LAS     1222      8      15         0                         0
## 86   SAN     1303      3      17         0                         0
## 87   SFO     1635      8      21         0                         0
## 88   FLL      965      3      16         0                         0
## 89   MIA      964      6      16         0                         0
## 90   PHX     1009      6      14         0                         0
## 91   MSY      305      5      14         0                         0
## 92   CLE     1091      5      10         0                         0
## 93   SEA     1874     10      13         0                         0
## 94   SFO     1635     13      20         0                         0
## 95   LGA     1416      7      14         0                         0
## 96   ORD      925      8      12         0                         0
## 97   LAX     1379      6      12         0                         0
## 98   DEN      862      8      14         0                         0
## 99   LAS     1222     10      16         0                         0
## 100  RDU     1042      3      21         0                         0
## 101  LGA     1416      7      18         0                         0
## 102  RDU     1042      9      14         0                         0
## 103  ORD      925     30      21         0                         0
## 104  LAS     1222     12      15         0                         0
## 105  DEN      862     13      13         0                         0
## 106  EWR     1400     12      17         0                         0
## 107  SFO     1635      9      16         0                         0
## 108  BOS     1597      9      18         0                         0
## 109  DTW     1075      9      18         0                         0
## 110  SJC     1608      3      13         0                         0
## 111  CLE     1091      9      22         0                         0
## 112  MFE      316      4      11         0                         0
## 113  TPA      787      4      11         0                         0
## 114  PHX     1009      7      15         0                         0
## 115  ORD      925     11      14         0                         0
## 116  SEA     1874      7      17         0                         0
## 117  SEA     1874     11      11         0                         0
## 118  SFO     1635     24      12         0                         0
## 119  CLE     1091      4      15         0                         0
## 120  SAN     1303      4      19         0                         0
## 121  PBI      956      4      15         0                         0
## 122  DCA     1208      9      12         0                         0
## 123  LAS     1222      8      24         0                         0
## 124  PDX     1825      6      18         0                         0
## 125  PDX     1825      5      21         0                         0
## 126  MSY      305      4      18         0                         0
## 127  LGA     1416      8      17         0                         0
## 128  LAX     1379     10      13         0                         0
## 129  DEN      862      6      15         0                         0
## 130  ORD      925      7      14         0                         0
## 131  DEN      862      6      11         0                         0
## 132  DFW      224      8      17         0                         0
## 133  SEA     1874      8      17         0                         0
## 134  SAT      191      3      23         0                         0
## 135  EWR     1400      5      18         0                         1
## 136  PDX     1825      4      17         0                         0
## 137  DCA     1208      4      13         0                         0
## 138  EWR     1400     11      15         0                         0
## 139  SNA     1346      7      15         0                         0
## 140  CLE     1091      7      12         0                         0
## 141  PIT     1117     15      20         0                         0
## 142  DTW     1075      8      12         0                         0
## 143  PIT     1117      7      22         0                         0
## 144  IAD     1190      8      20         0                         0
## 145  PHL     1325     10      11         0                         0
## 146  SNA     1346      6      16         0                         0
## 147  LAX     1379      9      12         0                         0
## 148  LAX     1379     11      13         0                         0
## 149  ATL      689      7      16         0                         0
## 150  MSY      305      3      15         0                         0
## 151  AUS      140      6      18         0                         0
## 152  ORD      925      6      15         0                         0
## 153  MCO      854      5      10         0                         0
## 154  BWI     1235      5      20         0                         0
## 155  MIA      964      8      12         0                         0
## 156  PHX     1009      4      19         0                         0
## 157  ONT     1334      6      18         0                         0
## 158  ATL      689      9      26         0                         0
## 159  MIA      964      7      15         0                         0
## 160  AUS      140      5      17         0                         0
## 161  FLL      965      4      13         0                         0
## 162  MCO      854      6      14         0                         0
## 163  IAD     1190      6      15         0                         0
## 164  ORD      925      5      14         0                         0
## 165  MCO      854      5      12         0                         0
## 166  PHX     1009      6      19         0                         0
## 167  SEA     1874      8      16         0                         0
## 168  SNA     1346      6      26         0                         0
## 169  ORD      925      9      19         0                         0
## 170  SAT      191      2      16         0                         0
## 171  SMF     1609      5      18         0                         0
## 172  SAT      191      4      15         0                         0
## 173  DCA     1208      4      12         0                         0
## 174  ONT     1334      6      17         0                         0
## 175  CLT      912     11      14         0                         0
## 176  CLE     1091      8      14         0                         0
## 177  TPA      787      4      17         0                         0
## 178  LAX     1379     11      12         0                         0
## 179  PHL     1325     15      14         0                         0
## 180  DCA     1208      5      18         0                         0
## 181  LGA     1416      6      11         0                         0
## 182  PHL     1325     14      17         0                         0
## 183  RNO     1530      6      11         0                         0
## 184  LGA     1416      6      15         0                         0
## 185  DTW     1075     12      22         0                         0
## 186  SAN     1303      5      14         0                         0
## 187  MIA      964     11      21         0                         0
## 188  ATL      689      9      13         0                         0
## 189  LAS     1222     10      12         0                         0
## 190  MFE      316      5      15         0                         0
## 191  MSY      305      3      19         0                         0
## 192  PHX     1009      8      14         0                         0
## 193  BWI     1235      5      59         0                         0
## 194  DEN      862     10      15         0                         0
## 195  SMF     1609      5      15         0                         0
## 196  SAN     1303      6      18         0                         0
## 197  ORD      925      8      13         0                         0
## 198  SLC     1195      4      12         0                         0
## 199  BWI     1235      7      41         0                         0
## 200  LAX     1379      8      16         0                         0
## 201  TPA      787      8      18         0                         0
## 202  LGA     1416      9      16         0                         0
## 203  ATL      689      5      11         0                         0
## 204  ATL      689     22      11         0                         0
## 205  ATL      696      5      12         0                         0
## 206  ATL      689      9      13         0                         0
## 207  ATL      689      5      12         0                         0
## 208  ATL      689     12      10         0                         0
## 209  ATL      689     15      12         0                         0
## 210  ATL      696     18      16         0                         0
## 211  ABQ      759      4       6         0                         0
## 212  ABQ      759      7       8         0                         0
## 213  ABQ      759      4       5         0                         0
## 214  AUS      148      4      14         0                         0
## 215  AUS      148      3      13         0                         0
## 216  AUS      148      3       8         0                         0
## 217  AUS      148      5       8         0                         0
## 218  BHM      570      3       8         0                         0
## 219  BNA      670      3      10         0                         0
## 220  BNA      670      6      11         0                         0
## 221  BNA      670      6      12         0                         0
## 222  BWI     1246      7      10         0                         0
## 223  BWI     1246      6       6         0                         0
## 224  BWI     1246      7       7         0                         0
## 225  CHS      928     20      13         0                         0
## 226  CRP      187      4      10         0                         0
## 227  CRP      187      5       8         0                         0
## 228  CRP      187      4       5         0                         0
## 229  DAL      239      3       8         0                         0
## 230  DAL      239      3       9         0                         0
## 231  DAL      239      3       7         0                         0
## 232  DAL      239      5       8         0                         0
## 233  DAL      239      3      15         0                         0
## 234  DAL      239      4      10         0                         0
## 235  DAL      239      3       7         0                         0
## 236  DAL      239      3       7         0                         0
## 237  DAL      239      3       5         0                         0
## 238  DAL      239      3       7         0                         0
## 239  DAL      239      3       6         0                         0
## 240  DAL      239     21       7         0                         0
## 241  DAL      239      6       6         0                         0
## 242  DAL      239      3       6         0                         0
## 243  DAL      239      3       7         0                         0
## 244  DAL      239      2      10         0                         0
## 245  DAL      239      2       7         0                         0
## 246  DAL      239      4       9         0                         0
## 247  DAL      239      3       6         0                         0
## 248  DEN      883      6       6         0                         0
## 249  DEN      883      6       7         0                         0
## 250  DEN      883     11       6         0                         0
## 251  DEN      883      6       8         0                         0
## 252  ECP      571      4      12         0                         0
## 253  ECP      571      8       6         0                         0
## 254  ELP      677      3       6         0                         0
## 255  ELP      677      4       8         0                         0
## 256  EWR     1411      6      12         0                         0
## 257  EWR     1411      9       9         0                         0
## 258  FLL      957      5       6         0                         0
## 259  FLL      957      3       9         0                         0
## 260  GSP      845      2      10         0                         0
## 261  HRL      276      2      10         0                         0
## 262  HRL      276      2      10         0                         0
## 263  HRL      276      2      10         0                         0
## 264  HRL      276      2       5         0                         0
## 265  HRL      276      2       8         0                         0
## 266  HRL      276      3       9         0                         0
## 267  JAN      359      5       6         0                         0
## 268  JAN      359      3       6         0                         0
## 269  JAX      816      4       9         0                         0
## 270  LAS     1235      4       6         0                         0
## 271  LAS     1235      3       6         0                         0
## 272  LAS     1235      5       9         0                         0
## 273  LAS     1235      5       5         0                         0
## 274  LAX     1390      7       8         0                         0
## 275  LAX     1390      7       6         0                         0
## 276  LAX     1390     13       6         0                         0
## 277  LIT      393      2      10         0                         0
## 278  MAF      441      4       9         0                         0
## 279  MCO      849      8       6         0                         0
## 280  MCO      849      4       7         0                         0
## 281  MCO      849      5       6         0                         0
## 282  MCO      849      5       8         0                         0
## 283  MDW      937      6       7         0                         0
## 284  MDW      937      6       5         0                         0
## 285  MDW      937     12       7         0                         0
## 286  MDW      937      6       6         0                         0
## 287  MDW      937     12       7         0                         0
## 288  MSY      302      6      11         0                         0
## 289  MSY      302      3      10         0                         0
## 290  MSY      302      4      11         0                         0
## 291  MSY      302      4       6         0                         0
## 292  MSY      302      6       9         0                         0
## 293  MSY      302      6       8         0                         0
## 294  MSY      302      5       6         0                         0
## 295  MSY      302      3       7         0                         0
## 296  MSY      302      3       7         0                         0
## 297  OAK     1642      8       9         0                         0
## 298  OAK     1642      6      10         0                         0
## 299  OKC      419      2       6         0                         0
## 300  OKC      419      3       6         0                         0
## 301  OKC      419      4       9         0                         0
## 302  OKC      419      3       6         0                         0
## 303  PHL     1336     35       7         0                         0
## 304  PHX     1020     10       7         0                         0
## 305  PHX     1020      5       6         0                         0
## 306  PHX     1020      4       6         0                         0
## 307  SAN     1313      3      10         0                         0
## 308  SAN     1313      3      10         0                         0
## 309  SAT      192      3       7         0                         0
## 310  SAT      192      3      12         0                         0
## 311  SAT      192      2       9         0                         0
## 312  SAT      192      3      15         0                         0
## 313  STL      687      3       8         0                         0
## 314  STL      687      8       7         0                         0
## 315  STL      687      4       8         0                         0
## 316  TPA      781      4       5         0                         0
## 317  TPA      781      4      14         0                         0
## 318  TPA      781      3      10         0                         0
## 319  TUL      453      3       8         0                         0
## 320  TUL      453      5       8         0                         0
## 321  TUL      453     11       7         0                         0
## 322  OMA      781      5      11         0                         0
## 323  GSP      837      2      14         0                         0
## 324  MCI      643      5      13         0                         0
## 325  GRR     1042      4      15         0                         0
## 326  TYS      771      5      11         0                         0
## 327  HRL      295      5      11         0                         0
## 328  COS      809      6      17         0                         0
## 329  CRP      201      4      16         0                         0
## 330  JAX      817      4      14         0                         0
## 331  MSP     1034      8      14         0                         0
## 332  JAX      817      4      19         0                         0
## 333  MSP     1034      9      17         0                         0
## 334  CRP      201      5      11         0                         0
## 335  XNA      438      4      10         0                         0
## 336  BNA      657      6      11         0                         0
## 337  SDF      788      5      13         0                         0
## 338  OMA      781      4      23         0                         0
## 339  CID      845      5      16         0                         0
## 340  OKC      395      4      12         0                         0
## 341  MEM      468      5      14         0                         0
## 342  MEM      468      5      23         0                         0
## 343  TUL      429      4      17         0                         0
## 344  LBB      458      6      15         0                         0
## 345  IND      844      6      14         0                         0
## 346  LBB      458      4      16         0                         0
## 347  HRL      295      4      13         0                         0
## 348  PNS      489      4       9         0                         0
## 349  ORF     1201      6      13         0                         0
## 350  CRP      201      4      14         0                         0
## 351  MOB      427      6      14         0                         0
## 352  CRW      975      5       9         0                         0
## 353  TUL      429      6       8         0                         0
## 354  CRP      201      4      14         0                         0
## 355  HRL      295      4      20         0                         0
## 356  BTR      253      4       7         0                         0
## 357  BRO      308      5      11         0                         0
## 358  BTR      253      5      11         0                         0
## 359  RSW      861      4      11         0                         0
## 360  TYS      771     10      13         0                         0
## 361  AVL      834      5      17         0                         0
## 362  CRP      201      5       9         0                         0
## 363  STL      667      5      15         0                         0
## 364  BTR      253      5       9         0                         0
## 365  LEX      828      4      10         0                         0
## 366  TUS      936      5      17         0                         0
## 367  HOB      501      3      12         0                         0
## 368  BTR      253      6      13         0                         0
## 369  RDU     1042      6      13         0                         0
## 370  CMH      986      4      21         0                         0
## 371  TUL      429      5      11         0                         0
## 372  VPS      528     12      10         0                         0
## 373  AEX      190      3      14         0                         0
## 374  MCI      643      6      14         0                         0
## 375  CVG      871      4      14         0                         0
## 376  BRO      308      6      15         0                         0
## 377  OMA      781      3      14         0                         0
## 378  PNS      489      5       8         0                         0
## 379  BNA      657      8      17         0                         0
## 380  BHM      562      4      12         0                         0
## 381  CID      845      5       9         0                         0
## 382  CRP      201      4      18         0                         0
## 383  BHM      562      3      17         0                         0
## 384  IND      844      6      16         0                         0
## 385  MKE      984      7      12         0                         0
## 386  GPT      376      6       7         0                         0
## 387  BRO      308      4      14         0                         0
## 388  RIC     1157      8       8         0                         0
## 389  GSO      987      5      11         0                         0
## 390  BRO      308      4      11         0                         0
## 391  BHM      562      4      13         0                         0
## 392  JAX      817      3      11         0                         0
## 393  CLT      912      7      13         0                         0
## 394  MCI      643      4      20         0                         0
## 395  SAV      851      3       8         0                         0
## 396  MCI      643      5      13         0                         0
## 397  ICT      542      5      10         0                         0
## 398  SDF      788      7      14         0                         0
## 399  DFW      224     11      14         0                         0
## 400  CMH      986      4      13         0                         0
## 401  HSV      595      5      12         0                         0
## 402  ELP      667      4      16         0                         0
## 403  BNA      657      6      12         0                         0
## 404  BHM      562      3      15         0                         0
## 405  ICT      542      4      13         0                         0
## 406  CMH      986     19      12         0                         0
## 407  CMH      986      7      10         0                         0
## 408  CLT      912     13      13         0                         0
## 409  MEM      468      4      14         0                         0
## 410  CVG      871      8       9         0                         0
## 411  ICT      542      4      11         0                         0
## 412  BNA      657      6      11         0                         0
## 413  GSO      987      4       9         0                         0
## 414  DSM      802      6      15         0                         0
## 415  STL      667      5       9         0                         0
## 416  GJT      979      3      26         0                         0
## 417  GJT      979      3      23         0                         0
## 418  PNS      489      4       8         0                         0
## 419  LEX      828      5      11         0                         0
## 420  DAL      216      5      11         0                         0
## 421  LFT      201      4       8         0                         0
## 422  LCH      127      6      16         0                         0
## 423  GRR     1042      7       8         0                         0
## 424  LBB      458      7      10         0                         0
## 425  CVG      871      8      11         0                         0
## 426  LBB      458      4      18         0                         0
## 427  JAX      817      4       8         0                         0
## 428  ELP      667      4      14         0                         0
## 429  MCI      643      6      12         0                         0
## 430  MKE      984      6      10         0                         0
## 431  LFT      201      4      10         0                         0
## 432  LIT      374      4      18         0                         0
## 433  ELP      667      4      16         0                         0
## 434  SAT      191      2       8         0                         0
## 435  BRO      308      5      13         0                         0
## 436  VPS      528      9      13         0                         0
## 437  LFT      201      5      13         0                         0
## 438  JAN      351      6      10         0                         0
## 439  SHV      192      3      12         0                         0
## 440  MTJ      927      4      14         0                         0
## 441  MAF      429      3      14         0                         0
## 442  GPT      376      8      15         0                         0
## 443  MSP     1034      4      11         0                         0
## 444  JAX      817      3      11         0                         0
## 445  BNA      657      6       9         0                         0
## 446  DSM      802      4      11         0                         0
## 447  CRP      201      4      12         0                         0
## 448  GPT      376      7       9         0                         0
## 449  MEM      468      5      12         0                         0
## 450  CLT      912      6      12         0                         0
## 451  RDU     1042      5      11         0                         0
## 452  LRD      301      3      12         0                         0
## 453  BHM      562      5      12         0                         0
## 454  SDF      788      8      19         0                         0
## 455  ICT      542      4      10         0                         0
## 456  SAV      851      7      29         0                         0
## 457  AEX      190      3      17         0                         0
## 458  AMA      517      4      25         0                         0
## 459  TUL      429      5       8         0                         0
## 460  SDF      788      6      12         0                         0
## 461  DAL      216      4      21         0                         0
## 462  MSY      305      3       8         0                         0
## 463  MCI      643      5      11         0                         0
## 464  MKE      984      5      21         0                         0
## 465  HOB      501      3      10         0                         0
## 466  OMA      781      2      15         0                         0
## 467  MOB      427      7      12         0                         0
## 468  ABQ      744      6      12         0                         0
## 469  BTR      253      5       8         0                         0
## 470  HRL      295      8      13         0                         0
## 471  TYS      771      3       8         0                         0
## 472  XNA      438      3       8         0                         0
## 473  MAF      429      6      20         0                         0
## 474  OKC      395      4       8         0                         0
## 475  MOB      427      4       8         0                         0
## 476  DFW      224     16      15         0                         0
## 477  CRP      201      4      19         0                         0
## 478  LRD      301      3      11         0                         0
## 479  CLT      912      4      10         0                         0
## 480  RIC     1157      5      16         0                         0
## 481  AMA      517      3      17         0                         0
## 482  CHS      925      4      20         0                         0
## 483  MLU      262      4       9         0                         0
## 484  LFT      201      8      14         0                         0
## 485  MOB      427      5       8         0                         0
## 486  PBI      956      5       6         0                         0
## 487  LIT      374      6      14         0                         0
## 488  CHS      925      4      10         0                         0
## 489  AMA      517     10      10         0                         0
## 490  TUL      429      5      15         0                         0
## 491  XNA      438      5      16         0                         0
## 492  RIC     1157      9      20         0                         0
## 493  SAT      191      2      14         0                         0
## 494  HRL      295      2      11         0                         0
## 495  SHV      192      3      13         0                         0
## 496  IND      844      7      10         0                         0
## 497  LFT      201      3      14         0                         0
## 498  XNA      438      5      16         0                         0
## 499  CAE      878      3      10         0                         0
## 500  LRD      301      3      11         0                         0
## 501  CRP      201      3      10         0                         0
## 502  HSV      595      6       9         0                         0
## 503  MEM      468      3      10         0                         0
## 504  LFT      201      4      12         0                         0
## 505  LFT      201      5      14         0                         0
## 506  GPT      376     12       7         0                         0
## 507  GSP      837      4       8         0                         0
## 508  DEN      862      8      21         0                         0
## 509  DTW     1075      9      11         0                         0
## 510  MEM      468      6      12         0                         0
## 511  MEM      468      6      14         0                         0
## 512  DTW     1075      6      10         0                         0
## 513  DTW     1075      8      13         0                         0
## 514  DEN      883      5       8         0                         0
## 515  DEN      883      6       9         0                         0
## 516  ATL      696      8       7         0                         0
## 517  ATL      696      9       6         0                         0
## 518  ATL      696      9       8         0                         0
## 519  ATL      696      8       9         0                         0
## 520  ATL      696      7       8         0                         0
## 521  BKG      490      3       7         0                         0
## 522  DFW      247     12       9         0                         0
## 523  DFW      247     16      12         0                         0
## 524  DFW      247      6      17         0                         0
## 525  DFW      247      9      12         0                         0
## 526  DFW      247     10      12         0                         0
## 527  DFW      247     12      14         0                         0
## 528  ORD      925      7       9         0                         0
## 529  LAX     1379      5       7         0                         0
## 530  LAX     1379      6      12         0                         0
## 531  LAX     1379     10      17         0                         0
## 532  ORD      925      5      13         0                         0
## 533  ORD      925      5       8         0                         0
## 534  ORD      925      5      17         0                         0
## 535  TUS      936      5      14         0                         0
## 536  ABQ      744      4      15         0                         0
## 537  IAD     1190      4      12         0                         0
## 538  COS      809      6      18         0                         0
## 539  MKE      984      5      12         0                         0
## 540  BFL     1428      4      12         0                         0
## 541  IAD     1190      8      15         0                         0
## 542  DFW      224      5      17         0                         0
## 543  MCI      643      5      13         0                         0
## 544  SLC     1195      6      19         0                         0
## 545  OKC      395      5      10         0                         0
## 546  MSP     1034      8      15         0                         0
## 547  TUS      936      5      15         0                         0
## 548  OMA      781      4      19         0                         0
## 549  ABQ      744      5      10         0                         0
## 550  COS      809      7      10         0                         0
## 551  TUS      936      6      10         0                         0
## 552  ELP      667      3      14         0                         0
## 553  COS      809      4      15         0                         0
## 554  CVG      871     34      14         0                         0
## 555  MCI      643      4      18         0                         0
## 556  OKC      395      4      11         0                         0
## 557  ORF     1201      4      16         0                         0
## 558  BFL     1428      6      14         0                         0
## 559  DFW      224      5      12         0                         0
## 560  ELP      667      4      12         0                         0
## 561  RDU     1042      4      16         0                         0
## 562  ATL      689     17      14         0                         0
## 563  ABQ      744      4      14         0                         0
## 564  PIT     1117      7      12         0                         0
## 565  MCI      643      6      18         0                         0
## 566  OKC      395      5      17         0                         0
## 567  SLC     1195      4      10         0                         0
## 568  CLT      912     10      12         0                         0
## 569  DFW      224     13      12         0                         0
## 570  SLC     1195      7      30         0                         0
## 571  CLT      912      6      13         0                         0
## 572  OMA      781      3      18         0                         0
## 573  SLC     1195      7      11         0                         0
## 574  ATL      689      8      17         0                         0
## 575  ATL      689      8      18         0                         0
## 576  ATL      689     11      19         0                         0
## 577  AUS      140      5      19         0                         0
## 578  AUS      140      5      13         0                         0
## 579  COS      809      6      15         0                         0
## 580  DAL      216      6      17         0                         0
## 581  DAL      216      4      15         0                         0
## 582  DFW      224      6      15         0                         0
## 583  ELP      667      3      13         0                         0
## 584  ORD      925      4      17         0                         0
## 585  ORD      925      4      12         0                         0
## 586  SFO     1635     22      13         0                         0
## 587  IAD     1190      5      14         0                         0
## 588  DEN      862      5      33         0                         0
## 589  SFO     1635     14      13         0                         0
## 590  PHX     1009      4      10         0                         0
## 591  PHX     1009     11      16         0                         0
## 592  PHX     1009     10      16         0                         0
## 593  PHX     1009     20      13         0                         0
## 594  CLT      912      3      25         0                         0
## 595  CLT      912     12      10         0                         0
## 596  CLT      912      9      12         0                         0
## 597  CLT      912     10      22         0                         0
## 598  CLT      912     14      10         0                         0
## 599  PHL     1325     11      12         0                         0
## 600  PHL     1325      9      16         0                         0
## 601  PHL     1325     31      11         0                         0
## 602  CLT      912     18      10         0                         0
head(hflights)
##      Year Month DayofMonth DayOfWeek DepTime ArrTime UniqueCarrier
## 5424 2011     1          1         6    1400    1500            AA
## 5425 2011     1          2         7    1401    1501            AA
## 5426 2011     1          3         1    1352    1502            AA
## 5427 2011     1          4         2    1403    1513            AA
## 5428 2011     1          5         3    1405    1507            AA
## 5429 2011     1          6         4    1359    1503            AA
##      FlightNum TailNum ActualElapsedTime AirTime ArrDelay DepDelay Origin
## 5424       428  N576AA                60      40      -10        0    IAH
## 5425       428  N557AA                60      45       -9        1    IAH
## 5426       428  N541AA                70      48       -8       -8    IAH
## 5427       428  N403AA                70      39        3        3    IAH
## 5428       428  N492AA                62      44       -3        5    IAH
## 5429       428  N262AA                64      45       -7       -1    IAH
##      Dest Distance TaxiIn TaxiOut Cancelled CancellationCode Diverted
## 5424  DFW      224      7      13         0                         0
## 5425  DFW      224      6       9         0                         0
## 5426  DFW      224      5      17         0                         0
## 5427  DFW      224      9      22         0                         0
## 5428  DFW      224      9       9         0                         0
## 5429  DFW      224      6      13         0                         0
  1. How many flights departed on that day? (2)
count(hflights)
## # A tibble: 1 × 1
##        n
##    <int>
## 1 227496
  1. Create a data frame with the first column being the tail number and the second being the number of departures from Houston the plane made that year sorted by most to least number of flights. (4)

library(hflights) hflights %>% filter(Year ==2011) %>% reshape2::melt(hflights, “TailNum”, id.vars = “Year”) %>% arrange(asce(“TailNum”)) %>% select(Year, TailNUM) %>% summarize(nT = n()) group_by(STATE) %>% summarize(nT = n())

4 Using the tornado data set (http://myweb.fsu.edu/jelsner/temp/data/Tornadoes.txt) create a data frame with the year in the first column and the total number of tornadoes in Kansas by year in the second column. (6)

library(dplyr)
L = "http://myweb.fsu.edu/jelsner/temp/data/Tornadoes.txt"
df = read.table(L, header = TRUE)
df %>%
 filter(STATE == "KS") %>%
 group_by(YEAR) %>%
 summarize(nT = n())
## # A tibble: 62 × 2
##     YEAR    nT
##    <int> <int>
## 1   1950    30
## 2   1951    77
## 3   1952    19
## 4   1953    29
## 5   1954    68
## 6   1955    96
## 7   1956    57
## 8   1957    63
## 9   1958    49
## 10  1959    65
## # ... with 52 more rows