Aan de slagGa gratis aan de slag

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.

Deze oefening maakt deel uit van de cursus

Data Manipulation in Julia

Cursus bekijken

Oefeninstructies

  • 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.

Praktische interactieve oefening

Probeer deze oefening eens door deze voorbeeldcode in te vullen.

# 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
Code bewerken en uitvoeren