Domestic <- read.csv("C:/Users/YUSUF SULTAN/AppData/Roaming/SPB_Data/domestic_flights_jan_2016.csv",
header = TRUE , stringsAsFactors = FALSE)
str(Domestic);head(Domestic);tail(Domestic)## 'data.frame': 445827 obs. of 21 variables:
## $ FlightDate : chr "1/6/2016" "1/7/2016" "1/8/2016" "1/9/2016" ...
## $ Carrier : chr "AA" "AA" "AA" "AA" ...
## $ TailNum : chr "N4YBAA" "N434AA" "N541AA" "N489AA" ...
## $ FlightNum : int 43 43 43 43 43 43 43 43 43 43 ...
## $ Origin : chr "DFW" "DFW" "DFW" "DFW" ...
## $ OriginCityName : chr "Dallas/Fort Worth, TX" "Dallas/Fort Worth, TX" "Dallas/Fort Worth, TX" "Dallas/Fort Worth, TX" ...
## $ OriginState : chr "TX" "TX" "TX" "TX" ...
## $ Dest : chr "DTW" "DTW" "DTW" "DTW" ...
## $ DestCityName : chr "Detroit, MI" "Detroit, MI" "Detroit, MI" "Detroit, MI" ...
## $ DestState : chr "MI" "MI" "MI" "MI" ...
## $ CRSDepTime : int 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 ...
## $ DepTime : int 1057 1056 1055 1102 1240 1107 1059 1055 1058 1056 ...
## $ WheelsOff : int 1112 1110 1116 1115 1300 1118 1113 1107 1110 1110 ...
## $ WheelsOn : int 1424 1416 1431 1424 1617 1426 1429 1419 1420 1423 ...
## $ CRSArrTime : int 1438 1438 1438 1438 1438 1438 1438 1438 1438 1438 ...
## $ ArrTime : int 1432 1426 1445 1433 1631 1435 1438 1431 1428 1434 ...
## $ Cancelled : int 0 0 0 0 0 0 0 0 0 0 ...
## $ Diverted : int 0 0 0 0 0 0 0 0 0 0 ...
## $ CRSElapsedTime : int 158 158 158 158 158 158 158 158 158 158 ...
## $ ActualElapsedTime: int 155 150 170 151 171 148 159 156 150 158 ...
## $ Distance : int 986 986 986 986 986 986 986 986 986 986 ...## FlightDate Carrier TailNum FlightNum Origin OriginCityName
## 1 1/6/2016 AA N4YBAA 43 DFW Dallas/Fort Worth, TX
## 2 1/7/2016 AA N434AA 43 DFW Dallas/Fort Worth, TX
## 3 1/8/2016 AA N541AA 43 DFW Dallas/Fort Worth, TX
## 4 1/9/2016 AA N489AA 43 DFW Dallas/Fort Worth, TX
## 5 1/10/2016 AA N439AA 43 DFW Dallas/Fort Worth, TX
## 6 1/11/2016 AA N468AA 43 DFW Dallas/Fort Worth, TX
## OriginState Dest DestCityName DestState CRSDepTime DepTime WheelsOff
## 1 TX DTW Detroit, MI MI 1100 1057 1112
## 2 TX DTW Detroit, MI MI 1100 1056 1110
## 3 TX DTW Detroit, MI MI 1100 1055 1116
## 4 TX DTW Detroit, MI MI 1100 1102 1115
## 5 TX DTW Detroit, MI MI 1100 1240 1300
## 6 TX DTW Detroit, MI MI 1100 1107 1118
## WheelsOn CRSArrTime ArrTime Cancelled Diverted CRSElapsedTime
## 1 1424 1438 1432 0 0 158
## 2 1416 1438 1426 0 0 158
## 3 1431 1438 1445 0 0 158
## 4 1424 1438 1433 0 0 158
## 5 1617 1438 1631 0 0 158
## 6 1426 1438 1435 0 0 158
## ActualElapsedTime Distance
## 1 155 986
## 2 150 986
## 3 170 986
## 4 151 986
## 5 171 986
## 6 148 986## FlightDate Carrier TailNum FlightNum Origin
## 445822 1/3/2016 F9 N934FR 576 SLC
## 445823 1/3/2016 F9 N934FR 579 DEN
## 445824 1/3/2016 F9 N934FR 720 DEN
## 445825 1/3/2016 F9 N935FR 444 DEN
## 445826 1/3/2016 F9 N935FR 445 FSD
## 445827 1/3/2016 F9 N935FR 693 CID
## OriginCityName OriginState Dest DestCityName
## 445822 Salt Lake City, UT UT DEN Denver, CO
## 445823 Denver, CO CO SLC Salt Lake City, UT
## 445824 Denver, CO CO DCA Washington, DC
## 445825 Denver, CO CO FSD Sioux Falls, SD
## 445826 Sioux Falls, SD SD DEN Denver, CO
## 445827 Cedar Rapids/Iowa City, IA IA DEN Denver, CO
## DestState CRSDepTime DepTime WheelsOff WheelsOn CRSArrTime ArrTime
## 445822 CO 1449 1450 1500 1600 1609 1616
## 445823 UT 1245 1240 1249 1353 1409 1404
## 445824 VA 1649 1728 1745 2233 2159 2241
## 445825 SD 1020 1038 1050 1255 1250 1301
## 445826 CO 1335 1358 1408 1417 1426 1429
## 445827 CO 1909 1900 1920 1953 2029 2000
## Cancelled Diverted CRSElapsedTime ActualElapsedTime Distance
## 445822 0 0 80 86 391
## 445823 0 0 84 84 391
## 445824 0 0 190 193 1476
## 445825 0 0 90 83 483
## 445826 0 0 111 91 483
## 445827 0 0 140 120 692library(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, unionDomestic %>% filter((!complete.cases(.))) %>% head()## FlightDate Carrier TailNum FlightNum Origin OriginCityName OriginState
## 1 1/16/2016 AA N3CXAA 44 SEA Seattle, WA WA
## 2 1/23/2016 AA 44 SEA Seattle, WA WA
## 3 1/24/2016 AA N3DGAA 44 SEA Seattle, WA WA
## 4 1/25/2016 AA N3MNAA 44 SEA Seattle, WA WA
## 5 1/15/2016 AA N3JSAA 45 JFK New York, NY NY
## 6 1/23/2016 AA 45 JFK New York, NY NY
## Dest DestCityName DestState CRSDepTime DepTime WheelsOff WheelsOn
## 1 JFK New York, NY NY 640 NA NA NA
## 2 JFK New York, NY NY 640 NA NA NA
## 3 JFK New York, NY NY 645 NA NA NA
## 4 JFK New York, NY NY 645 NA NA NA
## 5 SEA Seattle, WA WA 1830 NA NA NA
## 6 SEA Seattle, WA WA 1830 NA NA NA
## CRSArrTime ArrTime Cancelled Diverted CRSElapsedTime ActualElapsedTime
## 1 1501 NA 1 0 321 NA
## 2 1501 NA 1 0 321 NA
## 3 1506 NA 1 0 321 NA
## 4 1506 NA 1 0 321 NA
## 5 2152 NA 1 0 382 NA
## 6 2152 NA 1 0 382 NA
## Distance
## 1 2422
## 2 2422
## 3 2422
## 4 2422
## 5 2422
## 6 2422Note that the echo = FALSE parameter was added to the code chunk to prevent printing of the R code that generated the plot.