Delays on US airports
Now that you have successfully loaded, joined, and cleaned the DataFrame, it's time to find which airport in the US is best to avoid!
The flights
DataFrame you created in the last exercise has been loaded for you.
flights
contains, among others, the following columns important for this exercise:
airport
, containing the starting airport of the flight;departure_delay
, containing the number of minutes of delay at departure.
DataFrames
, Statistics
, and Chain
packages have been loaded for you.
This exercise is part of the course
Data Manipulation in Julia
Exercise instructions
- Start a
@chain
macro for theflights
DataFrame. - Group flights by the
airport
column. - Calculate the minimum, median, and maximum departure delay for each airport.
- Sort the result by the median departure delay in descending order.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Start a chain macro
____
# Group by airport
____
# Calculate the minimum, median, and maximum departure delay
____
# Sort by median departure delay in descending order
____
println(first(_,5))
end