Airline Excercise

Part 1. Reading the csv data

#reading the airline file and storing it locally using airline.df after setting working directory 
airline.df <- read.csv("BOMDELBOM.csv")

Part 2. Listing column names

#R code to list the column names
colnames(airline.df)

##  [1] "FlightNumber"        "Airline"             "DepartureCityCode"  
##  [4] "ArrivalCityCode"     "DepartureTime"       "ArrivalTime"        
##  [7] "Departure"           "FlyingMinutes"       "Aircraft"           
## [10] "PlaneModel"          "Capacity"            "SeatPitch"          
## [13] "SeatWidth"           "DataCollectionDate"  "DateDeparture"      
## [16] "IsWeekend"           "Price"               "AdvancedBookingDays"
## [19] "IsDiwali"            "DayBeforeDiwali"     "DayAfterDiwali"     
## [22] "MarketShare"         "LoadFactor"

Part 3. Dimension of data frame

#R code to output the dimensions of the data frame
dim(airline.df)

## [1] 305  23

Part 3. Mean and Standard Deviation of Capacity and FlyingMinutes

#R code to find the mean and standard deviation of Capacity and FlyingMinutes
mean(airline.df$FlyingMinutes)

## [1] 136.0328

mean(airline.df$Capacity)

## [1] 176.3574

sd(airline.df$FlyingMinutes)

## [1] 4.705006

sd(airline.df$Capacity)

## [1] 32.38868