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.