library(dplyr)
## Warning: package 'dplyr' was built under R version 3.2.2
##
## 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)
## Warning: package 'hflights' was built under R version 3.2.2
FILTER
# All flights that traveled 3000 miles or more
tb1 <- filter(hflights, Distance>=3000)
# All flights flown by one of JetBlue, Southwest, or Delta
tb2 <- filter(hflights, UniqueCarrier %in% c("JetBlue", "Southwest", "Delta"))
# All flights where taxiing took longer than flying
tb3 <- filter(hflights, TaxiIn+TaxiOut>AirTime )
# All flights that departed before 5am or arrived after 10pm
tb4 <- filter(hflights, DepTime<0500 | ArrTime > 2200)
# All flights that departed late but arrived ahead of schedule
tb5 <- filter(hflights, DepDelay >0, ArrDelay<0)
# All cancelled weekend flights
tb6 <- filter(hflights, Cancelled==1, DayOfWeek==6 |DayOfWeek==7)
# All flights that were cancelled after being delayed
tb7 <- filter(hflights, Cancelled==1, DepDelay >0)
# Select the flights that had JFK as their destination: c1
c1 <- filter(hflights, Dest == "JFK")
add a new column named Date to c1: paste() together the Year, Month and DayofMonth variables, seperate them by a “-” by using the sep attribute of paste(). Save the resulting data frame as c2.
# Combine the Year, Month and DayofMonth variables to create a Date column: c2
c2 <- mutate(c1, Date = paste(Year, Month, DayofMonth, sep = "-"))
# Print out a selection of columns of c2
select(c2, Date, DepTime, ArrTime, TailNum)
## Date DepTime ArrTime TailNum
## 1 2011-1-1 654 1124 N324JB
## 2 2011-1-1 1639 2110 N324JB
## 3 2011-1-2 703 1113 N324JB
## 4 2011-1-2 1604 2040 N324JB
## 5 2011-1-3 659 1100 N229JB
## 6 2011-1-3 1801 2200 N206JB
## 7 2011-1-4 654 1103 N267JB
## 8 2011-1-4 1608 2034 N267JB
## 9 2011-1-5 700 1103 N708JB
## 10 2011-1-5 1544 1954 N644JB
## 11 2011-1-6 1532 1943 N641JB
## 12 2011-1-7 654 1117 N641JB
## 13 2011-1-7 1542 1956 N564JB
## 14 2011-1-8 654 1058 N630JB
## 15 2011-1-9 653 1059 N599JB
## 16 2011-1-9 1618 2057 N625JB
## 17 2011-1-10 656 1102 N625JB
## 18 2011-1-10 1554 2001 N504JB
## 19 2011-1-11 653 1053 N504JB
## 20 2011-1-11 NA NA N537JB
## 21 2011-1-12 1532 1953 N504JB
## 22 2011-1-13 1522 1938 N597JB
## 23 2011-1-14 808 1229 N597JB
## 24 2011-1-14 1534 2015 N729JB
## 25 2011-1-15 700 1114 N503JB
## 26 2011-1-16 652 1055 N706JB
## 27 2011-1-16 1551 2004 N565JB
## 28 2011-1-17 730 1135 N523JB
## 29 2011-1-17 1531 1946 N779JB
## 30 2011-1-18 659 1102 N779JB
## 31 2011-1-18 1647 2056 N729JB
## 32 2011-1-19 NA NA N504JB
## 33 2011-1-20 1538 1952 N760JB
## 34 2011-1-21 656 1104 N760JB
## 35 2011-1-21 1725 2135 N598JB
## 36 2011-1-22 701 1106 N527JB
## 37 2011-1-23 658 1058 N580JB
## 38 2011-1-23 1535 1933 N599JB
## 39 2011-1-24 707 1059 N605JB
## 40 2011-1-24 1532 1923 N536JB
## 41 2011-1-25 658 1102 N589JB
## 42 2011-1-25 1623 2029 N621JB
## 43 2011-1-26 1535 1941 N659JB
## 44 2011-1-27 NA NA N569JB
## 45 2011-1-28 655 1107 N594JB
## 46 2011-1-28 1538 2013 N655JB
## 47 2011-1-29 657 1128 N508JB
## 48 2011-1-30 651 1106 N606JB
## 49 2011-1-30 1659 2118 N606JB
## 50 2011-1-31 659 1111 N661JB
## 51 2011-1-31 1532 1942 N629JB
## 52 2011-2-1 NA NA N629JB
## 53 2011-2-1 NA NA N558JB
## 54 2011-2-2 1531 1946 N768JB
## 55 2011-2-3 1938 2341 N552JB
## 56 2011-2-4 NA NA N665JB
## 57 2011-2-4 1547 2000 N570JB
## 58 2011-2-5 700 1113 N653JB
## 59 2011-2-6 700 1045 N657JB
## 60 2011-2-6 1529 1917 N531JB
## 61 2011-2-7 659 1045 N607JB
## 62 2011-2-7 1537 1952 N607JB
## 63 2011-2-8 654 1049 N607JB
## 64 2011-2-8 1546 1955 N606JB
## 65 2011-2-9 1533 1934 N618JB
## 66 2011-2-10 1550 1956 N565JB
## 67 2011-2-11 659 1100 N580JB
## 68 2011-2-11 1538 1937 N586JB
## 69 2011-2-12 659 1105 N612JB
## 70 2011-2-13 809 1235 N503JB
## 71 2011-2-13 1529 2012 N630JB
## 72 2011-2-14 655 1113 N526JB
## 73 2011-2-14 1532 1950 N648JB
## 74 2011-2-15 658 1118 N648JB
## 75 2011-2-15 1541 2007 N615JB
## 76 2011-2-16 1527 2003 N661JB
## 77 2011-2-17 708 2058 N247JB
## 78 2011-2-17 1742 2200 N289JB
## 79 2011-2-18 658 1109 N228JB
## 80 2011-2-18 1534 2024 N228JB
## 81 2011-2-19 703 1114 N228JB
## 82 2011-2-19 1653 2207 N228JB
## 83 2011-2-20 1107 1517 N766JB
## 84 2011-2-20 1530 2000 N190JB
## 85 2011-2-21 657 1106 N316JB
## 86 2011-2-21 1545 1956 N179JB
## 87 2011-2-22 659 1108 N197JB
## 88 2011-2-22 1535 1949 N197JB
## 89 2011-2-23 700 1106 N318JB
## 90 2011-2-23 1546 2002 N318JB
## 91 2011-2-24 653 1102 N179JB
## 92 2011-2-24 1545 2013 N179JB
## 93 2011-2-25 653 1130 N292JB
## 94 2011-2-25 1824 2314 N273JB
## 95 2011-2-26 652 1054 N292JB
## 96 2011-2-26 1538 1951 N292JB
## 97 2011-2-27 658 1107 N198JB
## 98 2011-2-27 1606 2020 N198JB
## 99 2011-2-28 655 1115 N206JB
## 100 2011-2-28 1710 2145 N206JB
## 101 2011-3-1 657 1115 N309JB
## 102 2011-3-1 1608 2022 N316JB
## 103 2011-3-2 659 1121 N236JB
## 104 2011-3-2 1657 2128 N298JB
## 105 2011-3-3 659 1148 N266JB
## 106 2011-3-3 1553 2013 N266JB
## 107 2011-3-4 700 1114 N316JB
## 108 2011-3-4 1537 2001 N316JB
## 109 2011-3-5 656 1119 N197JB
## 110 2011-3-6 656 1109 N197JB
## 111 2011-3-6 1839 5 N192JB
## 112 2011-3-7 NA NA N190JB
## 113 2011-3-7 1716 2128 N229JB
## 114 2011-3-8 655 1106 N228JB
## 115 2011-3-8 1555 2006 N228JB
## 116 2011-3-9 700 1112 N296JB
## 117 2011-3-9 1551 2052 N296JB
## 118 2011-3-10 706 1109 N307JB
## 119 2011-3-10 2013 141 N307JB
## 120 2011-3-11 704 1116 N304JB
## 121 2011-3-11 1529 1953 N316JB
## 122 2011-3-12 651 1128 N266JB
## 123 2011-3-13 700 1108 N266JB
## 124 2011-3-13 1526 2028 N298JB
## 125 2011-3-14 652 1106 N281JB
## 126 2011-3-14 1547 2003 N229JB
## 127 2011-3-15 659 1127 N317JB
## 128 2011-3-15 1542 1958 N317JB
## 129 2011-3-16 650 1102 N192JB
## 130 2011-3-16 1538 1953 N192JB
## 131 2011-3-17 655 1133 N323JB
## 132 2011-3-17 1532 2009 N323JB
## 133 2011-3-18 651 1127 N289JB
## 134 2011-3-18 1603 2022 N258JB
## 135 2011-3-19 655 1113 N307JB
## 136 2011-3-20 657 1119 N307JB
## 137 2011-3-20 1530 2000 N307JB
## 138 2011-3-21 656 1120 N317JB
## 139 2011-3-21 1700 2140 N317JB
## 140 2011-3-22 654 1118 N198JB
## 141 2011-3-22 1534 2001 N198JB
## 142 2011-3-23 652 1058 N179JB
## 143 2011-3-23 1649 2130 N179JB
## 144 2011-3-24 1040 1504 N198JB
## 145 2011-3-24 1703 2116 N267JB
## 146 2011-3-25 653 1112 N316JB
## 147 2011-3-25 1540 1950 N316JB
## 148 2011-3-26 656 1104 N283JB
## 149 2011-3-27 657 1107 N283JB
## 150 2011-3-27 1537 1937 N283JB
## 151 2011-3-28 652 1104 N236JB
## 152 2011-3-28 1528 1938 N236JB
## 153 2011-3-29 650 1101 N229JB
## 154 2011-3-29 1624 2033 N236JB
## 155 2011-3-30 655 1106 N289JB
## 156 2011-3-30 1606 2039 N289JB
## 157 2011-3-31 652 1056 N266JB
## 158 2011-3-31 1531 1951 N266JB
## 159 2011-4-1 734 1146 N236JB
## 160 2011-4-1 1615 2048 N296JB
## 161 2011-4-2 658 1109 N187JB
## 162 2011-4-3 655 1122 N229JB
## 163 2011-4-3 1530 2005 N317JB
## 164 2011-4-4 659 1111 N317JB
## 165 2011-4-4 1537 2037 N317JB
## 166 2011-4-5 656 1130 N197JB
## 167 2011-4-5 1533 1954 N198JB
## 168 2011-4-6 655 1111 N323JB
## 169 2011-4-6 1556 2043 N238JB
## 170 2011-4-7 656 1111 N324JB
## 171 2011-4-7 1519 1946 N206JB
## 172 2011-4-8 652 1112 N203JB
## 173 2011-4-8 1526 1937 N316JB
## 174 2011-4-9 656 1125 N274JB
## 175 2011-4-10 704 1127 N317JB
## 176 2011-4-10 1529 2004 N239JB
## 177 2011-4-11 657 1124 N304JB
## 178 2011-4-11 1552 2050 N318JB
## 179 2011-4-12 654 1118 N318JB
## 180 2011-4-12 1531 2020 N183JB
## 181 2011-4-13 656 1106 N266JB
## 182 2011-4-13 1624 2151 N298JB
## 183 2011-4-14 652 1101 N247JB
## 184 2011-4-14 1524 1954 N247JB
## 185 2011-4-15 657 1117 N294JB
## 186 2011-4-15 1529 2004 N265JB
## 187 2011-4-16 813 1237 N183JB
## 188 2011-4-17 703 1108 N279JB
## 189 2011-4-17 NA NA N306JB
## 190 2011-4-18 657 1109 N309JB
## 191 2011-4-18 1531 2020 N216JB
## 192 2011-4-19 701 1115 N216JB
## 193 2011-4-19 1541 2024 N316JB
## 194 2011-4-20 849 1306 N183JB
## 195 2011-4-20 NA NA N216JB
## 196 2011-4-21 654 1120 N192JB
## 197 2011-4-21 1527 2023 N187JB
## 198 2011-4-22 656 1111 N187JB
## 199 2011-4-22 1526 1952 N216JB
## 200 2011-4-23 655 1120 N216JB
## 201 2011-4-24 701 1123 N178JB
## 202 2011-4-24 1529 153 N273JB
## 203 2011-4-25 653 1115 N179JB
## 204 2011-4-25 1526 2008 N316JB
## 205 2011-4-26 656 1122 N316JB
## 206 2011-4-26 1618 2104 N323JB
## 207 2011-4-27 657 1123 N323JB
## 208 2011-4-27 1529 2124 N283JB
## 209 2011-4-28 659 1726 N229JB
## 210 2011-4-28 NA NA N228JB
## 211 2011-4-29 658 1105 N203JB
## 212 2011-4-29 1529 1943 N228JB
## 213 2011-4-30 654 1128 N190JB
## 214 2011-5-1 701 1121 N231JB
## 215 2011-5-1 1545 2009 N206JB
## 216 2011-5-2 702 1127 N206JB
## 217 2011-5-2 1521 2015 N316JB
## 218 2011-5-3 653 1101 N192JB
## 219 2011-5-3 1618 2031 N283JB
## 220 2011-5-4 700 1056 N190JB
## 221 2011-5-4 1604 2123 N316JB
## 222 2011-5-5 654 1056 N231JB
## 223 2011-5-5 1530 2028 N279JB
## 224 2011-5-6 702 1116 N279JB
## 225 2011-5-6 1539 1945 N304JB
## 226 2011-5-7 659 1106 N304JB
## 227 2011-5-8 701 1112 N306JB
## 228 2011-5-8 1517 1939 N216JB
## 229 2011-5-9 701 1125 N296JB
## 230 2011-5-9 1511 1936 N236JB
## 231 2011-5-10 654 1129 N316JB
## 232 2011-5-10 1516 1951 N216JB
## 233 2011-5-11 656 1134 N216JB
## 234 2011-5-11 1513 1942 N236JB
## 235 2011-5-12 656 1126 N184JB
## 236 2011-5-12 1511 1949 N298JB
## 237 2011-5-13 653 1115 N298JB
## 238 2011-5-13 1526 2019 N228JB
## 239 2011-5-14 658 1121 N203JB
## 240 2011-5-15 706 1125 N266JB
## 241 2011-5-15 1810 2312 N203JB
## 242 2011-5-16 659 1115 N197JB
## 243 2011-5-16 1531 2025 N267JB
## 244 2011-5-17 654 1109 N283JB
## 245 2011-5-17 1620 2045 N197JB
## 246 2011-5-18 700 1119 N192JB
## 247 2011-5-18 1758 2212 N267JB
## 248 2011-5-19 709 1120 N267JB
## 249 2011-5-19 1545 2025 N281JB
## 250 2011-5-20 654 1118 N247JB
## 251 2011-5-20 1527 2100 N273JB
## 252 2011-5-21 741 1225 N236JB
## 253 2011-5-22 657 1117 N247JB
## 254 2011-5-22 1530 1954 N294JB
## 255 2011-5-23 657 1127 N294JB
## 256 2011-5-23 1552 2045 N309JB
## 257 2011-5-24 653 1122 N309JB
## 258 2011-5-24 1609 2052 N228JB
## 259 2011-5-25 656 1116 N309JB
## 260 2011-5-25 1508 1940 N184JB
## 261 2011-5-26 652 1103 N294JB
## 262 2011-5-26 1514 2003 N267JB
## 263 2011-5-27 656 1117 N267JB
## 264 2011-5-27 1655 2150 N274JB
## 265 2011-5-28 656 1134 N274JB
## 266 2011-5-28 1507 1929 N203JB
## 267 2011-5-29 659 1130 N267JB
## 268 2011-5-29 1509 1936 N197JB
## 269 2011-5-30 659 1122 N283JB
## 270 2011-5-30 1611 2044 N190JB
## 271 2011-5-31 657 1127 N198JB
## 272 2011-5-31 1509 1938 N296JB
## 273 2011-6-1 707 1131 N258JB
## 274 2011-6-1 1509 2019 N318JB
## 275 2011-6-2 648 1138 N306JB
## 276 2011-6-2 1510 1945 N298JB
## 277 2011-6-3 655 1135 N236JB
## 278 2011-6-3 1509 1942 N317JB
## 279 2011-6-4 705 1138 N307JB
## 280 2011-6-4 1516 1943 N267JB
## 281 2011-6-5 702 1123 N306JB
## 282 2011-6-5 1507 2017 N283JB
## 283 2011-6-6 710 1135 N238JB
## 284 2011-6-6 1510 2016 N292JB
## 285 2011-6-7 702 1131 N258JB
## 286 2011-6-7 1504 1937 N236JB
## 287 2011-6-8 650 1119 N265JB
## 288 2011-6-8 1537 2018 N206JB
## 289 2011-6-9 654 1121 N328JB
## 290 2011-6-9 1618 2137 N307JB
## 291 2011-6-10 651 1116 N178JB
## 292 2011-6-10 1513 2004 N283JB
## 293 2011-6-11 655 1120 N283JB
## 294 2011-6-11 1538 2043 N249JB
## 295 2011-6-12 702 1124 N193JB
## 296 2011-6-12 1534 2022 N239JB
## 297 2011-6-13 657 1112 N239JB
## 298 2011-6-13 1524 1934 N183JB
## 299 2011-6-14 652 1108 N216JB
## 300 2011-6-14 1659 2125 N178JB
## 301 2011-6-15 652 1113 N307JB
## 302 2011-6-15 1507 1935 N298JB
## 303 2011-6-16 656 1121 N238JB
## 304 2011-6-16 1505 1953 N187JB
## 305 2011-6-17 656 1123 N238JB
## 306 2011-6-17 1622 2120 N316JB
## 307 2011-6-18 NA NA N329JB
## 308 2011-6-18 1617 2049 N273JB
## 309 2011-6-19 658 1106 N273JB
## 310 2011-6-19 1509 1939 N247JB
## 311 2011-6-20 656 1108 N247JB
## 312 2011-6-20 1514 1955 N193JB
## 313 2011-6-21 NA NA N266JB
## 314 2011-6-21 1523 2017 N281JB
## 315 2011-6-22 653 1121 N258JB
## 316 2011-6-22 1624 2048 N178JB
## 317 2011-6-23 706 1122 N267JB
## 318 2011-6-23 1526 2104 N266JB
## 319 2011-6-24 703 1109 N266JB
## 320 2011-6-24 1705 2133 N266JB
## 321 2011-6-25 658 1116 N239JB
## 322 2011-6-25 1505 1929 N306JB
## 323 2011-6-26 705 1138 N306JB
## 324 2011-6-26 1614 2103 N178JB
## 325 2011-6-27 659 1127 N236JB
## 326 2011-6-27 1549 2041 N279JB
## 327 2011-6-28 701 1120 N273JB
## 328 2011-6-28 1546 2106 N273JB
## 329 2011-6-29 657 1127 N306JB
## 330 2011-6-29 1609 2035 N247JB
## 331 2011-6-30 656 1118 N323JB
## 332 2011-6-30 1513 1940 N281JB
## 333 2011-7-1 700 1145 N316JB
## 334 2011-7-1 1505 2000 N228JB
## 335 2011-7-2 643 1120 N519JB
## 336 2011-7-2 1522 2019 N519JB
## 337 2011-7-3 622 1104 N595JB
## 338 2011-7-3 1542 2021 N595JB
## 339 2011-7-4 637 1055 N630JB
## 340 2011-7-4 1512 1951 N630JB
## 341 2011-7-5 636 1049 N527JB
## 342 2011-7-5 1720 2205 N527JB
## 343 2011-7-6 627 1100 N768JB
## 344 2011-7-6 1529 2037 N768JB
## 345 2011-7-7 628 1101 N585JB
## 346 2011-7-7 1511 2024 N585JB
## 347 2011-7-8 628 1103 N531JB
## 348 2011-7-8 1640 2106 N531JB
## 349 2011-7-9 628 1046 N644JB
## 350 2011-7-9 1510 2003 N644JB
## 351 2011-7-10 624 1057 N784JB
## 352 2011-7-10 1509 1957 N784JB
## 353 2011-7-11 632 1053 N599JB
## 354 2011-7-11 1555 2044 N599JB
## 355 2011-7-12 630 1058 N640JB
## 356 2011-7-12 1512 2013 N621JB
## 357 2011-7-13 631 1051 N608JB
## 358 2011-7-13 1513 2027 N608JB
## 359 2011-7-14 625 1050 N789JB
## 360 2011-7-14 1515 2011 N789JB
## 361 2011-7-15 630 1111 N641JB
## 362 2011-7-15 1513 2027 N641JB
## 363 2011-7-16 632 1110 N703JB
## 364 2011-7-16 1514 1959 N703JB
## 365 2011-7-17 623 1114 N746JB
## 366 2011-7-17 1511 2013 N746JB
## 367 2011-7-18 624 1059 N648JB
## 368 2011-7-18 1507 2003 N648JB
## 369 2011-7-19 626 1101 N559JB
## 370 2011-7-19 1550 2021 N559JB
## 371 2011-7-20 628 1107 N659JB
## 372 2011-7-20 1508 2009 N659JB
## 373 2011-7-21 629 1057 N635JB
## 374 2011-7-21 1529 2033 N635JB
## 375 2011-7-22 629 1112 N779JB
## 376 2011-7-22 1519 2003 N629JB
## 377 2011-7-23 1046 1503 N663JB
## 378 2011-7-23 1644 2120 N565JB
## 379 2011-7-24 628 1057 N592JB
## 380 2011-7-24 1506 1953 N592JB
## 381 2011-7-25 627 1056 N657JB
## 382 2011-7-25 1759 2307 N657JB
## 383 2011-7-26 629 1047 N505JB
## 384 2011-7-26 1505 1948 N592JB
## 385 2011-7-27 628 1058 N624JB
## 386 2011-7-27 1515 1959 N624JB
## 387 2011-7-28 800 1232 N644JB
## 388 2011-7-28 1538 2017 N535JB
## 389 2011-7-29 631 1103 N592JB
## 390 2011-7-29 1737 2237 N592JB
## 391 2011-7-30 635 1058 N624JB
## 392 2011-7-30 1517 1952 N624JB
## 393 2011-7-31 625 1046 N729JB
## 394 2011-7-31 1518 2014 N598JB
## 395 2011-8-1 627 1058 N547JB
## 396 2011-8-1 1511 2113 N547JB
## 397 2011-8-2 NA NA N547JB
## 398 2011-8-2 1545 2021 N703JB
## 399 2011-8-3 622 1049 N632JB
## 400 2011-8-3 1511 2027 N663JB
## 401 2011-8-4 628 1053 N624JB
## 402 2011-8-4 1509 1954 N624JB
## 403 2011-8-5 627 1058 N635JB
## 404 2011-8-5 1531 2046 N708JB
## 405 2011-8-6 624 1108 N593JB
## 406 2011-8-6 1512 2001 N593JB
## 407 2011-8-7 623 1051 N565JB
## 408 2011-8-7 1547 2016 N625JB
## 409 2011-8-8 624 1038 N665JB
## 410 2011-8-8 1512 2008 N665JB
## 411 2011-8-9 627 1043 N524JB
## 412 2011-8-9 1646 2118 N524JB
## 413 2011-8-10 625 1044 N537JB
## 414 2011-8-10 1529 1956 N630JB
## 415 2011-8-11 627 1040 N639JB
## 416 2011-8-11 1611 2036 N625JB
## 417 2011-8-12 624 1040 N527JB
## 418 2011-8-12 1514 1949 N527JB
## 419 2011-8-13 616 1103 N503JB
## 420 2011-8-13 1510 1941 N570JB
## 421 2011-8-14 619 1133 N612JB
## 422 2011-8-14 1847 2343 N606JB
## 423 2011-8-15 623 1042 N519JB
## 424 2011-8-15 1737 2217 N519JB
## 425 2011-8-16 627 1045 N639JB
## 426 2011-8-16 1513 2013 N639JB
## 427 2011-8-17 623 1116 N516JB
## 428 2011-8-17 1545 2026 N527JB
## 429 2011-8-18 833 1252 N615JB
## 430 2011-8-18 1509 2226 N563JB
## 431 2011-8-19 626 1110 N524JB
## 432 2011-8-19 1958 52 N709JB
## 433 2011-8-20 629 1059 N606JB
## 434 2011-8-20 1646 2126 N509JB
## 435 2011-8-21 626 1048 N503JB
## 436 2011-8-21 1626 2135 N591JB
## 437 2011-8-22 626 1043 N584JB
## 438 2011-8-22 1507 1947 N584JB
## 439 2011-8-23 626 1054 N709JB
## 440 2011-8-23 1542 2030 N649JB
## 441 2011-8-24 630 1102 N579JB
## 442 2011-8-24 1516 1938 N579JB
## 443 2011-8-25 627 1108 N638JB
## 444 2011-8-25 1745 3 N638JB
## 445 2011-8-26 627 1053 N706JB
## 446 2011-8-26 1518 1950 N706JB
## 447 2011-8-27 647 1119 N568JB
## 448 2011-8-27 NA NA N568JB
## 449 2011-8-28 NA NA N606JB
## 450 2011-8-28 NA NA N606JB
## 451 2011-8-29 NA NA N653JB
## 452 2011-8-29 NA NA N589JB
## 453 2011-8-30 1041 1518 N663JB
## 454 2011-8-30 1514 2016 N586JB
## 455 2011-8-31 631 1106 N507JB
## 456 2011-8-31 1519 2004 N507JB
## 457 2011-9-1 631 1100 N641JB
## 458 2011-9-1 1515 1945 N641JB
## 459 2011-9-2 630 1104 N527JB
## 460 2011-9-2 1517 2008 N527JB
## 461 2011-9-3 634 1113 N709JB
## 462 2011-9-3 1527 2018 N709JB
## 463 2011-9-4 640 1057 N554JB
## 464 2011-9-4 1529 2003 N625JB
## 465 2011-9-5 628 1045 N599JB
## 466 2011-9-5 1506 1951 N599JB
## 467 2011-9-6 633 1046 N519JB
## 468 2011-9-6 1538 2113 N562JB
## 469 2011-9-7 642 1056 N652JB
## 470 2011-9-7 1631 2108 N529JB
## 471 2011-9-8 643 1048 N579JB
## 472 2011-9-8 1456 1918 N588JB
## 473 2011-9-9 644 1048 N579JB
## 474 2011-9-9 1458 1915 N570JB
## 475 2011-9-10 641 1043 N784JB
## 476 2011-9-10 1457 1912 N584JB
## 477 2011-9-11 641 1047 N552JB
## 478 2011-9-11 1451 1857 N658JB
## 479 2011-9-12 643 1055 N570JB
## 480 2011-9-12 1455 1931 N649JB
## 481 2011-9-13 641 1105 N627JB
## 482 2011-9-13 1457 1917 N523JB
## 483 2011-9-14 641 1059 N595JB
## 484 2011-9-14 1457 1930 N729JB
## 485 2011-9-15 709 1130 N509JB
## 486 2011-9-15 1543 2013 N509JB
## 487 2011-9-16 641 1052 N603JB
## 488 2011-9-16 1505 1936 N621JB
## 489 2011-9-17 645 1058 N586JB
## 490 2011-9-17 1459 1914 N612JB
## 491 2011-9-18 637 1048 N505JB
## 492 2011-9-18 1524 1938 N630JB
## 493 2011-9-19 649 1104 N509JB
## 494 2011-9-19 1454 1938 N517JB
## 495 2011-9-20 644 1055 N634JB
## 496 2011-9-20 1524 2000 N705JB
## 497 2011-9-21 645 1058 N657JB
## 498 2011-9-21 1511 1927 N527JB
## 499 2011-9-22 646 1101 N537JB
## 500 2011-9-22 1604 2114 N638JB
## 501 2011-9-23 645 1046 N627JB
## 502 2011-9-23 1640 2053 N593JB
## 503 2011-9-24 645 1049 N523JB
## 504 2011-9-24 1503 1938 N510JB
## 505 2011-9-25 641 1051 N559JB
## 506 2011-9-25 1455 1916 N766JB
## 507 2011-9-26 702 1120 N590JB
## 508 2011-9-26 1635 2051 N590JB
## 509 2011-9-27 646 1058 N547JB
## 510 2011-9-27 1454 1905 N554JB
## 511 2011-9-28 648 1114 N569JB
## 512 2011-9-28 1453 1946 N536JB
## 513 2011-9-29 649 1104 N536JB
## 514 2011-9-29 1501 1943 N536JB
## 515 2011-9-30 648 1107 N661JB
## 516 2011-9-30 1459 1911 N579JB
## 517 2011-10-1 645 1049 N579JB
## 518 2011-10-1 1458 1903 N506JB
## 519 2011-10-2 648 1112 N657JB
## 520 2011-10-2 1504 1944 N655JB
## 521 2011-10-3 650 1059 N655JB
## 522 2011-10-3 1503 1943 N655JB
## 523 2011-10-4 643 1104 N520JB
## 524 2011-10-4 1457 1919 N534JB
## 525 2011-10-5 642 1103 N503JB
## 526 2011-10-5 1502 1930 N506JB
## 527 2011-10-6 643 1058 N587JB
## 528 2011-10-6 1612 2041 N661JB
## 529 2011-10-7 649 1119 N637JB
## 530 2011-10-7 1511 1956 N659JB
## 531 2011-10-8 649 1111 N527JB
## 532 2011-10-8 1507 1944 N565JB
## 533 2011-10-9 643 1104 N565JB
## 534 2011-10-9 1510 1950 N648JB
## 535 2011-10-10 651 1108 N529JB
## 536 2011-10-10 1456 1919 N558JB
## 537 2011-10-11 728 1139 N598JB
## 538 2011-10-11 1456 1927 N627JB
## 539 2011-10-12 645 1052 N591JB
## 540 2011-10-12 1501 1912 N588JB
## 541 2011-10-13 647 1058 N531JB
## 542 2011-10-13 1506 1942 N534JB
## 543 2011-10-14 645 1104 N568JB
## 544 2011-10-14 1635 2104 N645JB
## 545 2011-10-15 643 1048 N645JB
## 546 2011-10-15 1526 2023 N709JB
## 547 2011-10-16 645 1058 N586JB
## 548 2011-10-16 1504 1920 N606JB
## 549 2011-10-17 645 1050 N203JB
## 550 2011-10-17 1511 1920 N323JB
## 551 2011-10-18 648 1049 N323JB
## 552 2011-10-18 1508 1932 N265JB
## 553 2011-10-19 644 1043 N249JB
## 554 2011-10-19 1610 2013 N236JB
## 555 2011-10-20 646 1050 N184JB
## 556 2011-10-20 1611 2103 N265JB
## 557 2011-10-21 648 1049 N265JB
## 558 2011-10-21 1457 1914 N231JB
## 559 2011-10-22 639 1046 N231JB
## 560 2011-10-22 1501 1917 N328JB
## 561 2011-10-23 648 1102 N324JB
## 562 2011-10-23 1506 1931 N231JB
## 563 2011-10-24 649 1113 N284JB
## 564 2011-10-24 1529 2004 N323JB
## 565 2011-10-25 645 1100 N279JB
## 566 2011-10-25 1457 1910 N283JB
## 567 2011-10-26 644 1059 N267JB
## 568 2011-10-26 1504 1935 N184JB
## 569 2011-10-27 644 1058 N296JB
## 570 2011-10-27 1520 1939 N229JB
## 571 2011-10-28 647 1048 N229JB
## 572 2011-10-28 1532 1937 N274JB
## 573 2011-10-29 706 1106 N316JB
## 574 2011-10-29 2015 17 N231JB
## 575 2011-10-30 714 1126 N585JB
## 576 2011-10-30 1551 1958 N579JB
## 577 2011-10-31 639 1039 N643JB
## 578 2011-10-31 1546 2005 N643JB
## 579 2011-11-1 635 1044 N644JB
## 580 2011-11-1 1546 2005 N646JB
## 581 2011-11-2 634 1055 N605JB
## 582 2011-11-2 1547 2018 N605JB
## 583 2011-11-3 637 1041 N523JB
## 584 2011-11-3 1551 2010 N587JB
## 585 2011-11-4 632 1030 N523JB
## 586 2011-11-4 1546 2031 N523JB
## 587 2011-11-5 642 1110 N643JB
## 588 2011-11-5 1548 2001 N643JB
## 589 2011-11-6 1552 2028 N570JB
## 590 2011-11-7 646 1115 N529JB
## 591 2011-11-7 1559 2032 N529JB
## 592 2011-11-8 632 1049 N526JB
## 593 2011-11-8 1543 2002 N526JB
## 594 2011-11-9 638 1050 N656JB
## 595 2011-11-9 1603 2017 N590JB
## 596 2011-11-10 632 1039 N662JB
## 597 2011-11-10 1629 2027 N623JB
## 598 2011-11-11 631 1036 N595JB
## 599 2011-11-11 1605 2038 N598JB
## 600 2011-11-12 643 1110 N520JB
## 601 2011-11-12 1639 2101 N520JB
## 602 2011-11-13 1616 2052 N559JB
## 603 2011-11-14 637 1045 N585JB
## 604 2011-11-14 1600 2018 N585JB
## 605 2011-11-15 640 1046 N537JB
## 606 2011-11-15 1624 2033 N632JB
## 607 2011-11-16 631 1039 N588JB
## 608 2011-11-16 1607 2023 N564JB
## 609 2011-11-17 636 1041 N337JB
## 610 2011-11-17 1556 2000 N203JB
## 611 2011-11-18 630 1043 N236JB
## 612 2011-11-18 1546 2008 N183JB
## 613 2011-11-19 637 1104 N198JB
## 614 2011-11-19 1736 2150 N187JB
## 615 2011-11-20 636 1056 N266JB
## 616 2011-11-20 1545 2017 N304JB
## 617 2011-11-21 632 1044 N304JB
## 618 2011-11-21 1555 2003 N309JB
## 619 2011-11-22 631 1045 N337JB
## 620 2011-11-22 1555 2018 N304JB
## 621 2011-11-23 636 1031 N239JB
## 622 2011-11-23 1700 2138 N179JB
## 623 2011-11-24 640 1053 N334JB
## 624 2011-11-25 635 1100 N231JB
## 625 2011-11-25 1546 2015 N641JB
## 626 2011-11-26 635 1045 N236JB
## 627 2011-11-26 1545 2011 N337JB
## 628 2011-11-27 644 1101 N179JB
## 629 2011-11-27 1611 2047 N298JB
## 630 2011-11-28 723 1140 N265JB
## 631 2011-11-28 1602 2014 N236JB
## 632 2011-11-29 634 1052 N193JB
## 633 2011-11-29 1557 2101 N334JB
## 634 2011-11-30 636 1038 N304JB
## 635 2011-11-30 1539 1957 N184JB
## 636 2011-12-1 635 1103 N337JB
## 637 2011-12-1 1542 2012 N229JB
## 638 2011-12-2 635 1051 N184JB
## 639 2011-12-2 1540 1955 N190JB
## 640 2011-12-3 637 1047 N317JB
## 641 2011-12-3 1551 1957 N284JB
## 642 2011-12-4 1607 2031 N318JB
## 643 2011-12-5 636 1046 N304JB
## 644 2011-12-5 1654 2120 N203JB
## 645 2011-12-6 632 1042 N318JB
## 646 2011-12-6 1612 2107 N273JB
## 647 2011-12-7 640 1056 N258JB
## 648 2011-12-7 1548 1944 N273JB
## 649 2011-12-8 634 1055 N298JB
## 650 2011-12-8 1550 2004 N238JB
## 651 2011-12-9 634 1026 N281JB
## 652 2011-12-9 1601 2009 N318JB
## 653 2011-12-10 636 1036 N329JB
## 654 2011-12-10 1549 1953 N328JB
## 655 2011-12-11 1544 2002 N247JB
## 656 2011-12-12 631 1051 N228JB
## 657 2011-12-12 1547 2002 N274JB
## 658 2011-12-13 655 1111 N206JB
## 659 2011-12-13 1544 2011 N238JB
## 660 2011-12-14 639 1059 N306JB
## 661 2011-12-14 1545 2014 N258JB
## 662 2011-12-15 641 1053 N206JB
## 663 2011-12-15 1727 2147 N190JB
## 664 2011-12-16 639 1050 N273JB
## 665 2011-12-16 1608 2014 N249JB
## 666 2011-12-17 641 1038 N247JB
## 667 2011-12-17 1616 2033 N247JB
## 668 2011-12-18 637 1050 N324JB
## 669 2011-12-18 1726 2149 N247JB
## 670 2011-12-19 640 1106 N247JB
## 671 2011-12-19 1543 2004 N292JB
## 672 2011-12-20 647 1059 N292JB
## 673 2011-12-20 1624 2044 N306JB
## 674 2011-12-21 634 1039 N267JB
## 675 2011-12-21 1756 2230 N316JB
## 676 2011-12-22 634 1039 N231JB
## 677 2011-12-22 1640 2053 N306JB
## 678 2011-12-23 633 1038 N284JB
## 679 2011-12-23 1606 2015 N273JB
## 680 2011-12-24 635 1035 N323JB
## 681 2011-12-24 1600 2012 N328JB
## 682 2011-12-25 638 1052 N273JB
## 683 2011-12-25 1608 2013 N192JB
## 684 2011-12-26 633 1046 N216JB
## 685 2011-12-26 1550 2002 N216JB
## 686 2011-12-27 634 1040 N339JB
## 687 2011-12-27 1955 39 N294JB
## 688 2011-12-28 632 1047 N231JB
## 689 2011-12-28 1748 2147 N281JB
## 690 2011-12-29 633 1050 N274JB
## 691 2011-12-29 1541 1959 N206JB
## 692 2011-12-30 634 1040 N317JB
## 693 2011-12-30 1541 1957 N296JB
## 694 2011-12-31 831 1251 N247JB
## 695 2011-12-31 1544 2009 N323JB
ARRANGE
arrange() can be used to rearrange rows according to any type of data. If you pass arrange() a character variable, for example, R will rearrange the rows in alphabetical order according to values of the variable. If you pass a factor variable, R will rearrange the rows according to the order of the levels in your factor (running levels() on the variable reveals this order).
# Definition of dtc
dtc <- filter(hflights, Cancelled == 1, !is.na(DepDelay))
# Arrange dtc by departure delays
a1 <- arrange(dtc, DepDelay)
# Arrange dtc so that cancellation reasons are grouped
a2 <- arrange(dtc, CancellationCode)
# Arrange dtc according to carrier and departure delays
a3 <- arrange(dtc, UniqueCarrier, DepDelay)
By default, arrange() arranges the rows from smallest to largest. Rows with the smallest value of the variable will appear at the top of the data set. You can reverse this behavior with the desc() function. arrange() will reorder the rows from largest to smallest values of a variable if you wrap the variable name in desc() before passing it to arrange().
# Arrange according to carrier and decreasing departure delays
a4 <- arrange(hflights, UniqueCarrier, desc(DepDelay))
# Arrange flights by total delay (normal order).
a5 <- arrange(hflights, (DepDelay+ArrDelay))
# Keep flights leaving to DFW before 8am and arrange according to decreasing AirTime
a6 <- arrange(filter(hflights, Dest=="DFW", DepTime<0800), desc(AirTime))