Tornadoes

(a) How many tornadoes occurred in WA (Washington) or MS (Mississippi)?

## [1] "Total Tornadoes in MS and WA = 530"


(b) How many tornadoes occurred in WA after 2012?

## [1] "Data for Tornadoes in WA post 2012 =  7"


(c) Get all tornadoes that occurred in WA in 2012, 2013, and 2014.

##        yr mo dy       date     time tz st stf stn    f
## 8217 2013  3 21 2013-03-21 18:00:00  3 WA  53   0 EF-0
## 8851 2013  9 30 2013-09-30 08:20:00  3 WA  53   0 EF-1
## 9150 2014  4 27 2014-04-27 18:30:00  3 WA  53   0 EF-0
## 9747 2014  8 13 2014-08-13 19:30:00  3 WA  53   0 EF-0
## 9884 2014 10 23 2014-10-23 14:40:00  3 WA  53   0 EF-1


(d) Return the ’mo’ (month), ’yr’ (year), and ’f’ (F-scale) for all tornadoes that occurred in HI (Hawaii).

##       st mo   yr    f
## 2766  HI  9 2008 EF-0
## 2842  HI 12 2008 EF-0
## 2878  HI  2 2009 EF-0
## 5371  HI  2 2011 EF-0
## 7359  HI  3 2012 EF-0
## 10093 HI  4 2015 EF-0


(e) Arrange the tornadoes by date and time. What state had the most recent tornado?

##         yr mo dy       date     time tz st stf stn    f
## 11141 2015 12 28 2015-12-28 15:58:00  3 NC  37   0 EF-0
## 11140 2015 12 28 2015-12-28 08:30:00  3 FL  12   0 EF-1
## 11139 2015 12 28 2015-12-28 05:43:00  3 MS  28   0 EF-1
## 11138 2015 12 28 2015-12-28 04:46:00  3 AR   5   0 EF-2
## 11137 2015 12 28 2015-12-28 03:20:00  3 LA  22   0 EF-1
## 11136 2015 12 28 2015-12-28 02:53:00  3 LA  22   0 EF-1
## 11135 2015 12 27 2015-12-27 23:10:00  3 LA  22   0 EF-1
## 11134 2015 12 27 2015-12-27 20:16:00  3 LA  22   0 EF-1
## 11133 2015 12 27 2015-12-27 20:10:00  3 LA  22   0 EF-1
## 11132 2015 12 27 2015-12-27 18:06:00  3 AR   5   0 EF-1
## 11131 2015 12 27 2015-12-27 17:09:00  3 TX  48   0 EF-1
## 11130 2015 12 27 2015-12-27 17:06:00  3 AR   5   0 EF-1
## 11129 2015 12 27 2015-12-27 16:39:00  3 TX  48   0 EF-2
## 11128 2015 12 27 2015-12-27 16:36:00  3 AR   5   0 EF-1
## 11127 2015 12 27 2015-12-27 15:56:00  3 AR   5   0 EF-1
## 11126 2015 12 27 2015-12-27 15:36:00  3 AR   5   0 EF-1
## 11125 2015 12 27 2015-12-27 15:32:00  3 AR   5   0 EF-1
## 11124 2015 12 27 2015-12-27 15:24:00  3 TX  48   0 EF-1
## 11123 2015 12 27 2015-12-27 15:06:00  3 TX  48   0 EF-0
## 11122 2015 12 26 2015-12-26 19:33:00  3 TX  48   0 EF-1
## [1] "Place with most recent number of tornadoes = NC"


(f) Get the count of tornadoes by months.

## [1] "Month = 1  Tornadoes = 355"
## [1] "Month = 2  Tornadoes = 463"
## [1] "Month = 3  Tornadoes = 751"
## [1] "Month = 4  Tornadoes = 2171"
## [1] "Month = 5  Tornadoes = 2500"
## [1] "Month = 6  Tornadoes = 1899"
## [1] "Month = 7  Tornadoes = 861"
## [1] "Month = 8  Tornadoes = 517"
## [1] "Month = 9  Tornadoes = 401"
## [1] "Month = 10  Tornadoes = 525"
## [1] "Month = 11  Tornadoes = 350"
## [1] "Month = 12  Tornadoes = 348"


Airlines

(a) Subset: Find the carrier (UniqueCarrier), the flight number (FlightNum), and origin (origin) of all the flights that:


i. Departed (DepTime) after 10pm and flew (Dest) to Nashville (’BNA’).

##       UniqueCarrier FlightNum Origin
## NA             <NA>        NA   <NA>
## 7021             OH      5421    CVG
## NA.1           <NA>        NA   <NA>
## 17401            AA      2435    ORD
## 19478            DH      7332    ORD


ii. departed (DepTime) after 10pm, but Originated (Origin) from Nashville ’BNA’ or landed (Dest) in Memphis ’MEM’. If you don’t get a list of four flight, something is wrong.

##       UniqueCarrier FlightNum Origin DepTime Dest
## 2392             WN      1447    BNA    2218  AUS
## NA             <NA>        NA   <NA>      NA <NA>
## 8169             OO      6838    ORD    2201  MEM
## 10405            DL       579    ATL    2217  MEM
## NA.1           <NA>        NA   <NA>      NA <NA>
## NA.2           <NA>        NA   <NA>      NA <NA>
## NA.3           <NA>        NA   <NA>      NA <NA>
## NA.4           <NA>        NA   <NA>      NA <NA>
## 19352            DH      6270    CVG    2313  MEM


iii. were delayed (ArrDelay) by more two hours. Note that a negative delay is a flight that arrived early.

##    UniqueCarrier FlightNum Origin ArrDelay
## 5             UA       427    ORD        8
## 8             UA       429    DEN      102
## 17            UA       435    DEN        3
## 23            UA       438    ORD       78
## 26            UA       441    DTW       63
## 27            UA       441    ORD      124
## 31            UA       446    ORD       30
## 32            UA       446    SLC       15
## 33            UA       447    DEN       19
## 34            UA       448    DEN       40
## 37            UA       449    MSP       20
## 41            UA       452    ORD        3
## 44            UA       456    IAH       72
## 45            UA       456    ORD       66
## 46            UA       456    SFO        5
## 47            UA       458    DEN       17
## 48            UA       459    PDX       18
## 49            UA       460    SFO       35
## 50            UA       461    DEN        4
## 53            UA       463    ORD       18


iv. arrived (ArrDelay) more than two hours late, but didn’t leave late (DepDelay)

##     UniqueCarrier FlightNum Origin ArrDelay DepDelay
## 17             UA       435    DEN        3       -1
## 34             UA       448    DEN       40       -6
## 41             UA       452    ORD        3       -5
## 46             UA       456    SFO        5       -7
## 47             UA       458    DEN       17       -1
## 48             UA       459    PDX       18       -2
## 50             UA       461    DEN        4        0
## 60             UA       468    ORD       24       -2
## 64             UA       470    PHX       11       -1
## 68             UA       472    ORD       26       -4
## 76             UA       479    IAD        9       -3
## 103            UA       502    IAD        3       -2
## 109            UA       506    SAN       19       -8
## 115            UA       511    DEN        5       -2
## 124            UA       517    FLL        7        0
## 125            UA       517    ORD       39       -2
## 131            UA       522    ORD       18       -5
## 133            UA       523    DEN       10       -3
## 136            UA       526    ORD        3       -6
## 140            UA       529    ORD        5        0


(b) Arrange: make use of minus sign in front of the function to reverse order() and the function head() to get the relevant part: (Use the Airline data)

i. Sort flights to find the 5 most delayed (DepDelay) flights

##       UniqueCarrier FlightNum Origin DepDelay
## 5884             NW      1816    MDW     1080
## 11220            DL      1603    MSP      324
## 14475            MQ      4072    ORD      304
## 15132            NW       180    LAX      301
## 16220            AA      1035    MCO      297


ii. Sort flights to find the 5 least delayed (DepDelay) flights

##       UniqueCarrier FlightNum Origin DepDelay
## 14202            MQ      3647    DFW      -26
## 6293             OH      5260    RIC      -24
## 5109             NW       707    GTF      -22
## 16874            AA      1685    HOU      -21
## 5983             NW      1926    MDW      -20


iii. Sort flights by destination (Dest) and break ties by descending arrival delay (ArrDelay)

##       UniqueCarrier FlightNum Origin Dest ArrDelay
## 19583            DH      7442    ORD  ABE      120
## 8513             XE      2460    CLE  ABE       55
## 19679            DH      7546    ORD  ABE       27
## 6398             OH      5533    CVG  ABE       12
## 8331             XE      2431    CLE  ABE        5
## 5150             NW       766    DTW  ABE        4
## 6899             OH      5312    ATL  ABE        2
## 19403            DH      7248    ORD  ABE        0
## 19897            DH      7861    IAD  ABE       -2
## 5954             NW      1898    DTW  ABE       -4
## 8430             XE      2934    CLE  ABE       -4
## 6060             OH      5541    CVG  ABE       -6
## 6642             OH      5535    CVG  ABE       -7
## 6989             OH      5540    ATL  ABE       -7
## 1075             US       950    CLT  ABE       -8
## 5950             NW      1894    DTW  ABE       -9
## 9290             XE      2163    CLE  ABE      -10
## 6333             OH      5531    ATL  ABE      -11
## 6860             OH      5539    CVG  ABE      -12
## 19921            DH      7886    IAD  ABE      -12
## 19742            DH      7664    IAD  ABE      -14
## 6675             OH      5537    ATL  ABE      -25
## 19837            DH      7798    IAD  ABE      -26
## 8189             OO      9521    IAH  ABI        0
## 13950            MQ      3287    DFW  ABI       -6
## 13960            MQ      3301    DFW  ABI       -8
## 14252            MQ      3717    DFW  ABI       -8
## 13958            MQ      3299    DFW  ABI       -9
## 14295            MQ      3765    DFW  ABI      -11
## 9239             XE      3491    IAH  ABI      -12

Ishaan Jain 657473542