library(tidyr)
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
url <- 'https://raw.githubusercontent.com/SyedHasanMafi/Data-607/main/airlinedata.csv'
airline_data <- read.table(url, header=TRUE, sep=",", na.strings = c("", "NA"))
airline_data
## X X.1 Los.Angeles Phoenix San.Diego San.Francisco Seattle
## 1 ALASKA on time 497 221 212 503 1,841
## 2 <NA> delayed 62 12 20 102 305
## 3 <NA> <NA> NA <NA> NA NA <NA>
## 4 AM WEST on time 694 4,840 383 320 201
## 5 <NA> delayed 117 415 65 129 61
colnames(airline_data) [1] <- "Airline"
colnames(airline_data) [2] <- "Arrival_Status"
airline_data
## Airline Arrival_Status Los.Angeles Phoenix San.Diego San.Francisco Seattle
## 1 ALASKA on time 497 221 212 503 1,841
## 2 <NA> delayed 62 12 20 102 305
## 3 <NA> <NA> NA <NA> NA NA <NA>
## 4 AM WEST on time 694 4,840 383 320 201
## 5 <NA> delayed 117 415 65 129 61
airline_data <- airline_data[rowSums(is.na(airline_data)) != ncol(airline_data), ]
airline_data
## Airline Arrival_Status Los.Angeles Phoenix San.Diego San.Francisco Seattle
## 1 ALASKA on time 497 221 212 503 1,841
## 2 <NA> delayed 62 12 20 102 305
## 4 AM WEST on time 694 4,840 383 320 201
## 5 <NA> delayed 117 415 65 129 61
airline_data_long <- gather(airline_data, City, Num_Flights, Los.Angeles:Seattle, factor_key=TRUE)
airline_data_long
## Airline Arrival_Status City Num_Flights
## 1 ALASKA on time Los.Angeles 497
## 2 <NA> delayed Los.Angeles 62
## 3 AM WEST on time Los.Angeles 694
## 4 <NA> delayed Los.Angeles 117
## 5 ALASKA on time Phoenix 221
## 6 <NA> delayed Phoenix 12
## 7 AM WEST on time Phoenix 4,840
## 8 <NA> delayed Phoenix 415
## 9 ALASKA on time San.Diego 212
## 10 <NA> delayed San.Diego 20
## 11 AM WEST on time San.Diego 383
## 12 <NA> delayed San.Diego 65
## 13 ALASKA on time San.Francisco 503
## 14 <NA> delayed San.Francisco 102
## 15 AM WEST on time San.Francisco 320
## 16 <NA> delayed San.Francisco 129
## 17 ALASKA on time Seattle 1,841
## 18 <NA> delayed Seattle 305
## 19 AM WEST on time Seattle 201
## 20 <NA> delayed Seattle 61
airline_data_long2 <- airline_data_long %>% mutate(Airline = as.character(na_if(Airline, 'NA'))) %>% fill(Airline, .direction = 'down')
airline_data_long2
## Airline Arrival_Status City Num_Flights
## 1 ALASKA on time Los.Angeles 497
## 2 ALASKA delayed Los.Angeles 62
## 3 AM WEST on time Los.Angeles 694
## 4 AM WEST delayed Los.Angeles 117
## 5 ALASKA on time Phoenix 221
## 6 ALASKA delayed Phoenix 12
## 7 AM WEST on time Phoenix 4,840
## 8 AM WEST delayed Phoenix 415
## 9 ALASKA on time San.Diego 212
## 10 ALASKA delayed San.Diego 20
## 11 AM WEST on time San.Diego 383
## 12 AM WEST delayed San.Diego 65
## 13 ALASKA on time San.Francisco 503
## 14 ALASKA delayed San.Francisco 102
## 15 AM WEST on time San.Francisco 320
## 16 AM WEST delayed San.Francisco 129
## 17 ALASKA on time Seattle 1,841
## 18 ALASKA delayed Seattle 305
## 19 AM WEST on time Seattle 201
## 20 AM WEST delayed Seattle 61
#airline_data_transform %>% spread(airline_data_long2, Arrival_Status, Num_Flights)
airline_data_transform <- airline_data_long2 %>% spread(Arrival_Status, Num_Flights)
#changing name of delayed and on time columns for analysis
colnames(airline_data_transform) [3] <- "Delayed"
colnames(airline_data_transform) [4] <- "On_Time"
airline_data_transform
## Airline City Delayed On_Time
## 1 ALASKA Los.Angeles 62 497
## 2 ALASKA Phoenix 12 221
## 3 ALASKA San.Diego 20 212
## 4 ALASKA San.Francisco 102 503
## 5 ALASKA Seattle 305 1,841
## 6 AM WEST Los.Angeles 117 694
## 7 AM WEST Phoenix 415 4,840
## 8 AM WEST San.Diego 65 383
## 9 AM WEST San.Francisco 129 320
## 10 AM WEST Seattle 61 201
airline_data_transform %>%
group_by(Airline) %>%
dplyr::summarise(max = max(Delayed),
min=min(Delayed),
mean=mean(Delayed),
median=median(Delayed),
standard_deviation=sd(Delayed))
## Warning in mean.default(Delayed): argument is not numeric or logical: returning
## NA
## Warning in mean.default(Delayed): argument is not numeric or logical: returning
## NA
## # A tibble: 2 × 6
## Airline max min mean median standard_deviation
## <chr> <chr> <chr> <dbl> <chr> <dbl>
## 1 ALASKA 62 102 NA 20 120.
## 2 AM WEST 65 117 NA 415 147.
Conclusion : After thoroughly cleaning and analyzing the data, it is evident that AM WEST performs more poorly than Alaska. This is evident in the higher mean and median delay times, along with greater maximum and minimum delay times for AM WEST. Additionally, the higher standard deviation for AM WEST indicates increased variability in delay times compared to Alaska. Collectively, these observations suggest an overall unfavorable experience for travelers with AM WEST.