Get startedGet started for free

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

View Course

Exercise instructions

  • Start a @chain macro for the flights 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
Edit and Run Code